My Oracle Support Banner

OGG IE abending with ORA-04021: Timeout Occurred While Waiting To Lock Object SYSTEM.LOGMNR_I2TABSUBPART$ (Doc ID 2489007.1)

Last updated on NOVEMBER 25, 2019

Applies to:

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

Symptoms

OGG Version Details,

  

Oracle GoldenGate Capture for Oracle
Version 12.3.0.1.0 OGGCORE_12.3.0.1.0_PLATFORMS_170721.0154_FBO
Linux, x64, 64bit (optimized), Oracle 12c on Jul 21 2017 23:33:48

Database Version:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
PL/SQL Release 12.2.0.1.0 - Production
CORE 12.2.0.1.0 Production
TNS for Linux: Version 12.2.0.1.0 - Production
NLSRTL Version 12.2.0.1.0 - Production

  

  

Newly created Integrated Extract is abending with below error,

2018-12-14 14:09:59 ERROR OGG-02028 Failed to attach to logmining server Error code 1304, error message: ORA-01304: subordinate process error. Check alert and trace logs.

2018-12-14 14:09:59 ERROR OGG-01668 PROCESS ABENDING.

When checking the Trace at the Database level, below was the information we gathered.

*** 2018-12-14T14:09:49.292790+01:00
*** SESSION ID:(21.20488) 2018-12-14T14:09:49.292830+01:00
*** CLIENT ID:() 2018-12-14T14:09:49.292851+01:00
*** SERVICE NAME:(SYS$USERS) 2018-12-14T14:09:49.292866+01:00
*** MODULE NAME:(GoldenGate) 2018-12-14T14:09:49.292879+01:00
*** ACTION NAME:(<Capture_name> - Logminer Builder) 2018-12-14T14:09:49.292892+01:00
*** CLIENT DRIVER:() 2018-12-14T14:09:49.292904+01:00

ORA-04021: timeout occurred while waiting to lock object SYSTEM.LOGMNR_I2TABSUBPART$
ORA-06512: at "SYS.LOGMNR_KRVRDLUID3", line 3589
ORA-06512: at "SYS.LOGMNR_KRVRDLUID3", line 3564
ORA-06512: at "SYS.LOGMNR_KRVRDLUID3", line 575
ORA-06512: at "SYS.LOGMNR_KRVRDLUID3", line 492
ORA-06512: at "SYS.LOGMNR_KRVRDLUID3", line 219
ORA-06512: at "SYS.DBMS_SQL", line 1134
ORA-06512: at "SYS.LOGMNR_KRVRDLUID3", line 205
ORA-06512: at "SYS.LOGMNR_KRVRDLUID3", line 405
ORA-06512: at "SYS.LOGMNR_KRVRDLUID3", line 558
ORA-06512: at "SYS.LOGMNR_KRVRDLUID3", line 558
ORA-06512: at "SYS.LOGMNR_KRVRDLUID3", line 3559
ORA-06512: at "SYS.LOGMNR_KRVRDLUID3", line 3686
ORA-06512: at line 1
OPIRIP: Uncaught error 447. Error stack:
ORA-00447: fatal error in background process
ORA-04021: timeout occurred while waiting to lock object SYSTEM.LOGMNR_I2TABSUBPART$
ORA-06512: at "SYS.LOGMNR_KRVRDLUID3", line 3589
ORA-06512: at "SYS.LOGMNR_KRVRDLUID3", line 3564
ORA-06512: at "SYS.LOGMNR_KRVRDLUID3", line 575
ORA-06512: at "SYS.LOGMNR_KRVRDLUID3", line 492
ORA-06512: at "SYS.LOGMNR_KRVRDLUID3", line 219
ORA-06512: at "SYS.DBMS_SQL", line 1134
ORA-06512: at "SYS.LOGMNR_KRVRDLUID3", line 205
ORA-06512: at "SYS.LOGMNR_KRVRDLUID3", line 405
ORA-06512: at "SYS.LOGMNR_KRVRDLUID3", line 558
ORA-06512: at "SYS.LOGMNR_KRVRDLUID3", line 558
ORA-06512: at "SYS.LOGMNR_KRVRDLUID3", line 3559
ORA-06512: at "SYS.LOGMNR_KRVRDLUID3", line 3686
ORA-06512: at line 1

 

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
References


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