My Oracle Support Banner

2018-06-21T14:59:42.965-0300 ERROR OGG-02028 Oracle GoldenGate Capture for Oracle, exts_fs.prm: Failed to attach to logmining server Error code 12801, error message: ORA-12801: error signaled in parallel query server P01Q, instance crclnexddbadm01.crc.cor (Doc ID 2415185.1)

Last updated on JULY 16, 2018

Applies to:

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

Symptoms

EXTRACT fails with the below error during startup

 

2018-06-21T14:59:42.965-0300 ERROR OGG-02028 Oracle GoldenGate Capture for Oracle, exts_fs.prm: Failed to attach to logmining server Error code 12801, error message: ORA-12801: error signaled in parallel query server P01Q, instance crclnexddbadm01.crc.corp:FUSION1 (1)
ORA-04031: unable to allocate 704 bytes of shared memory ("shared pool","unknown object","PX subheap","qref (kxfpqr)")
ORA-06512: at "SYS.DBMS_STATS", line 34634
ORA-06512: at "SYS.LOGMNR_KRVRDLUID3", line 1644

 

++++++++++++++++++++++++++++++++++

 

But when few of the memory parameters (like streams_pool_size )are modified appropriately the error changed to below


8-06-21T15:48:05.488-0300  ERROR   OGG-02028  Oracle GoldenGate Capture for Oracle, exts_fs.prm:  Failed to attach to logmining server Error code 12801, error message: ORA-12801: error signaled in parallel query server P044, instance crclnexddbadm02.crc.corp:FUSION2 (2)
                             ORA-12853: insufficient memory for PX buffers: current 11328512K, max needed 19233024K
                             ORA-04031: unable to allocate 65560 bytes of shared memory ("large pool","unknown object","large pool","PX msg pool")
                             ORA-06512: at "SYS.DBMS_STATS", line 34634
                             ORA-06512: at "SYS.LOGMNR_KRVRDLUID3", line 1644
                             ORA-06512: at "SYS.LOGMNR_KRVRDLUID3", line 2011
                             ORA-06512: at line 1.
2018-06-21T15:48:05.488-0300  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, exts_fs.prm:  PROCESS ABENDING.


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!


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