GoldenGate Extract Abends Multiple Times a Day With OGG-00665 and ORA-3113 Errors (Doc ID 1920395.1)

Last updated on JANUARY 25, 2017

Applies to:

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

Symptoms

Golden Gate replication is set up using downstream integrated capture. The mining extract abends several times a day with an ORA-3113 error on an OCI single row select. The query is not always the same. This started happening after the source database was migrated to a new data center. The source database server and the mining database server are in the same data center.
The ggserr.log shows messages -

2014-07-26 15:04:30  ERROR   OGG-00665  Oracle GoldenGate Capture for Oracle, e02_inpc.prm:  OCI Error executing single row select (status = 3113-ORA-03113: end-of-file on communication channel
Process ID: 31626
Session ID: 393 Serial number: 16333), SQL< SELECT u.name,         o.name, o.dataobj#, o.type#,         (SELECT bitand(t.property, 1)          FROM sys.tab$ t          WHERE t.obj# = :ora_object_id)    FROM sys.obj$ o,         sys.user$ u   WHERE o.obj# = :ora_object_id     AND decode(bitand(o.flags, 128), 128, 'YES', 'NO') = 'NO'     AND o.owner# = u.user#     AND decode(bitand(o.flags, 16), 0, 'N', 16, 'Y', 'N') = 'N'    AND (o.type# in (1, 19, 20, 34)          OR          EXISTS (SELECT 'x'                    FROM sys.tab$ t                   WHERE t.obj# = :ora_object_id                     AND decode(bitand(t.property,8192),8192,'YES','NO')='NO'))     AND o.name not like 'OGGQT$%' and o.name not like 'AQ$%'     AND o.name not like 'M%!_%$$' escape '!' >.
2014-07-26 15:04:34  ERROR   OGG-02078  Oracle GoldenGate Capture for Oracle, e02_inpc.prm:  Extract encountered a fatal error in a processing thread and is abending.
2014-07-26 15:04:34  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, e02_inpc.prm:  PROCESS ABENDING.

 

 

Cause

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