ossoca.jar reassoc –repos Fails, ERROR: Exception While Updating OID Information Stored in SSO Database (Doc ID 434470.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Application Server Single Sign-On - Version 10.1.2.0.2 and later
Information in this document applies to any platform.
***Checked for relevance on 18-APR-2013***

Symptoms

Run the following command:

ORACLE_HOME/jdk/bin/java -jar $ORACLE_HOME/sso/lib/ossoca.jar reassoc -repos

Returns following error:

Parameters passed to ssoca : param0:reassoc param1:-repos param2:
<oracle_home_reference>
ERROR : Exception while updating OID information stored in SSO Database :
java.sql.SQLException: Io exception: NL Exception was generated
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.
java:137)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.
java:174)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.
java:286)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:327)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:
433)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:150)
at oracle.jdbc.driver.T4CDriverExtension.
getConnection(T4CDriverExtension.java:31)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:571)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at oracle.security.sso.SSOConfigAssistant.
ssoReassocRepos(SSOConfigAssistant.java:378)
at oracle.security.sso.SSOConfigAssistant.main(SSOConfigAssistant.java:
220)
SSO Configuration Assistant failed.

 

Additional Information:

Executing “Task 4: Update OracleAS Single Sign-On” running command as defined in the
http://docs.oracle.com/cd/B14099_19/core.1012/b13995/ports.htm#i1035168

Changes

Changed the Infrastructure Medatada Repository database listener port from 1521 to 1523 per Oracle® Application Server Administrator's Guide, 10g Release 2 (10.1.2)
Part No. B13995-01, chapter 4.4.1 Changing the OracleAS Metadata Repository Net Listener Port.

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