Goldengate Replication skips records due to deadlocks (Doc ID 2126646.1)

Last updated on APRIL 13, 2016

Applies to:

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

Symptoms

Deadlock are causing transactions to be skipped:

 Oracle GoldenGate Delivery for Oracle
 Version 12.1.2.1.6 20803560 21496507_FBO
 Solaris, sparc, 64bit (optimized), Oracle 11g on Jul 24 2015 06:15:44
 

WARNING OGG-00869 OCI Error ORA-00060: deadlock detected while waiting for resource
(status = 60), SQL <UPDATE /*+ RESTRICT_ALL_REF_CONS */ "OMS"."PROMOTIONS2" x SET x."NAME" = :a1,x."MAX_NUM_USES" = :a2,x."NUM_ALREADY_USED" = :a3,x."RESTRICTION_INFO_XML" = sys.xmltype.createxml(:a4,null,1,1),x."PRICING_INFO_XML" = sys.xmltype.createxml(:a5,null,1,1),x."MSG_KEY" = :a6,x."IS_ACTIVE" = :a7,x."NOTES" = :a8,x."SHOW_PRICING_ONLY" = :a9,x."START_DATE" = :a10,x."END_DATE" = :a11,x."CREATED_DATE" = :a12,x."MODIFIED_DATE" = :a13,x."CREATED_BY_ID" = :a14,x."MODIFIED_BY_ID" = :a15,x."BUSINESS_OBJECTIVE" = :a16,x."CHANNEL" = :a17,x."UPDATE_COUNT" = :a18,x."VERSION" = :a19,x."PRODUCT_FAMILY" = :a20,x."GG_MODI_TS" = :a21,x."GG_STATUS" = :a22,x."PROMOTION_CAMPAIGN_TYPE" = :a23 WHERE x."PROMO_ID" = :b0 AND x."NUM_ALREADY_USED" = :b1 AND x."MODIFIED_DATE" = :b2 AND x."UPDATE_COUNT" is NULL AND x."GG_MODI_TS" = :b4 AND x."GG_STATUS" = :b5>.

  

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