Integrated Extract misses Inserts intermittently for Distributed (XA) Transactions

(Doc ID 2064059.1)

Last updated on MARCH 09, 2018

Applies to:

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


Oracle GoldenGate Capture for Oracle
Version 20635622 OGGCORE_12.
Linux, x64, 64bit (optimized), Oracle 12c on Apr 22 2015 07:52:50

tranlogoptions excludeuser ggs
tranlogoptions integratedparams (max_sga_size 1024, parallelism 2)
tranlogoptions integratedparams (inline_lob_optimization n)
tranlogoptions integratedparams (_CKPT_RETENTION_CHECK_FREQ 3600)

Database Version:
Oracle Database 12c Enterprise Edition Release - 64bit Production

IE misses to capture data leading to Replicat errors 
2015-07-19 10:30:08 WARNING OGG-01004 Aborted grouped transaction on 'MENTE.DI_YOYAKU_NOTICE_QUEUE', Database error 1403 (OCI Error ORA-01403: no data found, SQL ).





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