Manual cleanup of extract process from the database for Goldengate

When removing an extract process, it has to be first unregistered from the database.

In this case, it was not unregistered properly, so we need to clear it manually.

Please find the list of steps to do that.

SYS@ORCL>>select CAPTURE_NAME,QUEUE_NAME,QUEUE_OWNER,CAPTURE_USER,START_SCN,STATUS,STATUS_CHANGE_TIME,PURPOSE  from dba_capture;

CAPTURE_NAME      QUEUE_NAME      QUEUE_OWNER CAPTURE_USER            START_SCN STATUS   STATUS_CHANGE_TIME       PURPOSE
—————– ————— ———– ———— ——————– ——– ———————— ——————-
GG$CAP_REPCPR      GG$Q_REPCPR     GGOWNER     GGOWNER              23987613411 DISABLED 15-SEP-2018 12:12:29     GoldenGate Capture

SYS@ORCL>>exec DBMS_CAPTURE_ADM.DROP_CAPTURE (‘GG$CAP_REPCPR’);

PL/SQL procedure successfully completed.

SYS@ORCL>>select  CAPTURE_NAME,QUEUE_NAME,QUEUE_OWNER,CAPTURE_USER,START_SCN,STATUS,STATUS_CHANGE_TIME,PURPOSE  from dba_capture;

no rows selected

SYS@ORCL>>execute DBMS_STREAMS_ADM.REMOVE_STREAMS_CONFIGURATION();

PL/SQL procedure successfully completed.

  • September 25, 2018 | 19 views
  • Comments