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