Register Extract Fails With OGG-08221 ORA-24003 Queue Table Index GOLDGATE.AQ$_OGG$Q_TAB_<EXT_NAME>_I Inconsistent With Queue Table (Doc ID 2890108.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

While registering integrated extract fails with below errors:


GGSCI (test) > dblogin userid <gguser> password <gguser>

GGSCI (test.xxxxx.com as goldgate@test) > REGISTER EXTRACT <EXT_NAME> ,database

2022-08-16 05:35:14 ERROR OGG-08221 Cannot register or unregister EXTRACT <EXT_NAME> because of the following SQL error: OCI Error ORA (status = 24003-ORA-24003: Queue table index GOLDGATE.AQ$_OGG$Q_TAB_<EXT_NAME>_I inconsistent with queue table GOLDGATE.OGG$Q_TAB_<EXT_NAME>
ORA-06512: at "SYS.DBMS_STREAMS_ADM_IVK", line 766
ORA-06512: at "SYS.DBMS_AQADM", line 747
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 8626
ORA-06512: at "SYS.DBMS_AQADM_SYSCALLS", line 926
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 8536
ORA-06512: at "SYS.DBMS_AQADM", line 742
ORA-06512: at "SYS.DBMS_STREAMS_ADM_IVK", line 761
ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 269
ORA-06512: at line 1
).

Cause

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