My Oracle Support Banner

Unable To Register OGG Extract (Doc ID 2861271.1)

Last updated on JULY 20, 2024

Applies to:

Oracle GoldenGate - Version 11.1.1.0.8 and later
Information in this document applies to any platform.

Symptoms

Unable to register OGG extract

GGSCI 5> register extract <EXTNAME> database container (<Container name>)
ERROR OGG-08221 Cannot register or unregister EXTRACT <EXTNAME> because of the following SQL error: OCI Error ORA (status = 1-ORA-00001: unique constraint (SYSTEM.LOGMNR_SESSION_UK1) violated
ORA-06512: at "SYS.DBMS_CAPTURE_ADM_INTERNAL", line 617
ORA-06512: at "SYS.DBMS_CAPTURE_ADM_INTERNAL", line 249
ORA-06512: at "SYS.DBMS_CAPTURE_ADM_INTERNAL", line 589
ORA-06512: at "SYS.DBMS_CAPTURE_ADM_IVK", line 177
ORA-06512: at "SYS.DBMS_CAPTURE_ADM", line 179

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution


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