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 MARCH 08, 2017

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

OID fails to respond intermittently.

For example, searching for an indexed attribute returns error as if the attribute was not indexed:

> ldapsearch -h myoidhost -p 389 -D "cn=orcladmin" -w myoidpwd -b "dc=mycompany,dc=com" myattr=123456
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:

> ldapsearch -h myoidhost -p 389 -D cn=orcladmin -w myoidpwd -b "cn=oid1,cn=osdldapd,cn=subconfigsubentry" -s base "objectclass=*"
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 myoidhost -p 3060 -D "orclapplicationcommonname=myapp,cn=ebusiness,cn=products,cn=oraclecontext,dc=mycompany,dc=com" -w <app password>
ldap_bind: Invalid credentials
> ldapbind -h myoidhost -p 3060 -D "orclapplicationcommonname=myapp,cn=ebusiness,cn=products,cn=oraclecontext,dc=mycompany,dc=com" -w <app password>
bind successful
> ldapbind -h myoidhost -p 3060 -D "orclapplicationcommonname=myapp,cn=ebusiness,cn=products,cn=oraclecontext,dc=mycompany,dc=com" -w <app password>
bind successful
> ldapbind -h myoidhost -p 3060 -D "orclapplicationcommonname=myapp,cn=ebusiness,cn=products,cn=oraclecontext,dc=mycompany,dc=com" -w <app password>
ldap_bind: Invalid credentials
> ldapbind -h myoidhost -p 3060 -D "orclapplicationcommonname=myapp,cn=ebusiness,cn=products,cn=oraclecontext,dc=mycompany,dc=com" -w <app password>
ldap_bind: Invalid credentials
> ldapbind -h myoidhost -p 3060 -D "orclapplicationcommonname=myapp,cn=ebusiness,cn=products,cn=oraclecontext,dc=mycompany,dc=com" -w <app password>
bind successful



OID 11g server log shows the following error around or before that time:

[2010-11-16T07:51:56-08:00] [OID] [NOTIFICATION:16] [] [OIDLDAPD] [host: MYOIDHOST] [pid: 6784] [tid: 29] ServerWorker (SPW): Thread Started

[2010-11-16T09:27:44-08:00] [OID] [NOTIFICATION:16] [] [OIDLDAPD] [host: MYOIDHOST] [pid: 6784] [tid: 11] [ecid: 00hwwKcRL9c6uHpSKQm3Su0001e0000002,0] 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: MYOIDHOST] [pid: 6784] [tid: 11] [ecid: 00hwwKcRL9c6uHpSKQm3Su0001e0000002,0] 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: MYOIDHOST] [pid: 6784] [tid: 11] [ecid: 00hwwKcRL9c6uHpSKQm3Su0001e0000002,0] 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: MYOIDHOST] [pid: 6784] [tid: 11] [ecid: 00hwwKcRL9c6uHpSKQm3Su0001e0000002,0] 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: MYOIDHOST] [pid: 6784] [tid: 11] [ecid: 00hwwKcRL9c6uHpSKQm3Su0001e0000002,0] 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: MYOIDHOST] [pid: 6784] [tid: 11] [ecid: 00hwwKcRL9c6uHpSKQm3Su0001e0000002,0] 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: MYOIDHOST] [pid: 6784] [tid: 0] Main:: Session ID = 1180

[2010-11-16T09:27:44-08:00] [OID] [NOTIFICATION:16] [] [OIDLDAPD] [host: MYOIDHOST] [pid: 6784] [tid: 0] Main:: OracleProcess ID = 59856


Or: 

[2015-09-21T10:53:43-04:00] [OID] [NOTIFICATION:16] [] [OIDLDAPD] [host: myoidhost] [pid: 7714] [tid: 8] [ecid: 00584CCDC22BX7^WtTi8Vl0001sY00000d,0] ServerWorker (REG):[[
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
]]

  

 

Changes

 

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