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 19.1.0.0.0 and later
Information in this document applies to any platform.

Symptoms

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")

Changes

This problem may happen when following all conditions are satisfied.

Target Database is Oracle, and DBRU 19.12.0 - 19.15.0 or DBRU 21.3.0 - 21.7.0 are applied.
Replicat is configured as Integrated Replicat.
ORA-4031 for streams pool happens on Database.

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

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

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

Applies to:

Symptoms

Changes

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!