OID Not Responding Intermittently / Searches Fail With DSA is unwilling to perform - Function Not Implemented Or Failure accessing Oracle database (oracle errcode=3114) / ORA-03135: connection lost contact / Ldapbinds Fail With Invalid Credentials Error
(Doc ID 1270606.1)
Last updated on APRIL 03, 2023
Applies to:
Oracle Internet Directory - Version 11.1.1 and laterInformation in this document applies to any platform.
Symptoms
Oracle Internet Directory (OID) 11g
OID fails to respond intermittently.
For example, searching for an indexed attribute returns error as if the attribute was not indexed:
ldap_search: DSA is unwilling to perform
ldap_search: additional info: Function Not Implemented
A subsequent same or different search can also return a different error:
ldap_search: DSA is unwilling to perform
ldap_search: additional info: Failure accessing Oracle database (oracle errcode=3114).
Note: The same error above can be returned to connecting/front ending applications and in their logs.
Or, ldapbinds may fail intermittently with "invalid credentials", for example:
> ldapbind --h <OID_HOSTNAME> -p <OID_PORT> -D "orclapplicationcommonname=<APP_NAME>,cn=ebusiness,cn=products,cn=oraclecontext,dc=<COMPANY>,dc=com" -w <app password>
ldap_bind: Invalid credentials
> ldapbind -h <OID_HOSTNAME> -p <OID_PORT> -D "orclapplicationcommonname=<APP_NAME>,cn=ebusiness,cn=products,cn=oraclecontext,dc=<COMPANY>,dc=com" -w <app password>
bind successful
> ldapbind -h <OID_HOSTNAME> -p <OID_PORT> -D "orclapplicationcommonname=<APP_NAME>,cn=ebusiness,cn=products,cn=oraclecontext,dc=<COMPANY>,dc=com" -w <app password>
bind successful
> ldapbind -h <OID_HOSTNAME> -p <OID_PORT> -D "orclapplicationcommonname=<APP_NAME>,cn=ebusiness,cn=products,cn=oraclecontext,dc=<COMPANY>,dc=com" -w <app password>
ldap_bind: Invalid credentials
> ldapbind --h <OID_HOSTNAME> -p <OID_PORT> -D "orclapplicationcommonname=<APP_NAME>,cn=ebusiness,cn=products,cn=oraclecontext,dc=<COMPANY>,dc=com" -w <app password>
ldap_bind: Invalid credentials
> ldapbind -h <OID_HOSTNAME> -p <OID_PORT> -D "orclapplicationcommonname=<APP_NAME>,cn=ebusiness,cn=products,cn=oraclecontext,dc=<COMPANY>,dc=com" -w <app password>
bind successful
OID 11g server log shows the following error around or before that time:
[2010-11-16T09:27:44-08:00] [OID] [NOTIFICATION:16] [] [OIDLDAPD] [host: <HOSTNAME>] [pid: xxxx] [tid: 11] [ecid: <ECID>] ServerWorker (REG):[[
BEGIN
ConnID:292 mesgID:2 OpID:1 OpName:search ConnIP:<IP Address> ConnDN:cn=orcladmin
[gsldfd_FetchSubTreeObjs] ORA error 12571: ORA-12571: TNS:packet writer failure
END
]]
[2010-11-16T09:27:44-08:00] [OID] [NOTIFICATION:16] [] [OIDLDAPD] [host: <HOSTNAME>] [pid: xxxx] [tid: 11] [ecid: <ECID>] ServerWorker (REG):[[
BEGIN
ConnID:292 mesgID:2 OpID:1 OpName:search ConnIP:<IP Address> ConnDN:cn=orcladmin
Error in gsldfssFetchSubTreeObjs:5
END
]]
[2010-11-16T09:27:44-08:00] [OID] [NOTIFICATION:16] [] [OIDLDAPD] [host: <HOSTNAME>] [pid: xxxx] [tid: 11] [ecid: <ECID>] ServerWorker (REG):[[
BEGIN
ConnID:292 mesgID:2 OpID:1 OpName:search ConnIP:<IP Address> ConnDN:cn=orcladmin
gslgrdbGetGrSubptn: group membership db fetch failed
END
]]
[2010-11-16T09:27:44-08:00] [OID] [NOTIFICATION:16] [] [OIDLDAPD] [host: <HOSTNAME>] [pid: xxxx] [tid: 11] [ecid: <ECID>] ServerWorker (REG):[[
BEGIN
ConnID:292 mesgID:2 OpID:1 OpName:search ConnIP:<IP Address> ConnDN:cn=orcladmin
gslfbifsgFindSubscribedGroups:Error finding subscribedgroups for the user cn=orcladmin
END
]]
[2010-11-16T09:27:44-08:00] [OID] [NOTIFICATION:16] [] [OIDLDAPD] [host: <HOSTNAME>] [pid: xxxx] [tid: 11] [ecid: <ECID>] ServerWorker (REG):[[
BEGIN
ConnID:292 mesgID:2 OpID:1 OpName:search ConnIP:<IP Address> ConnDN:cn=orcladmin
[gsldfd_FetchSubTreeObjs] ORA error 3114: ORA-03114: not connected to ORACLE
END
]]
[2010-11-16T09:27:44-08:00] [OID] [NOTIFICATION:16] [] [OIDLDAPD] [host: <HOSTNAME>] [pid: xxxx] [tid: 11] [ecid: <ECID> ServerWorker (REG):[[
BEGIN
ConnID:292 mesgID:2 OpID:1 OpName:search ConnIP:<IP Address> ConnDN:cn=orcladmin
Error in gsldfssFetchSubTreeObjs:5
END
]]
[2010-11-16T09:27:44-08:00] [OID] [NOTIFICATION:16] [] [OIDLDAPD] [host: <HOSTNAME>] [pid: xxxx] [tid: 0] Main:: Session ID = 1180
[2010-11-16T09:27:44-08:00] [OID] [NOTIFICATION:16] [] [OIDLDAPD] [host: <HOSTNAME>] [pid: xxxx] [tid: 0] Main:: OracleProcess ID = 59856
Or:
BEGIN
ConnID:47 mesgID:2 OpID:1 OpName:search ConnIP:<IP Address> ConnDN:cn=orcladmin
[gsldecfsFetchEntries] ORA error 3135: ORA-03135: connection lost contact
Process ID: 29620
Session ID: 406 Serial number: 201
END
]]
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 |