Wednesday, December 07, 2016

GoldenGate fails with OGG-08221 Cannot register or unregister EXTRACT because of the following SQL error: OCI Error 1,031.

Problem:

When trying to register an extract in GoldenGate ggsci, the following error is returned:
OGG-08221 Cannot register or unregister EXTRACT <some_name> because of the following SQL error: OCI Error 1,031.

Solution:

The cause of this issue is the database initialization parameter THREADED_EXECUTION=TRUE
The solution is the same as in my other post here.

No comments: