Replication Not Working Properly And Change Log In Supply Node Not Purged "DSA is unwilling to perform" (Doc ID 1939241.1)

Last updated on AUGUST 30, 2023

Applies to:

Symptoms

LDAP replication configured

Replication logs (oidrepld00-0000.log)  reporting errors similar to the following:

[2014-06-24T01:11:01-04:00] [OID] [ERROR:8] [23020] [OIDREPLD] [host: <HOSTNAME>] [pid: 7396] [tid: 2] Reader(Apply):: In gslrrfeFetchChanges, ldap_search failure against server=<REPLICA ID> where basedn=cn=changelog, scope=1, filter=(&(objectclass=changeLogEntry)(servername=<REPLICA ID>)(changeNumber=0)), attrs=, error=DSA is unwilling to perform.


Change logs not being purged by garbage collection jobs.

Checking asr_chg_log table:

select count (*) from asr_chg_log where retry_cnt=10;

and

select count (*) from asr_chg_log where retry_cnt >= 0;

If you find you have many entries with a retry_cnt stuck at 10, you may be hitting this issue. 

(Also check the OP_TIME column as this will give you an idea of when these entries were created)

Cause

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