My Oracle Support Banner

OID Multimaster Replication Is Out Of Sync. One record is missing in one OID Group Node. ldap_add: Already exists (68) . ldap_delete: No such object (32) (Doc ID 2753319.1)

Last updated on MARCH 06, 2023

Applies to:

Oracle Internet Directory - Version 12.2.1.3.0 and later
Information in this document applies to any platform.

Symptoms

OID Multimaster Replication is Out Of Sync. One record is missing in one OID Group Node.

1. Multi master replication out of sync. One node of replication group missing one entry.


2. oidcmprec operation=reconcile isn't working. Example command:

oidcmprec operation=compare scope=subtree base="'dc=<REALM>'" source=<OID_SERVER_NAME_1>:<OID_PORT> destination=<OID_SERVER_NAME_5>:<OID_PORT> file=cmpr.txt

It reports that OID entry is missing and create file to create entry in the destination OID server but entry is not created.


3. <DB_NAME> entry exist on <OID_SERVER_NAME_1>, <OID_SERVER_NAME_2>, <OID_SERVER_NAME_3>, <OID_SERVER_NAME_4> but not on <OID_SERVER_NAME_5>

4. Running ldapsearch in one of the OID nodes where entry exist:

$ORACLE_HOME/bin/ldapsearch -h <OID_SERVER_NAME_1> -p <OID_PORT> -D cn=orcladmin -w xxxxxx -b "cn=<DB_NAME>,cn=OracleContext,dc=<REALM>" objectclass=* "*" "+"

cn=<DB_NAME>,cn=OracleContext,dc=<REALM>
modifytimestamp=<DATE>
modifiersname=cn=<OID_USER>,cn=users,dc=<dc>,dc=<REALM>
creatorsname=cn=<OID_USER>,cn=users,dc=<dc>,dc=<REALM>
createtimestamp=<DATE>
orclguid=<ORCLGUID>
cn=<DB_NAME>
objectclass=top
objectclass=orclNetService
orclnormdn=cn=<DB_NAME>,cn=OracleContext,dc=<REALM>
orclnetdescstring=(DESCRIPTION=(ADDRESS_LIST=(FAILOVER=on)(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=<DB_SERVER_1>)(PORT=))(ADDRESS=(PROTOCOL=TCP)(HOST=<DB_SERVER_2>)(PORT=)))(CONNECT_DATA=(SERVICE_NAME=<SERVICE_NAME>)))

5. Running ldapsearch in the OID node where entry not exist and cannot be created:

$ORACLE_HOME/bin/ldapsearch -h <OID_SERVER_NAME_5> -p <OID_PORT> -D cn=orcladmin -w xxxx -b "cn=<DB_NAME>,cn=OracleContext,dc=<REALM>" objectclass=* "*" "+"
ldap_search: No such object
ldap_search: matched: cn=OracleContext,dc=<REALM>

6. Trying to run ldapadd with ldif file generated with reconcile operation reported:

ldap_add: Already exists (68)
additional info: Object already exists

7. Trying to delete the entry with ldapdelete reported that object did not exits:

ldap_delete: No such object (32)
matched DN: cn=OracleContext,dc=<REALM>
additional info: Entry to be deleted not found.

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
References


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