Goldengate Extract Abends With Error ORA-03135: Connection lost contact Process ID: <PID> Session ID: <session ID> Serial number: <Serial Number> (Doc ID 2112219.1)

Last updated on JANUARY 05, 2017

Applies to:

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

Goal

OGG extract abends with error:

2016-02-28 14:16:02 ERROR OGG-00665 OCI Error describe for query (status = 3135-ORA-03135: connection lost contact
Process ID: 56688852
Session ID: 142 Serial number: 50331), SQL< SELECT owner, object_name, object_type FROM dba_objects WHERE object_id = 184467 AND object_type in ('TABLE', 'INDEX', 'INDEX PARTITION', 'TABLE PARTITION', 'TABLE SUBPARTITION', 'SEQUENCE')>
 

Solution

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 hundreds of Community platforms