OID 11g Multimaster Replication Intermittently Fails to Update Replicas (Doc ID 1612220.1)

Last updated on AUGUST 01, 2016

Applies to:

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

Symptoms

Oracle Internet Directory (OID) 11g.

One MDS site (e.g., oid01) and two RMS sites (e.g., oid02 and roid01).

Replication was working in 10g 10.1.4.3, before the upgrade to 11g 11.1.1.7.

Updates are not being applied to some of the replicas intermittently.

For example:

1. Modified userPassword attribute for a user on server oid02
2. This change was successfully replicated to server oid01
3. This change was not replicated to server roid01

4. Modified userPassword attribute for a user on server oid01
5. This change was not replicated to server oid02
6. This change was replicated to roid01

Or:

1. Modified userPassword attribute for a user on server oid01
2. This change was successfully replicated to server oid02
3. This change was successfully replicated to server roid01

4. Modified userPassword attribute for a user on server oid02
5. This change was successfully replicated to server oid01
6. This change was not replicated to roid01

No errors or failures on debugged Replication or OID ldap server logs.  No occurrences of the replicated entries in the debugged OID server logs either.

A row is inserted into the ASR_CHG_LOG table on the replica that did not get updated, but the RETRY_CNT column gets updated to -2 as if completed successfully.

(Reference:
How ASR Replication Works <Document 727937.1>
How To Manage OID Replication Conflicts in the HIQ (Human Intervention Queue) Using HIQPURGE and HIQRETRY <Document 171693.1> )

If manually changing the RETRY_CNT column back to zero on the ASR_CHG_LOG row, the replica is then updated.

Tried separating OID ldap processes for Replication as per unrelated <Document 1375895.1> Solution, but the problem continues.

Testing ASR replication at the DB level, i.e., by inserting into the asr_chg_log table from all 3 servers, always works consistently.

No errors or failure from remtool checks, only from remtool -dispasrerr -v, for example:

.....
No administrative request errors were found at ASDB1.MYCOMPANY.COM
------------------------------------------------------------------------------
Following deferred transaction errors were found at ASDB1.MYCOMPANY.COM
--------------- --------------- --------------- ----------------------------
Deferred Deferred Trans Destination Error
Transaction ID Origin DB
--------------- --------------- --------------- ----------------------------
4.40.1386796 ASDB2.MYCOMPANY ASDB1.MYCOMPANY ORA-01403: no data found
--------------- --------------- --------------- ----------------------------
Following deferred transaction errors were found at ASDB2.MYCOMPANY.COM
--------------- --------------- --------------- ----------------------------
Deferred Deferred Trans Destination Error
Transaction ID Origin DB
--------------- --------------- --------------- ----------------------------
9.24.34741 ASDB3.MYCOMPANY ASDB2.MYCOMPANY ORA-01403: no data found
--------------- --------------- --------------- ----------------------------
Following deferred transaction errors were found at ASDB3.MYCOMPANY.COM
--------------- --------------- --------------- ----------------------------
Deferred Deferred Trans Destination Error
Transaction ID Origin DB
--------------- --------------- --------------- ----------------------------
11.2.61756 ASDB2.MYCOMPANY ASDB3.MYCOMPANY ORA-01403: no data found
.....


At startup time, the OID logs show the following error:

gsldValidteEntry * MissingEdn eid=2033,scp=2,nRows=100,basedn=,fltr=

But the replication configuration entries look correct and the same on all nodes and have not been changed since 10g (so it is not related to <Bug 5234318>).



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