ORA-12514 When Using JDBC 12.2.0.1.0 And a Low TRANSPORT_CONNECT_TIMEOUT In The JDBC URL
(Doc ID 2389415.1)
Last updated on NOVEMBER 06, 2023
Applies to:
JDBC - Version 12.2.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
ORA-12514 TNS:listener does not currently know of service requested in connect descriptor occurs when using JDBC 12.2.0.1.0 to connect to Oracle 11.2.0.4 Active Data Guard instance using OID.
When trying to connect using ojdbc8.jar (thin client) URL, the ORA-12514 is received if using TRANSPORT_CONNECT_TIMEOUT=3 in the OID entry.
Removal of this entry makes it work, but then the listener log file grows uncontrollably.
ERROR
-----------------------
18-APR-2018 11:30:38 * (CONNECT_DATA=(CID=(PROGRAM=null)(HOST=__jdbc__)(USER=null))(SERVICE_NAME=<SERVICE NAME>)) * (ADDRESS=(PROTOCOL=tcp)(HOST=<IP>)(PORT=<PORT>)) * establish * ..... * 12514 TNS-12514: TNS:listener does not currently know of service requested in connect descriptor Trace File Location : ....:..../trace/listener_cad.log
Changes
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 |
Changes |
Cause |
Solution |
References |