GoldenGate Extract Abends Multiple Times a Day With OGG-00665 and ORA-3113 Errors
Last updated on JANUARY 25, 2017
Applies to:Oracle GoldenGate - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
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 -
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.
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