OID 11g - Unable to Create / Delete User Entries After OID 11g is Patched, e.g. from 11.1.1.6 to 11.1.1.7. ODSM Error: [LDAP: error code 53 - Unwilling To Perform]. OID Debug Log Errors: ORA-6550 while adding entry <dn> / PLS-00302 (Doc ID 1546929.1)

Last updated on SEPTEMBER 19, 2019

Applies to:

Symptoms

1.  Oracle Internet Directory (OID) was upgraded from version 11.1.1.6 to version 11.1.1.7.   

2.  Creating users in OID using the orcladmin user fail.

3. Error in ODSM:  "[LDAP: error code 53 - Unwilling To Perform] "

4. Error from OID logs:

5. Patch Set Assistant (PSA)  shows the following error's and additional similar errors throughout the log:

SQL*Plus: Release 11.1.0.7.0 - Production on Tue Apr 9 15:17:04 2013

Copyright (c) 1982, 2008, Oracle. All rights reserved.

SQL> SQL> SQL> SP2-0306: Invalid option.
Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER|SYSASM}]
where <logon> ::= <USERNAME>[/<PASSWORD>][@<connect_identifier>] [edition=value] | /
SQL> SQL> SET FEEDBACK 1
SQL> SET NUMWIDTH 10
SQL> SET LINESIZE 80
SQL> SET TRIMSPOOL ON
SQL> SET TAB OFF
SQL> SET PAGESIZE 100
SQL>
SQL> Rem All the delete statements must be first.
SQL> Rem we don't care about delete errors
SQL>
SQL> WHENEVER SQLERROR EXIT SQL.SQLCODE
SQL>
SQL> alter session set current_schema = ODS;
SP2-0640: Not connected

...

Changes

OID was upgraded from version 11.1.1.6 to version 11.1.1.7. 

Cause

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