My Oracle Support Banner

OGG-08221 Cannot register or unregister EXTRACT <group_name> because of the following SQL error: OCI Error 1,631 (Doc ID 2663179.1)

Last updated on APRIL 24, 2020

Applies to:

Oracle GoldenGate - Version 12.1.2.0.0 to 19.1.0.0.4 [Release 12.1 to 12.3]
Oracle Database - Enterprise Edition - Version 11.2.0.1 to 19.6.0.0.0 [Release 11.2 to 19]
Information in this document applies to any platform.

Symptoms

Attempting to register the extract process fails:

GGSCI (<host>) 1> dblogin userid <ggadmin>, password <password>
Successfully logged into database.

GGSCI (<host> as <ggadmin>@<SID>) 2> register extract <group_name> database

2020-04-24 14:35:38 ERROR OGG-08221 Cannot register or unregister EXTRACT <group_name> because of the following SQL error: OCI Error 1,631.

2020-04-24 14:35:38 ERROR OGG-02042 OCI Error 1,631.

 

The database alert.log shows:

.

.

Fri Apr 24 14:48:51 2020
Logminer Bld: Lockdown Complete. DB_TXN_SCN is 0 593846 LockdownSCN is 593846
ORA-1631: max # extents 505 reached in table SYS.LOGMNRG_COL$
Fri Apr 24 14:48:52 2020
Logminer Bld: FAILED, status is -1631 position is 11

.

.

 

In a similar way, attempting to run dbms_logmnr_d.build fails:

 

SQL> EXECUTE dbms_logmnr_d.build( options => dbms_logmnr_d.store_in_redo_logs);
BEGIN dbms_logmnr_d.build( options => dbms_logmnr_d.store_in_redo_logs); END;

*
ERROR at line 1:
ORA-01631: max # extents (505) reached in table SYS.LOGMNRG_COL$

 

 

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.