Monday, March 30, 2015

OGG-01755 or OGG-01759

2015-03-29 01:55:00  ERROR   OGG-01755  Oracle GoldenGate Command Interpreter for Oracle:  Cannot register or unregister EXTRACT E0000019 because of the following SQL error: OCI Error 26,665. See Extract user privileges in the Oracle GoldenGate for Oracle Installation and Setup Guide.

2015-03-29 00:03:53  ERROR   OGG-01759  Oracle GoldenGate Command Interpreter for Oracle:  Cannot unregister EXTRACT E0000019 from database because this Extract is not currently registered


We are not able to clean up or remove the Integrated Exact from the Golden Gate after removing it manually.

Mainly check the below object
select owner,object_name,object_type,status from dba_objects where object_name in ('DDLREPLICATION','DBMS_CAPTURE_ADM_INTERNAL');

1)     Check whether all the sys object are valid.
2)     Check whether all the goldengate user objects are valid; you need to re-create but check with oracle support or oracle documentation.

Couple of useful queries

To check the current capturing extract in your environment.
select capture_name,status from dba_capture;

To stop the Extract

SQL> exec dbms_capture_adm.stop_capture('OGG$CAP_E0000019',true);

PL/SQL procedure successfully completed.

To Drop the Extract from the Registry

SQL> exec dbms_capture_adm.drop_capture('OGG$CAP_E0000019',true);

PL/SQL procedure successfully completed.

Note: Check with oracle support, if you want to make some changes in the production environment.