My Oracle Support Banner

OC4J_SECURITY not starts. ssoServer.log ORA-12514, TNS:listener does not currently know of service requested in connect descriptor (Doc ID 605430.1)

Last updated on AUGUST 15, 2024

Applies to:

Oracle Application Server Single Sign-On - Version 10.1.2.0.2 to 10.1.4.3 [Release 10gR2 to 10gR3]
Information in this document applies to any platform.

Symptoms

Unable to start  OC4J_SECURITY

ssoServer.log is showing the following errors:

--------------------------------------------

Wed Jul 02 14:35:14 IST 2008 [ERROR] Orion Launcher DB connection pool creation error
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
The Connection descriptor used by the client was:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<DB_HOSTNAME>)(PORT=<DB_PORT>))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=<SERVICE_NAME>)))

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:137)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:292)
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 oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:217)
at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPhysicalConnection(OracleConnectionPoolDataSource.java:108)
at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPooledConnection(OracleConnectionPoolDataSource.java:76)
at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPooledConnection(OracleConnectionPoolDataSource.java:58)
at oracle.jdbc.pool.OracleConnectionCacheImpl.getNewPoolOrXAConnection(OracleConnectionCacheImpl.java:505)

 

OC4J~OC4J_SECURITY~default_island~1 log shows:

08/07/02 14:35:14 SSO: DB Error. Please make sure the database is available and restart SSO Server
08/07/02 14:35:14 oracle.security.sso.server.util.DBException: Could not create DB connection pool of: jdbc:oracle:thin:@ldap://<DB_HOSTNAME>:<DB_PORT>/<INSTANCE_NAME>,cn=oraclecontext
08/07/02 14:35:14 at oracle.security.sso.server.util.DBConnectionPool.init(DBConnectionPool.java:181)
08/07/02 14:35:14 at oracle.security.sso.server.util.DBConnectionPool.init(DBConnectionPool.java:82)
08/07/02 14:35:14 at oracle.security.sso.server.ui.SSOLoginServlet.init(SSOLoginServlet.java:235)
08/07/02 14:35:14 at javax.servlet.GenericServlet.init(GenericServlet.java:258)
08/07/02 14:35:14 at com.evermind.server.http.HttpApplication.loadServlet(HttpApplication.java:2354)
08/07/02 14:35:14 at com.evermind.server.http.HttpApplication.findServlet(HttpApplication.java:4795)
08/07/02 14:35:14 at com.evermind.server.http.HttpApplication.initPreloadServlets(HttpApplication.java:4889)
08/07/02 14:35:14 at com.evermind.server.http.HttpApplication.initDynamic(HttpApplication.java:1015)
08/07/02 14:35:14 at com.evermind.server.http.HttpApplication.<init>(HttpApplication.java:549)
08/07/02 14:35:14 at com.evermind.server.Application.getHttpApplication(Application.java:890)
08/07/02 14:35:14 at com.evermind.server.http.HttpServer.getHttpApplication(HttpServer.java:707)
08/07/02 14:35:14 at com.evermind.server.http.HttpSite.initApplications(HttpSite.java:625)
08/07/02 14:35:14 at com.evermind.server.http.HttpSite.setConfig(HttpSite.java:278)
08/07/02 14:35:14 at com.evermind.server.http.HttpServer.setSites(HttpServer.java:278)
08/07/02 14:35:14 at com.evermind.server.http.HttpServer.setConfig(HttpServer.java:179)
08/07/02 14:35:14 at com.evermind.server.ApplicationServer.initializeHttp(ApplicationServer.java:2394)
08/07/02 14:35:14 at com.evermind.server.ApplicationServer.setConfig(ApplicationServer.java:1551)
08/07/02 14:35:14 at com.evermind.server.ApplicationServerLauncher.run(ApplicationServerLauncher.java:92)
08/07/02 14:35:14 at java.lang.Thread.run(Thread.java:534)
08/07/02 14:35:14 SSO: FAILED TO START SSO SERVER!

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution

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