My Oracle Support Banner

Integrated Replicat Abends due to ORA-3114 and ORA-4031 for Streams Pool Appears in Alert.log of Oracle Database (Doc ID 2937391.1)

Last updated on MAY 18, 2023

Applies to:

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


Integrated Replicat abends due to ORA-3114 and below errors appear in ggserr.log.

<example of messages in ggserr.log >
ERROR   OGG-00664  Oracle GoldenGate Delivery for Oracle, <Replicat>.prm:  OCI Error ORA-03114: not connected to ORACLE (status = 3114- Sending data database inbound server, 'OGG$<Replicat>').
INFO    OGG-02932  Oracle GoldenGate Delivery for Oracle, <Replicat>.prm:  Reading <Trail File>, current SEQNO xxx, RBA xxx,xxx,xxx, xx,xxx,xxx records, m_file_seqno = xxx, m_file_rba = xxx,xxx,xxx.
ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle, <Replicat>.prm:  PROCESS ABENDING.

In alert.log of Oracle Database, ORA-4031 is recoeded against streams pool but free memory still remains in streams pool.

< example of message in DB alert.log >
ORA-04031: unable to allocate 104 bytes of shared memory("streams pool"、"unknown object"、"apply shared t"、"217.kggec")


This problem may happen when following all conditions are satisfied.


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

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