ERROR OGG-02028 Oracle GoldenGate Capture for Oracle, extract-name.prm: Failed to attach to logmining server Error code 12801, error message: ORA-12801: error signaled in parallel query server P01Q, instance XXXXXXX.XXX.XXX
(Doc ID 2415185.1)
Last updated on OCTOBER 03, 2022
Applies to:
Oracle GoldenGate - Version 12.3.0.1.3 and laterInformation 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, extract-name.prm: Failed to attach to logmining server Error code 12801, error message: ORA-12801: error signaled in parallel query server P01Q, instance XXXXXX.XXX.XXX: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, extract-name.prm: Failed to attach to logmining server Error code 12801, error message: ORA-12801: error signaled in parallel query server P044, instance XXXXXX.XXX.XXX: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, extract-name.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! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |