Execute the relevant script from < Doc ID 1448324.1 > and look for old capture and queue table entries relating to the Extract you are attempting to register.
These entries will have the <EXTRACT_NAME> in the definition
connect owning_user/password
spool drop_old.out
BEGIN
DBMS_CAPTURE_ADM.DROP_CAPTURE(capture_name => 'OGG$CAP_<EXTRACT_NAME>');
END;
/
exec DBMS_AQADM.DROP_QUEUE_TABLE(queue_table => 'OGG$Q_TAB_<EXTRACT_NAME>', force => TRUE);
=================================================================================
SQL> exec DBMS_XSTREAM_GG_ADM.STOP_OUTBOUND('OGG$EXTRACT_NAME',true);
SQL> exec DBMS_XSTREAM_ADM.DROP_OUTBOUND('OGG$EXTRACT_NAME');
SQL> exec DBMS_STREAMS_ADM.REMOVE_QUEUE(queue_name => 'GGMINING.OGG$Q_EXTRACT_NAME', cascade => true, drop_unused_queue_table => true);
Check if extract exists or not with the following queries.
SQL> select * from DBA_XSTREAM_OUTBOUND;
SQL> select * from SYS.XSTREAM$_SERVER;
If you use the Container Database and Pluggable database then Rename the GLOBAL_NAME of the PDB so it’s different from the CDB GLOBAL_NAME.
Or If Supplemental log isn’t enable at the database level, then enable it as follows.
SQL> ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
Do you want to learn Oracle Goldengate from scratch, then read the following Goldengate Tutorial articles.
https://ittutorial.org/goldengate-tutorials-oracle-for-beginners/
1,916 views last month, 2 views today
Categories: Goldengate
Tags: ALTER DATABASE ADD SUPPLEMENTAL LOG DATA, Cannot register or unregister EXTRACT, logminer bld failed status is position is 11, oci error retrieving bind info for query (status = 100), ogg 01754, ogg 01891 extract must first be deleted before it can be registered, ogg-02064, OGG-08221, OGG-08221 Cannot register or unregister EXTRACT, ogg-08221 cannot register or unregister extract because of the following sql error: oci error, oracle goldengate ogg-08221
Leave스