Integration

Hi,

After restoring our infrastructure database and oracle home from backups I am unable to get the OC4J_SECURITY to start. I had to really fiddle around with the restoration and it's possible I mucked something up there. Here are relevant parts of the logs, I'm hoping someone can advise me what the problem is and what I can do to fix it:

e:\oracle\product\10.1.4\identdev\opmn\logs\OC4J~OC4J_SECURITY~default_island~1
======================================================================================================
--------
09/09/13 11:02:49 Start process
--------
09/09/13 11:02:53 Warning: Error reading transaction-log file (/E:/oracle/product/10.1.4/identdev/j2ee/OC4J_SECURITY/persistence/OC4J_SECURITY_default_island_1/transaction.state) for recovery: premature end of file
09/09/13 11:02:53 Forced or abrupt (crash etc) server shutdown detected, starting recovery process...
09/09/13 11:02:53 Recovery completed, 0 connections committed and 0 rolled back...
09/09/13 11:02:55 SSOLoginServlet.init: Starting up SSO server ...
09/09/13 11:02:55 Initilize NLS utility...
09/09/13 11:02:55 Reading SSO server policy....
09/09/13 11:02:55 SSO: Entered FilePolicyManager constructor ...
09/09/13 11:02:55 SSO: FilePolicyManager: done loading the E:\oracle\product\10.1.4\identdev\sso\conf\policy.properties file
09/09/13 11:02:55 SSO: Leaving FilePolicyManager constructor ...
09/09/13 11:02:55 SSODebug: Done loading the debug file, E:/oracle/product/10.1.4/identdev/sso/log/ssoServer.log
09/09/13 11:02:57 SSO: Initializing the encryption objects failed
09/09/13 11:02:57 oracle.security.sso.server.conf.ConfigurationException: Missing SSO server configuration
09/09/13 11:02:57 at oracle.security.sso.server.conf.DatabaseConfigReader.init(DatabaseConfigReader.java:444)
09/09/13 11:02:57 at oracle.security.sso.server.auth.AuthUtil.init(AuthUtil.java:194)
09/09/13 11:02:57 at oracle.security.sso.server.ui.SSOLoginServlet.init(SSOLoginServlet.java:284)
09/09/13 11:02:57 at javax.servlet.GenericServlet.init(GenericServlet.java:258)
09/09/13 11:02:57 at com.evermind.server.http.HttpApplication.loadServlet(HttpApplication.java:2358)
09/09/13 11:02:57 at com.evermind.server.http.HttpApplication.findServlet(HttpApplication.java:4800)
09/09/13 11:02:57 at com.evermind.server.http.HttpApplication.initPreloadServlets(HttpApplication.java:4894)
09/09/13 11:02:57 at com.evermind.server.http.HttpApplication.initDynamic(HttpApplication.java:1026)
09/09/13 11:02:57 at com.evermind.server.http.HttpApplication.<init>(HttpApplication.java:560)
09/09/13 11:02:57 at com.evermind.server.Application.getHttpApplication(Application.java:915)
09/09/13 11:02:57 at com.evermind.server.http.HttpServer.getHttpApplication(HttpServer.java:707)
09/09/13 11:02:57 at com.evermind.server.http.HttpSite.initApplications(HttpSite.java:637)
09/09/13 11:02:57 at com.evermind.server.http.HttpSite.setConfig(HttpSite.java:278)
09/09/13 11:02:57 at com.evermind.server.http.HttpServer.setSites(HttpServer.java:278)
09/09/13 11:02:57 at com.evermind.server.http.HttpServer.setConfig(HttpServer.java:179)
09/09/13 11:02:57 at com.evermind.server.ApplicationServer.initializeHttp(ApplicationServer.java:2435)
09/09/13 11:02:57 at com.evermind.server.ApplicationServer.setConfig(ApplicationServer.java:1592)
09/09/13 11:02:57 at com.evermind.server.ApplicationServerLauncher.run(ApplicationServerLauncher.java:92)
09/09/13 11:02:57 at java.lang.Thread.run(Thread.java:534)
09/09/13 11:02:57 SSO: FAILED TO START SSO SERVER!
=============================================================================================================================

E:\oracle\product\10.1.4\identdev\sso\logs\ssoserver.log
=============================================================================================================================
Sun Sep 13 10:53:22 WST 2009 [DEBUG] Orion Launcher DBConnectionPool: Checking for DB connection errors..
Sun Sep 13 10:53:22 WST 2009 [ERROR] Orion Launcher SSO Server initialization failed. Check the DB availability and restart SSO Server
Sun Sep 13 10:53:22 WST 2009 [ERROR] Orion Launcher Initializing the encryption/decryption objects failed
oracle.security.sso.server.conf.ConfigurationException: Missing SSO server configuration
at oracle.security.sso.server.conf.DatabaseConfigReader.init(DatabaseConfigReader.java:444)
at oracle.security.sso.server.auth.AuthUtil.init(AuthUtil.java:194)
at oracle.security.sso.server.ui.SSOLoginServlet.init(SSOLoginServlet.java:284)
at javax.servlet.GenericServlet.init(GenericServlet.java:258)
at com.evermind.server.http.HttpApplication.loadServlet(HttpApplication.java:2358)
at com.evermind.server.http.HttpApplication.findServlet(HttpApplication.java:4800)
at com.evermind.server.http.HttpApplication.initPreloadServlets(HttpApplication.java:4894)
at com.evermind.server.http.HttpApplication.initDynamic(HttpApplication.java:1026)
at com.evermind.server.http.HttpApplication.<init>(HttpApplication.java:560)
at com.evermind.server.Application.getHttpApplication(Application.java:915)
at com.evermind.server.http.HttpServer.getHttpApplication(HttpServer.java:707)
at com.evermind.server.http.HttpSite.initApplications(HttpSite.java:637)
at com.evermind.server.http.HttpSite.setConfig(HttpSite.java:278)
at com.evermind.server.http.HttpServer.setSites(HttpServer.java:278)
at com.evermind.server.http.HttpServer.setConfig(HttpServer.java:179)
at com.evermind.server.ApplicationServer.initializeHttp(ApplicationServer.java:2435)
at com.evermind.server.ApplicationServer.setConfig(ApplicationServer.java:1592)
at com.evermind.server.ApplicationServerLauncher.run(ApplicationServerLauncher.java:92)
at java.lang.Thread.run(Thread.java:534)
Sun Sep 13 11:02:55 WST 2009 [DEBUG] Orion Launcher Done loading Policy Configurations
Sun Sep 13 11:02:55 WST 2009 [DEBUG] Orion Launcher Login Page Value: /sso/pages/login.jsp
Sun Sep 13 11:02:55 WST 2009 [DEBUG] Orion Launcher Change password Page location: /sso/pages/password.jsp
Sun Sep 13 11:02:55 WST 2009 [DEBUG] Orion Launcher Wireless Login Page location: /wirelesssso/wirelesslogin.jsp
Sun Sep 13 11:02:55 WST 2009 [DEBUG] Orion Launcher Wireless Change password Page location: /wirelesssso/wirelesscpwd.jsp
Sun Sep 13 11:02:55 WST 2009 [DEBUG] Orion Launcher Calling Initialization Methods ...
Sun Sep 13 11:02:55 WST 2009 [DEBUG] Orion Launcher Connection pool inactivity timeout (mins) 120
Sun Sep 13 11:02:55 WST 2009 [DEBUG] Orion Launcher SSO Admin Group: cn=iASAdmins,cn=Groups,cn=OracleContext
Sun Sep 13 11:02:55 WST 2009 [INFO] Orion Launcher Entered DBConnectionPool.init method ...
Sun Sep 13 11:02:56 WST 2009 [DEBUG] Orion Launcher Repository API returned - DB conn string: ldap://agspsrap01.agric.wa.gov.au:13061/infradev,cn=oraclecontext
Sun Sep 13 11:02:56 WST 2009 [DEBUG] Orion Launcher Setting max number of connections to 150 in the DB cache pool
Sun Sep 13 11:02:56 WST 2009 [DEBUG] Orion Launcher Setting minimum number of connections to 0 in the DB cache pool
Sun Sep 13 11:02:56 WST 2009 [DEBUG] Orion Launcher JDBC pool InactivityTimeout (secs) 7200
Sun Sep 13 11:02:56 WST 2009 [DEBUG] Orion Launcher JDBC pool PropertyCheckInterval(secs) 900
Sun Sep 13 11:02:56 WST 2009 [INFO] Orion Launcher Leaving DBConnectionPool.init method ...
Sun Sep 13 11:02:56 WST 2009 [INFO] Orion Launcher Entered DBConnectionPool.getConnection method ...
Sun Sep 13 11:02:57 WST 2009 [INFO] Orion Launcher Leaving DBConnectionPool.getConnection method ...
Sun Sep 13 11:02:57 WST 2009 [DEBUG] Orion Launcher SQL Exception received: java.sql.SQLException: ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "ORASSO.WWCTX_SSO", line 1579
ORA-06502: PL/SQL: numeric or value error
ORA-01400: cannot insert NULL into ("ORASSO"."WWCTX_SSO_SESSION$"."SUBSCRIBER_ID")
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "ORASSO.WWCTX_SSO", line 1579
ORA-06502: PL/SQL: numeric or value error
ORA-01400: cannot insert NULL into ("ORASSO"."WWCTX_SSO_SESSION$"."SUBSCRIBER_ID")
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "ORASSO.WWCTX_SSO", line 1579
ORA-06502: PL/SQL: numeric or value error
ORA-01400: cannot insert NULL into ("ORASSO"."WWCTX_SSO_SESSION$"."SUBSCRIBER_ID")
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "ORASSO.WWCTX_SSO", line 1579
ORA-06502: PL/SQL: numeric or value error
ORA-01400: cannot insert NULL into ("ORASSO"."WWCTX_SSO_SESSION$"."SUBSCRIBER_ID")
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "ORASSO.WWCTX_SSO", line 1579
ORA-06502: PL/SQL: numeric or value error
ORA-01400: cannot insert NULL into ("ORASSO"."WWCTX_SSO_SESSION$"."SUBSCRIBER_ID")
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "ORASSO.WWCTX_SSO", line 1579
ORA-06502: PL/SQL: numeric or value error
ORA-01400: cannot insert NULL into ("ORASSO"."WWCTX_SSO_SESSION$"."SUBSCRIBER_ID")
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "ORASSO.WWCTX_SSO", line 1579
ORA-06502: PL/SQL: numeric or value error
ORA-01400: cannot insert NULL into ("ORASSO"."WWCTX_SSO_SESSION$"."SUBSCRIBER_ID")
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "ORASSO.WWCTX_SSO", line 1579
ORA-06502: PL/SQL: numeric or value error
ORA-01403: no data found

Sun Sep 13 11:02:57 WST 2009 [DEBUG] Orion Launcher DBConnectionPool: Checking for DB connection errors..
Sun Sep 13 11:02:57 WST 2009 [ERROR] Orion Launcher SSO Server initialization failed. Check the DB availability and restart SSO Server
Sun Sep 13 11:02:57 WST 2009 [ERROR] Orion Launcher Initializing the encryption/decryption objects failed
oracle.security.sso.server.conf.ConfigurationException: Missing SSO server configuration
at oracle.security.sso.server.conf.DatabaseConfigReader.init(DatabaseConfigReader.java:444)
at oracle.security.sso.server.auth.AuthUtil.init(AuthUtil.java:194)
at oracle.security.sso.server.ui.SSOLoginServlet.init(SSOLoginServlet.java:284)
at javax.servlet.GenericServlet.init(GenericServlet.java:258)
at com.evermind.server.http.HttpApplication.loadServlet(HttpApplication.java:2358)
at com.evermind.server.http.HttpApplication.findServlet(HttpApplication.java:4800)
at com.evermind.server.http.HttpApplication.initPreloadServlets(HttpApplication.java:4894)
at com.evermind.server.http.HttpApplication.initDynamic(HttpApplication.java:1026)
at com.evermind.server.http.HttpApplication.<init>(HttpApplication.java:560)
at com.evermind.server.Application.getHttpApplication(Application.java:915)
at com.evermind.server.http.HttpServer.getHttpApplication(HttpServer.java:707)
at com.evermind.server.http.HttpSite.initApplications(HttpSite.java:637)
at com.evermind.server.http.HttpSite.setConfig(HttpSite.java:278)
at com.evermind.server.http.HttpServer.setSites(HttpServer.java:278)
at com.evermind.server.http.HttpServer.setConfig(HttpServer.java:179)
at com.evermind.server.ApplicationServer.initializeHttp(ApplicationServer.java:2435)
at com.evermind.server.ApplicationServer.setConfig(ApplicationServer.java:1592)
at com.evermind.server.ApplicationServerLauncher.run(ApplicationServerLauncher.java:92)
at java.lang.Thread.run(Thread.java:534)
======================================================================================================================

If anyone can give me a clue what to do about this I would be greatly appreciative

Thanks
Adam