Downstream Integrated Extract Failing With OGG-08221 Cannot Register Or Unregister EXTRACT Because Of The Following SQL Error: OCI Error 23,605
Last updated on FEBRUARY 17, 2017
Applies to:Oracle GoldenGate - Version 18.104.22.168.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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms