My Oracle Support Banner

Replicate Process Getting Abended Due To Deadlock (Doc ID 2404510.1)

Last updated on MAY 30, 2018

Applies to:

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

Symptoms

Customer was facing DEADLOCK issues causing the replicate process to abend.

Customer had a three way replication between three different sites.

error messages in ggserr.log shows:

2018-02-28 04:13:15 WARNING OGG-01004 Oracle GoldenGate Delivery for Oracle, rpuisclp.prm: Aborted grouped transaction on 'UIS.OTP_DEVICE', Database error 60 (OCI Error ORA-00060: deadlock detected while waiting for resource (status = 60). UPDATE /*+ RESTRICT_ALL_REF_CONS */ "UIS"."OTP_DEVICE" SET "PERSON_ID" = :a1,"CONTACT_ID" = :a2,"OTP_TYP_ID" = :a3,"NAME" = :a4,"SERIAL_NUM" = :a5,"SEED" = :a6,"LOCK_TIME" = :a7,"LOCKOUT_ATTEMPTS" = :a8,"IS_VERIFIED" = :a9,"OTP_UUID" = :a10,"SOFT_TOKEN_DEVICE_ID" = :a11,"CREATE_USER_ID" = :a12,"CREATE_DT" = :a13,"LAST_UPDT_USER_ID" = :a14,"LAST_UPDT_DT" = :a15,"DRIFT" = :a16,"GROUP_NM" = :a17,"IS_DEFAULT" = :a18 WHERE "OTP_DEVICE_ID" = :b0).
2018-02-28 04:13:15 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, rpuisclp.prm: Repositioning to rba 372741649 in seqno 800.
2018-02-28 04:13:26 WARNING OGG-01154 Oracle GoldenGate Delivery for Oracle, rpuisclp.prm: SQL error 60 mapping UIS.OTP_DEVICE to UIS.OTP_DEVICE OCI Error ORA-00060: deadlock detected while waiting for resource (status = 60). UPDATE /*+ RESTRICT_ALL_REF_CONS */ "UIS"."OTP_DEVICE" SET "PERSON_ID" = :a1,"CONTACT_ID" = :a2,"OTP_TYP_ID" = :a3,"NA

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
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.