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 17, 2023
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 |