OID 10g External Authentication Plugin oidspadi.sh Script Prompting for "Enter value for 53:" and "Enter value for 54:" (Doc ID 299367.1)

Last updated on AUGUST 15, 2019

Applies to:

Symptoms

Scenario:Implemented OID Synchronization with Microsoft Active Directory and set up Active Directory External Authentication Plug-In for OID.

When authenticated users try to login again, after minutes of restarting OID server, login fails with:

Already applied Patch 3753047 (OIDSPADA.PLS DOES NOT HANDLE AD CONNECTION TIMEOUT PROBLEM/ ERROR 81).

During execution of oidspadi.sh script, it prompts for / requests values for 53 and 54:

%ORACLE_HOME%\ldap\admin>sh oidspadi.sh
---------------------------------------------
  OID Active Directory Plug-in Configuration
---------------------------------------------
Please make sure Database and OID are up and running.
Please enter Active Directory host name: <AD HOSTNAME>
Do you want to use SSL to connect to Active Directory? (y/n) n
Please enter Active Directory port number [389]:
Please enter DB connect string: <TNS_CONNECT_STRING>
Please enter ODS password:
Please enter confirmed ODS password:
Please enter OID host name: <OID HOSTNAME>
Please enter OID port number [389]:
Please enter orcladmin password:
Please enter confirmed  orcladmin password:
Please enter the subscriber common user search base:  cn=Users,DC=<COMPANY>,DC=com;ou=<OU 1>,DC=<COMPANY>,DC=com;ou=<OU 2>,DC=<COMPANY>,DC=com
Please enter the Plug-in Request Group DN:
Please enter the exception entry  property: (!(objectclass=orcladuser))
Do you want to setup the backup Active Directory for failover? (y/n)
Installing Plug-in Packages ...
Table dropped.
Table created.
Sequence dropped.
Sequence created.
Procedure created.
No errors.
Procedure created.
No errors.
No errors.
Enter value for 53:
Enter value for 54:
Warning: Package Body created with compilation errors.
Errors for PACKAGE BODY OIDADPSWD:
LINE/COL ERROR
-------- -----------------------------------------------------------------
142/8    PL/SQL: Statement ignored
142/42   PLS-00201: identifier 'A' must be declared
155/8    PL/SQL: Statement ignored
155/43   PLS-00201: identifier 'A'  must be declared
170/8    PL/SQL: Statement ignored
170/42   PLS-00201: identifier 'A' must be declared
196/8    PL/SQL: Statement ignored
196/43   PLS-00201: identifier 'A' must be declared
285/5    PL/SQL: Statement ignored
285/41   PLS-00201: identifier '<...>.<...>' must be declared
303/5    PL/SQL: Statement ignored
LINE/COL ERROR
-----------------------

Changes

Cause

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