My Oracle Support Banner

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

Last updated on APRIL 09, 2020

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, <rep name>.prm: Aborted grouped transaction on '<schema name>.<table name>', Database error 60 (OCI Error ORA-00060: deadlock detected while waiting for resource (status = 60). UPDATE <update query>
2018-02-28 04:13:26 WARNING OGG-01154 Oracle GoldenGate Delivery for Oracle, <rep name>.prm: SQL error 60 mapping <schema name>.<table name>_DEVICE OCI Error ORA-00060: deadlock detected while waiting for resource (status = 60). UPDATE /*+ RESTRICT_ALL_REF_CONS */ <update query>

Changes

 

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
Changes
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.