My Oracle Support Banner

OID 11g Replication Setup Shows "ORA-00060: deadlock " Error in OID Logs When Used NetManager (Doc ID 1375895.1)

Last updated on FEBRUARY 06, 2019

Applies to:

Oracle Internet Directory - Version to [Release 11g]
Information in this document applies to any platform.


In OID, or

1. Deadlock Error is seen as below in one of the oidldapd01sxxxx.log file of the replica/consumer OID .

[2011-03-28T13:36:18+01:00] [OID] [NOTIFICATION:16] [] [OIDLDAPD] [host: <HOSTNAME>] [pid: 7052]

[tid: 9] [ecid: <ECID#>] ServerWorker (REG):[[BEGIN ConnID:3 mesgID:2639 OpID:2638 OpName:delete ConnIP:::ffff:<IP ADDRESS>
 ConnDN:cn=replication dn,orclreplicaid=<REPLICA ID>,cn=replication configuration
[gslddd_CreTombStoneEntry]: ORA-60: ORA-00060: deadlock detected while waiting for resource
ORA-06512: at line 1


The problem appears to be a delete and modify of same entry coming in at the same time. We can reproduce the error ORA-60 by deleting entries with NetManager.


2. Its possible to add/modify/delete single level entries and they get replicated successfully, and we can also add/modify nested tnsnames entries (tnsnames entries with children) and they get replicated successfully. However deleting those nested tnsnames entries would not replicate at all.
            But we don't see any errors or messages at all in any log, no conflict/hiq, no ora-60 anywhere, even when we turn on high level debug for replication server. The deletes are simply getting ignored altogether.

3. Multivalued attributes such as password related attribute (ie, pwdfailuretime, etc) and other (custom) attributes are not consistently updated via replication.

Although RETRY_CNT shows as completed (-2), the changes are not applied to the replica.

Also No errors or messages  in any log, no conflict/hiq, no ora-60's anywhere.


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

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