OID, ODSM, DIP and/or ldapsearch Intermittent Errors: ldap_search: DSA is unwilling to perform | additional info: Failure accessing Oracle database (oracle errcode=1012). Or: additional info: Function Not Implemented
(Doc ID 1989511.1)
Last updated on JANUARY 27, 2021
Applies to:
Oracle Internet Directory - Version 11.1.1 and laterInformation in this document applies to any platform.
Symptoms
Oracle Internet Directory (OID) 11g, 12c or higher with Directory Integration Platform (DIP) integration.
Intermittent errors while retrieving users with Oracle Directory Services Manager (ODSM) and command line ldapsearch commands, affecting users not getting provisioned/propagated or synchronized to OID.
ldap_search: DSA is unwilling to perform
ldap_search: additional info: Failure accessing Oracle database (oracle errcode=1012).
ldap_search: additional info: Failure accessing Oracle database (oracle errcode=1012).
Or:
ldap_search: DSA is unwilling to perform
ldap_search: additional info: Function Not Implemented
ldap_search: additional info: Function Not Implemented
The first time it does not work, immediately after / a second time then works.
The behavior for both ODSM and ldapsearch is the same:
ldapsearch -D "cn=orcladmin" -w <password> -h <oid_hostname> -p <port> -b "" -s sub "cn=<username>"
ldap_search: DSA is unwilling to perform
ldap_search: additional info: Failure accessing Oracle database (oracle errcode=1012).
0 matches
ldap_search: DSA is unwilling to perform
ldap_search: additional info: Failure accessing Oracle database (oracle errcode=1012).
0 matches
A subsequent retry may or may not return results.
The OID ldap server log shows:
...<snip>...
[2015-02-26T08:27:10-05:00] [OID] [NOTIFICATION:16] [] [OIDLDAPD] [host: <oid hostname>] [pid: <pid>] [tid: <tid>] StatsCollector: ERROR * gslsmujGetInstInfo * ORA-22303:OCI-22303: type ""."OID_REPL_STATUS_ARRAY_TYPE" not found encountered
[2015-02-26T08:27:10-05:00] [OID] [NOTIFICATION:16] [] [OIDLDAPD] [host: <oid hostname>] [pid: <pid>] [tid: <tid>] StatsCollector: ERROR * StatsCollector * Failed to get instances' status info
[2015-02-26T08:27:10-05:00] [OID] [NOTIFICATION:16] [] [OIDLDAPD] [host: <oid hostname>] [pid: <pid>] [tid: <tid>] StatsCollector: [gsldaa_AddEntry]ORA-1012 while adding entry orclsequence=0,cn=orclhealthstats,cn=orclsm.Error = ORA-01012: not logged on
Process ID: <pid>
Session ID: <id> Serial number: <number>
[2015-02-26T08:27:10-05:00] [OID] [NOTIFICATION:16] [] [OIDLDAPD] [host: <oid hostname>] [pid: <pid>] [tid: <tid>] StatsCollector: INFO * gslsfsmsDbWrite * Requesting a new DB connection
[2015-02-26T08:27:10-05:00] [OID] [NOTIFICATION:16] [] [OIDLDAPD] [host: <oid hostname>] [pid: <pid>] [tid: <tid>] StatsCollector: [gsldaa_AddEntry]ORA-1012 while adding entry orclsequence=0,cn=orclperfstats,cn=orclsm.Error = ORA-01012: not logged on
Process ID: <pid>
Session ID: <id> Serial number: <number>
[2015-02-26T08:27:10-05:00] [OID] [NOTIFICATION:16] [] [OIDLDAPD] [host: <oid hostname>] [pid: <pid>] [tid: <tid>] StatsCollector: INFO * gslsfsmsDbWrite * Requesting a new DB connection
[2015-02-26T08:27:10-05:00] [OID] [NOTIFICATION:16] [] [OIDLDAPD] [host: <oid hostname>] [pid: <pid>] [tid: <tid>] StatsCollector: INFO * gslsfsmsDbWrite * Requesting a new DB connection
[2015-02-26T08:36:43-05:00] [OID] [NOTIFICATION:16] [] [OIDLDAPD] [host: <oid hostname>] [pid: <pid>] [tid: <tid>] [ecid: <ecid>] ServerWorker (REG):[[
BEGIN
ConnID:53 mesgID:759 OpID:758 OpName:search ConnIP: ConnDN:cn=orcladmin
[gsldfd_FetchSubTreeObjs] ORA error 1012: ORA-01012: not logged on
Process ID: <pid>
Session ID: <id> Serial number: <number>
END
]]
[2015-02-26T08:36:43-05:00] [OID] [NOTIFICATION:16] [] [OIDLDAPD] [host: <oid hostname>] [pid: <pid>] [tid: <tid>] [ecid: <ecid>] ServerWorker (REG):[[
BEGIN
ConnID:53 mesgID:759 OpID:758 OpName:search ConnIP: ConnDN:cn=orcladmin
Error in gsldfssFetchSubTreeObjs:5
END
]]
[2015-02-26T08:36:43-05:00] [OID] [NOTIFICATION:16] [] [OIDLDAPD] [host: <oid hostname>] [pid: <pid>] [tid: <tid>] [ecid: <ecid>] ServerWorker (REG):[[
BEGIN
ConnID:53 mesgID:760 OpID:759 OpName:search ConnIP: ConnDN:cn=orcladmin
[gsldfd_FetchSubTreeObjs] ORA error 2396: ORA-02396: exceeded maximum idle time, please connect again
END
]]
[2015-02-26T08:36:43-05:00] [OID] [NOTIFICATION:16] [] [OIDLDAPD] [host: <oid hostname>] [pid: <pid>] [tid: <tid>] [ecid: <ecid>] ServerWorker (REG):[[
BEGIN
ConnID:53 mesgID:760 OpID:759 OpName:search ConnIP: ConnDN:cn=orcladmin
Error in gsldfssFetchSubTreeObjs:5
END
]]
[2015-02-26T08:36:43-05:00] [OID] [NOTIFICATION:16] [] [host: <oid hostname>] [pid: <pid>] [tid: <tid>] [ecid: <ecid>] ServerWorker (REG):[[
BEGIN
ConnID:53 mesgID:761 OpID:760 OpName:search ConnIP: ConnDN:cn=orcladmin
[gsldfd_FetchSubTreeObjs] ORA error 2396: ORA-02396: exceeded maximum idle time, please connect again
END
]]
...<snip>...
[2015-02-26T08:27:10-05:00] [OID] [NOTIFICATION:16] [] [OIDLDAPD] [host: <oid hostname>] [pid: <pid>] [tid: <tid>] StatsCollector: ERROR * gslsmujGetInstInfo * ORA-22303:OCI-22303: type ""."OID_REPL_STATUS_ARRAY_TYPE" not found encountered
[2015-02-26T08:27:10-05:00] [OID] [NOTIFICATION:16] [] [OIDLDAPD] [host: <oid hostname>] [pid: <pid>] [tid: <tid>] StatsCollector: ERROR * StatsCollector * Failed to get instances' status info
[2015-02-26T08:27:10-05:00] [OID] [NOTIFICATION:16] [] [OIDLDAPD] [host: <oid hostname>] [pid: <pid>] [tid: <tid>] StatsCollector: [gsldaa_AddEntry]ORA-1012 while adding entry orclsequence=0,cn=orclhealthstats,cn=orclsm.Error = ORA-01012: not logged on
Process ID: <pid>
Session ID: <id> Serial number: <number>
[2015-02-26T08:27:10-05:00] [OID] [NOTIFICATION:16] [] [OIDLDAPD] [host: <oid hostname>] [pid: <pid>] [tid: <tid>] StatsCollector: INFO * gslsfsmsDbWrite * Requesting a new DB connection
[2015-02-26T08:27:10-05:00] [OID] [NOTIFICATION:16] [] [OIDLDAPD] [host: <oid hostname>] [pid: <pid>] [tid: <tid>] StatsCollector: [gsldaa_AddEntry]ORA-1012 while adding entry orclsequence=0,cn=orclperfstats,cn=orclsm.Error = ORA-01012: not logged on
Process ID: <pid>
Session ID: <id> Serial number: <number>
[2015-02-26T08:27:10-05:00] [OID] [NOTIFICATION:16] [] [OIDLDAPD] [host: <oid hostname>] [pid: <pid>] [tid: <tid>] StatsCollector: INFO * gslsfsmsDbWrite * Requesting a new DB connection
[2015-02-26T08:27:10-05:00] [OID] [NOTIFICATION:16] [] [OIDLDAPD] [host: <oid hostname>] [pid: <pid>] [tid: <tid>] StatsCollector: INFO * gslsfsmsDbWrite * Requesting a new DB connection
[2015-02-26T08:36:43-05:00] [OID] [NOTIFICATION:16] [] [OIDLDAPD] [host: <oid hostname>] [pid: <pid>] [tid: <tid>] [ecid: <ecid>] ServerWorker (REG):[[
BEGIN
ConnID:53 mesgID:759 OpID:758 OpName:search ConnIP: ConnDN:cn=orcladmin
[gsldfd_FetchSubTreeObjs] ORA error 1012: ORA-01012: not logged on
Process ID: <pid>
Session ID: <id> Serial number: <number>
END
]]
[2015-02-26T08:36:43-05:00] [OID] [NOTIFICATION:16] [] [OIDLDAPD] [host: <oid hostname>] [pid: <pid>] [tid: <tid>] [ecid: <ecid>] ServerWorker (REG):[[
BEGIN
ConnID:53 mesgID:759 OpID:758 OpName:search ConnIP: ConnDN:cn=orcladmin
Error in gsldfssFetchSubTreeObjs:5
END
]]
[2015-02-26T08:36:43-05:00] [OID] [NOTIFICATION:16] [] [OIDLDAPD] [host: <oid hostname>] [pid: <pid>] [tid: <tid>] [ecid: <ecid>] ServerWorker (REG):[[
BEGIN
ConnID:53 mesgID:760 OpID:759 OpName:search ConnIP: ConnDN:cn=orcladmin
[gsldfd_FetchSubTreeObjs] ORA error 2396: ORA-02396: exceeded maximum idle time, please connect again
END
]]
[2015-02-26T08:36:43-05:00] [OID] [NOTIFICATION:16] [] [OIDLDAPD] [host: <oid hostname>] [pid: <pid>] [tid: <tid>] [ecid: <ecid>] ServerWorker (REG):[[
BEGIN
ConnID:53 mesgID:760 OpID:759 OpName:search ConnIP: ConnDN:cn=orcladmin
Error in gsldfssFetchSubTreeObjs:5
END
]]
[2015-02-26T08:36:43-05:00] [OID] [NOTIFICATION:16] [] [host: <oid hostname>] [pid: <pid>] [tid: <tid>] [ecid: <ecid>] ServerWorker (REG):[[
BEGIN
ConnID:53 mesgID:761 OpID:760 OpName:search ConnIP: ConnDN:cn=orcladmin
[gsldfd_FetchSubTreeObjs] ORA error 2396: ORA-02396: exceeded maximum idle time, please connect again
END
]]
...<snip>...
DIP diagnostic log shows:
...<snip>...
[2021-01-20T20:12:10.187+05:30] [wls_ods1] [ERROR] [] [oracle.dip.<profile>] [tid: <profile>] [userId: <anonymous>] [ecid: <ecid>] [APP: DIP] [partition-name: DOMAIN] [tenant-name: GLOBAL] Error while update Exec status
[2021-01-20T20:12:49.043+05:30] [wls_ods1] [ERROR] [DIP-10527] [oracle.dip.update] [tid: UpdateThread] [userId: <anonymous>] [ecid: <ecid>] [APP: DIP] [partition-name: DOMAIN] [tenant-name: GLOBAL] Unable to update the changes made in synchronization profile.[[
javax.naming.OperationNotSupportedException: [LDAP: error code 53 - Function Not Implemented]; remaining name 'cn=changelog'
at com.sun.jndi.ldap.LdapCtx.mapErrorCode(LdapCtx.java:3227)
at com.sun.jndi.ldap.LdapCtx.processReturnCode(LdapCtx.java:3100)
at com.sun.jndi.ldap.LdapCtx.processReturnCode(LdapCtx.java:2891)
at com.sun.jndi.ldap.LdapCtx.searchAux(LdapCtx.java:1846)
at com.sun.jndi.ldap.LdapCtx.c_search(LdapCtx.java:1769)
...<snip>...
[2021-01-20T20:12:10.187+05:30] [wls_ods1] [ERROR] [] [oracle.dip.<profile>] [tid: <profile>] [userId: <anonymous>] [ecid: <ecid>] [APP: DIP] [partition-name: DOMAIN] [tenant-name: GLOBAL] Error while update Exec status
[2021-01-20T20:12:49.043+05:30] [wls_ods1] [ERROR] [DIP-10527] [oracle.dip.update] [tid: UpdateThread] [userId: <anonymous>] [ecid: <ecid>] [APP: DIP] [partition-name: DOMAIN] [tenant-name: GLOBAL] Unable to update the changes made in synchronization profile.[[
javax.naming.OperationNotSupportedException: [LDAP: error code 53 - Function Not Implemented]; remaining name 'cn=changelog'
at com.sun.jndi.ldap.LdapCtx.mapErrorCode(LdapCtx.java:3227)
at com.sun.jndi.ldap.LdapCtx.processReturnCode(LdapCtx.java:3100)
at com.sun.jndi.ldap.LdapCtx.processReturnCode(LdapCtx.java:2891)
at com.sun.jndi.ldap.LdapCtx.searchAux(LdapCtx.java:1846)
at com.sun.jndi.ldap.LdapCtx.c_search(LdapCtx.java:1769)
...<snip>...
Checked against:
Connectivity Issues Reported on Applications Authenticating thru OID - ORA-02396 (Doc ID 1559265.1)
ORA-02399: Exceeded Maximum Connect Time, You Are Being Logged Off. (Doc ID 1561211.1)
The CONNECT_TIME is already set to UNLIMITED and IDLE_TIME is set to 15 minutes.
Would setting IDLE_TIME really help?
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 |