ORA-12514 When Using JDBC 184.108.40.206.0 To Connect To Oracle 220.127.116.11 Active Data Guard Instance From OID And a Low TRANSPORT_CONNECT_TIMEOUT In The JDBC URL
Last updated on APRIL 24, 2018
Applies to:JDBC - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
ORA-12514 TNS:listener does not currently know of service requested in connect descriptor occurs when using JDBC 22.214.171.124.0 to connect to Oracle 126.96.36.199 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.
18-APR-2018 11:30:38 * (CONNECT_DATA=(CID=(PROGRAM=null)(HOST=__jdbc__)(USER=null))(SERVICE_NAME=....)) * (ADDRESS=(PROTOCOL=tcp)(HOST=<ip address>)(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
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