GoldenGate Extract Abends Multiple Times a Day With OGG-00665 and ORA-3113 Errors
(Doc ID 1920395.1)
Last updated on MAY 22, 2023
Applies to:
Oracle GoldenGate - Version 11.2.0.0.0 and laterInformation 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, <EXTRACT_NAME>.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, <EXTRACT_NAME>.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, <EXTRACT_NAME>.prm: PROCESS ABENDING.
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, <EXTRACT_NAME>.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, <EXTRACT_NAME>.prm: PROCESS ABENDING.
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! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |