Error ORA-31203 in Identity Management HA Environment (Doc ID 297384.1)

Last updated on JUNE 01, 2017

Applies to:

Oracle Application Server Single Sign-On - Version 9.0.4 to 10.1.4 [Release 10gR1 to 10gR3]
Oracle Internet Directory - Version 9.0.4 to 10.1.4 [Release 10gR1 to 10gR3]
Information in this document applies to any platform.
***Checked for relevance on 01-JUN-2017***


Symptoms

After configuring the High Availability IDM, login to pls/orasso failed with the following error:

-----------
Error: ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at
"ORASSO.WWSSO_OID_INTEGRATION", line 853 ORA-31203: DBMS_LDAP: PL/SQL - Init Failed.
-----------

The error ORA-31203 can occur while installing the Infrastructure as well. Following is the error stack thrown for the installation error.

----------
............
SQL> Creating OID entries for SSO
Error code : 1
Error message: User-Defined Exception
LDAP error : ORA-31203: DBMS_LDAP: PL/SQL - Init Failed.
ERROR: deleting application entry
Error code: 1
Error message: User-Defined Exception
ERROR: creating SSO users and groups in OID

PL/SQL procedure successfully completed.

*** Refreshing WWC OID cache....***
declare

ERROR at line 1:
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "ORASSO.WWSEC_OID", line 1199
ORA-06512: at "ORASSO.WWSEC_OID", line 1328
ORA-06512: at "ORASSO.WWSEC_OID", line 2498
ORA-06512: at "ORASSO.WWSEC_OID", line 2528
ORA-06512: at "ORASSO.WWSEC_OID", line 1606
ORA-06512: at "ORASSO.WWSEC_OID", line 1755
ORA-06512: at "ORASSO.WWSEC_OID", line 2133
ORA-06512: at line 8
............
----------

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