Downstream Integrated Extract Failing With OGG-08221 Cannot Register Or Unregister EXTRACT Because Of The Following SQL Error: OCI Error 23,605
(Doc ID 2226423.1)
Last updated on MAY 30, 2018
Applies to:Oracle GoldenGate - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
When trying to REGISTER or UNREGISTER a Downstream Integrated Extract it fails with OCI Error 23,605:
Successfully logged into database.
GGSCI > miningdblogin useridalias ggsm
Successfully logged into mining database.
GGSCI > REGISTER EXTRACT EXT1 DATABASE
2016-12-12 11:37:06 ERROR OGG-08221 Cannot register or unregister EXTRACT EXT1 because of the following SQL error: OCI Error 23,605.
Changed the Database Global Name for the Source or Downstream database.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!