Starting OGG Integrated Replicat Leads To Database Crashes With ORA-04031: unable to allocate 3280 bytes of shared memory ("streams pool","unknown object","streams pool","sob_kgqmrec") (Doc ID 2432457.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

Database crashes with ORA-4031 when Integrated Replicat is started

Snippet from the trace

Trace file has the below error

*** 2018-08-01T11:41:52.240637-04:00
*** SESSION ID:(2292.19948) 2018-08-01T11:41:52.240674-04:00
*** CLIENT ID:() 2018-08-01T11:41:52.240679-04:00
*** SERVICE NAME:(SYS$BACKGROUND) 2018-08-01T11:41:52.240685-04:00
*** MODULE NAME:(Streams) 2018-08-01T11:41:52.240691-04:00
*** ACTION NAME:(QMON Slave) 2018-08-01T11:41:52.240696-04:00
*** CLIENT DRIVER:() 2018-08-01T11:41:52.240701-04:00

AUTO MEM: PGA get fail 32 for 63, 29, 4, 33554432, 17146314752, 33554432, 1, 17179869184, 2
2018-08-01T11:41:52.270479-04:00
Incident 432878 created, dump file:<incident trace file>
ORA-04031: unable to allocate 3280 bytes of shared memory ("streams pool","unknown object","streams pool","sob_kgqmrec")

KSV 4031 error in slave process

*** 2018-08-01T11:41:53.234162-04:00
ORA-04031: unable to allocate 3280 bytes of shared memory ("streams pool","unknown object","streams pool","sob_kgqmrec")
OPIRIP: Uncaught error 447. Error stack:
ORA-00447: fatal error in background process
ORA-04031: unable to allocate 3280 bytes of shared memory ("streams pool","unknown object","streams pool","sob_kgqmrec")

Changes

Cause

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