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

Applies to:

Oracle Fusion Middleware - Version 11.1.1.7.0 and later
Oracle Internet Directory - Version 11.1.1.7.0 and later
Information in this document applies to any platform.

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:
BEGIN
 ConnID:831 mesgID:3 OpID:2 OpName:add ConnIP:10.217.220.20 ConnDN:cn=atgadmin,cn=users,dc=us,dc=oracle,dc=com
[gsldaa_AddEntry]ORA-6550 while adding entry uid=testingtests,cn=Users,dc=us,dc=oracle,dc=com". = ORA-06550: line 1, column 13:
PLS-00302: component 'OLADDENTRYV7' must be declared
ORA-06550: line 1, column 7:

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

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