Extract Unregister Fails With OCI Error 'ORA-26672: timeout occurred while stopping GoldenGate process OGG$CAP_EXT' (Doc ID 3038120.1)

Last updated on JULY 29, 2024

Applies to:

Symptoms

Unregister of OGG Extract fails with below error,

ggsci> dblogin useridalias *********
ggsci> unregister extract EXT, database.

ERROR OGG-08221 Oracle GoldenGate Command Interpreter for Oracle: Cannot register or unregister EXTRACT EXT because of the following
SQL error:  OCI Error ORA-26672: timeout occurred while stopping GoldenGate process OGG$CAP_EXT
  ORA-06512: at "SYS.DBMS_XSTREAM_ADM_UTL", line 2039
  ORA-06512: at "SYS.DBMS_LOGREP_UTIL", line 1400
  ORA-06512: at "SYS.DBMS_CAPTURE_ADM", line 106
  ORA-06512: at "SYS.DBMS_XSTREAM_ADM_UTL", line 2028
  ORA-06512: at "SYS.DBMS_XSTREAM_GG_ADM", line 858
  ORA-06512: at line 1
  (status = 26672).

Changes

 N/A

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.