Encountered following Error while registering integrated extract with database
ERROR OGG-01755 Cannot register or unregister EXTRACT extcbn because of the following SQL error: OCI Error retrieving bind info for query (status = 100). See Extract user privileges in the Oracle GoldenGate for Oracle Installation and Setup Guide
Root Cause as follows
Server crash, rebooted, OGG or database is not shutdown cleanly, the Integrated Extract is left in an indeterminate state
Unregister Extract Manually from database as follows
SQL> exec DBMS_XSTREAM_GG_ADM.STOP_OUTBOUND('OGG$MYEXTRACT',true);
SQL> exec DBMS_XSTREAM_ADM.DROP_OUTBOUND('OGG$MYEXTRACT');
SQL> exec DBMS_STREAMS_ADM.REMOVE_QUEUE(queue_name => 'GGMINING.OGG$Q_MYEXTRACT', cascade => true, drop_unused_queue_table => true);
SQL> exec DBMS_XSTREAM_ADM.DROP_OUTBOUND('OGG$MYEXTRACT');
SQL> exec DBMS_STREAMS_ADM.REMOVE_QUEUE(queue_name => 'GGMINING.OGG$Q_MYEXTRACT', cascade => true, drop_unused_queue_table => true);
If the above works correctly, execute these selects to check.
SQL> select * from DBA_XSTREAM_OUTBOUND;
SQL> select * from SYS.XSTREAM$_SERVER;
Make sure you don't see anything to do with this extract
SQL> select * from SYS.XSTREAM$_SERVER;
Make sure you don't see anything to do with this extract
I got this whole information from METALINK, we have to replace "MYEXTRACT" with your Extract Name
---Nikhil Tatineni---
---Oracle In Memory---
