My Oracle Support Banner

SOADataSource is Suspended with Exception “ORA-12514: TNS:listener Does Not Currently Know Of Service Requested In Connect Descriptor” (Doc ID 1951492.1)

Last updated on MARCH 18, 2018

Applies to:

Oracle SOA Suite - Version 11.1.1.6.0 to 11.1.1.9.0 [Release 11gR1 to 11g]
Oracle Service Bus - Version 12.1.3.0.0 and later
Information in this document applies to any platform.

Symptoms

SOA Datasources are suspended and the logs shows the below exception:

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

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:482)
at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:678)
at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:238)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:34)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:567)
at oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:404)
at oracle.jdbc.xa.client.OracleXADataSource.getPooledConnection(OracleXADataSource.java:674)
at oracle.jdbc.xa.client.OracleXADataSource.getXAConnection(OracleXADataSource.java:267)
........
Caused By: oracle.net.ns.NetException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

at oracle.net.ns.NSProtocol.connect(NSProtocol.java:411)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1222)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:330)
at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:678)
at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:238)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:34)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:567)
...



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.