My Oracle Support Banner

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

Last updated on FEBRUARY 15, 2019

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., OIDHOST1) and two RMS sites (e.g., OIDHOST2 and rOIDHOST1).

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 OIDHOST2
2. This change was successfully replicated to server OIDHOST1
3. This change was not replicated to server OIDHOST1

4. Modified userPassword attribute for a user on server OIDHOST1
5. This change was not replicated to server OIDHOST2
6. This change was replicated to OIDHOST1

Or:

1. Modified userPassword attribute for a user on server OIDHOST1
2. This change was successfully replicated to server OIDHOST2
3. This change was successfully replicated to server OIDHOST1

4. Modified userPassword attribute for a user on server OIDHOST2
5. This change was successfully replicated to server OIDHOST1
6. This change was not replicated to OIDHOST1

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 <DB_SERVICENAME1>.COMPANY.COM
------------------------------------------------------------------------------
Following deferred transaction errors were found at <DB_SERVICENAME1>.COMPANY.COM
--------------- --------------- --------------- ----------------------------
Deferred Deferred Trans Destination Error
Transaction ID Origin DB
--------------- --------------- --------------- ----------------------------
4.40.1386796 <DB_SERVICENAME2>.COMPANY <DB_SERVICENAME1>.COMPANY ORA-01403: no data found
--------------- --------------- --------------- ----------------------------
Following deferred transaction errors were found at <DB_SERVICENAME2>.COMPANY.COM
--------------- --------------- --------------- ----------------------------
Deferred Deferred Trans Destination Error
Transaction ID Origin DB
--------------- --------------- --------------- ----------------------------
9.24.34741 <DB_SERVICENAME3>.COMPANY <DB_SERVICENAME2>.COMPANY ORA-01403: no data found
--------------- --------------- --------------- ----------------------------
Following deferred transaction errors were found at <DB_SERVICENAME3>.COMPANY.COM
--------------- --------------- --------------- ----------------------------
Deferred Deferred Trans Destination Error
Transaction ID Origin DB
--------------- --------------- --------------- ----------------------------
11.2.61756 <DB_SERVICENAME2>.COMPANY <DB_SERVICENAME3>.COMPANY 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

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