My Oracle Support Banner

OUD 11g/12c - OUD Proxy with RDBMS Extension Responds to "ldapsearch" Query with Error: "Result Code: 53 (Unwilling to Perform)" (Doc ID 2467498.1)

Last updated on APRIL 26, 2023

Applies to:

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

Symptoms

OUD responds to ldapsearch with error "Result Code: 53 (Unwilling to Perform)" after DB goes offline.

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 <LDAP_PORT> -D cn="<DM>" -w <PASSWORD> -b <SUFFIX> uid=<UID>
dn: uid=<UID>
memberof: <GROUP_DN_
objectClass: person
objectClass: organizationalPerson
objectClass: inetOrgPerson
objectClass: top
givenname: ..
..

..



 - Stop DB

$ stop db

Stop 12.1.0 Database listener  [ OK ]
Stop 12.1.0 Database [ OK ]


 - Confirm search fails with DB down

$ ./ldapsearch -p <LDAP_PORT> -D "<DM>" -w <PASSWORD> -b
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  [ OK ]
Start 12.1.0.2 Oracle Database  [ OK ]
  SQL: sql://<HOSTNAME>:<PORT>/


 - Still getting error 53 after db is restarted

$ ./ldapsearch -p -D <DM>  -w <PASSWORD> -b <SUFFIX>
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

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


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