My Oracle Support Banner

OUD 11g/12c - OUD Proxy With RDBMS Extension Does Not Respond To LDAP Query And Gives Error As Result: 53 Server Is Unwilling To Perform (Doc ID 2467498.1)

Last updated on FEBRUARY 26, 2019

Applies to:

Oracle Unified Directory - Version 11.1.2.3.180717 and later
Information in this document applies to any platform.

Symptoms

OUD does not respond to LDAP query and gives error as result: 53 Server is unwilling to perform after DB goes offline requiring a restart of OUD.

ERROR
-----------------------

SEARCH RES conn=51 op=1 msgID=2 result=53 message="SQL Exception occurred in the backend database table" nentries=0 etime=15021



STEPS
-----------------------
Issue can easily be reproduced by stopping and restarting the backend DB.

Example:
 - Search is successful

$ ./ldapsearch -p 1390 -D cn="Directory Manager" -w <PASSWORD> -b ou=dbPeople,dc=example,dc=com uid=user100
dn: uid=user100,ou=dbPeople,dc=example,dc=com
memberof: cn=DBA,ou=dbGroups,dc=example,dc=com
objectClass: person
objectClass: organizationalPerson
objectClass: inetOrgPerson
objectClass: top
givenname: myDbGivenName-100
title: myDbTitle-100
uid: user100
cn: myDbCommonName-100
telephonenumber: 555-555-1212
sn: myDbSirName-100
userpassword: Oracle123
ou: DBA



 - Stop DB

$ stop db

Stop 12.1.0 Database listener on dkol6 [ OK ]
Stop 12.1.0 Database on dkol6 [ OK ]


 - Confirm search fails with DB down

$ ./ldapsearch -p 1390 -D cn="Directory Manager" -w <PASSWORD> -b ou=dbPeople,dc=example,dc=com uid=user100
SEARCH operation failed
Result Code: 53 (Unwilling to Perform)
Additional Information: SQL Exception occurred in the backend database table


 - Start DB

$ start db

Start 12.1.0.2 Database listener on dkol6 [ OK ]
Start 12.1.0.2 Oracle Database dkol6 on dkol6 [ OK ]
  SQL: sql://<HOSTNAME>:1521/


 - Still getting error 53 after db is restarted

$ ./ldapsearch -p 1390 -D cn="Directory Manager" -w <PASSWORD> -b ou=dbPeople,dc=example,dc=com uid=user100
SEARCH operation failed
Result Code: 53 (Unwilling to Perform)
Additional Information: SQL Exception occurred in the backend database table

 

[11/Sep/2018:13:18:57 -0500] category=CORE severity=NOTICE msgID=458891 msg=The Directory Server has sent an alert notification generated by classorg.opends.server.core.DirectoryServer (alert type
org.opends.server.DirectoryServerStarted, alert ID 458887): The DirectoryServer has started successfully
[11/Sep/2018:14:03:09 -0500] category=RDBMS severity=SEVERE_ERROR msgID=29622292 msg=SQL Exception occurred in the backend database table
[11/Sep/2018:14:05:06 -0500] category=RDBMS severity=SEVERE_ERROR msgID=29622292 msg=SQL Exception occurred in the backend database table

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


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