OC4J_SECURITY Startup Fails with ORA-1017 Error (Doc ID 1156453.1)

Last updated on FEBRUARY 06, 2017

Applies to:

Oracle Application Server Single Sign-On - Version 10.1.2 to 10.1.4.3 [Release 10gR2 to 10gR3]
Information in this document applies to any platform.
***Checked for relevance on 06-Feb-2017***

Symptoms

10.1.x.x SSO Server is not starting up with OID loaded into a 11g DB (11.x.x).

Below error is found in Oracle_Home/sso/log/ssoServer.log file.


Mon Jul 19 16:55:41 EST 2010 [INFO] Orion Launcher Leaving DBConnectionPool.init method ...
Mon Jul 19 16:55:41 EST 2010 [INFO] Orion Launcher Entered DBConnectionPool.getConnection method ...
Mon Jul 19 16:55:44 EST 2010 [ERROR] Orion Launcher DB connection error
java.sql.SQLException: ORA-01017: invalid username/password; logon denied

.....
...............
at com.evermind.server.ApplicationServer.setConfig(ApplicationServer.java:1551)
at com.evermind.server.ApplicationServerLauncher.run(ApplicationServerLauncher.java:92)
at java.lang.Thread.run(Thread.java:534)
Mon Jul 19 16:55:44 EST 2010 [DEBUG] Orion Launcher DBConnectionPool: Checking for DB connection errors..
Mon Jul 19 16:55:44 EST 2010 [ERROR] Orion Launcher In class, DatabaseConfigReader: Could not get the DB connection
Mon Jul 19 16:55:44 EST 2010 [ERROR] Orion Launcher SSO Server initialization failed. Check the DB availability and restart SSO Server
Mon Jul 19 16:55:44 EST 2010 [ERROR] Orion Launcher Initializing the encryption/decryption objects failed

oracle.security.sso.server.conf.ConfigurationException: Invalid SSO DB schema information
at oracle.security.sso.server.conf.DatabaseConfigReader.init(DatabaseConfigReader.java:418)
at oracle.security.sso.server.auth.AuthUtil.init(AuthUtil.java:194)
at oracle.security.sso.server.ui.SSOLoginServlet.init(SSOLoginServlet.java:284)



Also, Oracle_Home/opmn/logs/OC4J_Security_default_island.log file shows the following error


10/07/19 16:55:37 oiddas: Release 10.1.4.0.1 Production Started
.....
.......
10/07/19 16:55:39 DAS servlet init exit
10/07/19 16:55:40 SSOLoginServlet.init: Starting up SSO server ...
10/07/19 16:55:40 Initilize NLS utility...
10/07/19 16:55:40 Reading SSO server policy....
10/07/19 16:55:40 SSO: Entered FilePolicyManager constructor ...
10/07/19 16:55:40 SSO: FilePolicyManager: done loading the /orasoft/app/oracle/OraHome_SSO/sso/conf/policy.properties file
10/07/19 16:55:40 SSO: Leaving FilePolicyManager constructor ...
10/07/19 16:55:40 SSODebug: Done loading the debug file, /orasoft/app/oracle/OraHome_SSO/sso/log/ssoServer.log
10/07/19 16:55:44 SSO: Initializing the encryption objects failed
10/07/19 16:55:44 oracle.security.sso.server.conf.ConfigurationException: Invalid SSO DB schema information

10/07/19 16:55:44 at oracle.security.sso.server.conf.DatabaseConfigReader.init(DatabaseConfigReader.java:418)
10/07/19 16:55:44 at oracle.security.sso.server.auth.AuthUtil.init(AuthUtil.java:194)
.....
.......
com.evermind.server.ApplicationServerLauncher.run(ApplicationServerLauncher.java:92)
10/07/19 16:55:44 at java.lang.Thread.run(Thread.java:534)
10/07/19 16:55:44 SSO: FAILED TO START SSO SERVER!

Changes

In an HA (High Availability) environment, SSO server was working fine with OID1 server.
Then, SSO server was re-configured to OID2 server which was a replica of OID1 server.
Due to this, SSO server was unable to start with errors mentioned in log files, even though the ORASSO schema password was correct.

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