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
Problem
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');
Solution
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.