Goldengate Have A Lot Of "ORA-00060: Deadlock Detected" Errors In BODS(Exadata) Production Database

(Doc ID 1634549.1)

Last updated on NOVEMBER 02, 2015

Applies to:

Oracle GoldenGate - Version 11.2.1.0.5 to 11.2.1.0.19 [Release 11.2]
Information in this document applies to any platform.

Symptoms

Using Goldengate version 11.2.1.0.5, running on a OEL5 64 bit platform, The following error is reported during replicat

2014-02-19 08:56:43 WARNING OGG-00869 OCI Error ORA-00060: deadlock detected while waiting for resource (status = 60). UPDATE "ABP_USG1"."APE1_RATED_EVENT" SET "EVENT_TYPE_ID" = :a7,"TARGET_CYCLE_CODE" = :a8,"CYCLE_YEAR" = :a9,"BILLING_ARRANGEMENT" = :a10,"SOURCE_ID" = :a11,"EVENT_STATE" = :a12,"EVENT_STATE_REASON_CODE" = :a13,"RERATE_TYPE" = :a14,"ORIGINAL_EVENT_ID" = :a15,"RESOURCE_VALUE" = :a16,...


2014-02-19 08:56:43 WARNING OGG-01004 Aborted grouped transaction on 'ABP_USG1.APE1_RATED_EVENT', Database error 60 (OCI Error ORA-00060: deadlock detected while waiting for resource (status = 60). UPDATE "ABP_USG1"."APE1_RATED_EVENT" SET "EVENT_TYPE_ID" = :a7,"TARGET_CYCLE_CODE" = :a8,"CYCLE_YEAR" = :a9,"BILLING_ARRANGEMENT" = :a10,"SOURCE_ID" = :a11,"EVENT_STATE" = :a12,"EVENT_STATE_REASON_CODE" = :a13,"RERATE_TYPE" = :a14,"ORIGINAL_EVENT_ID" = :a15,"RESOURCE_VALUE" = :a16,"RESOURCE_TYPE" = :a17,"SYS_UPDATE_DATE" = :a18

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