Integrated Extract misses Inserts intermittently (Doc ID 2064059.1)

Last updated on MARCH 21, 2017

Applies to:

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

Symptoms

Customer has got an extract:
Oracle GoldenGate Capture for Oracle
Version 12.1.2.1.5 20635622 OGGCORE_12.1.2.1.0OGGBP_PLATFORMS_150320.0454_FBO
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 12.1.0.2.0 - 64bit Production
which does not capture inserts and the replicat fails with error:
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 ).

 

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