My Oracle Support Banner

TNS-12514 When Connecting To One Instance Of A RAC When The Others are Down (Doc ID 2756311.1)

Last updated on MARCH 09, 2021

Applies to:

JDBC - Version 12.1.0.2.0 to 12.2.0.0.0 [Release 12.1 to 12c]
Information in this document applies to any platform.

Symptoms

WebLogic 12.2.1.3  (JDBC Thin 12.2.0.1) reports the following exception randomly when connecting to a 4 node RAC with SCAN when only database instance 3 is up.

ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
at oracle.net.ns.NSProtocolNIO.negotiateConnection(NSProtocolNIO.java:271)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:317)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1438)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:518)


With the database instance 1 up and the other instances down. Status: all connections are successful.
With the database instance 2 up and the other instances down. Status: all connections are successful.
With the database instance 3 up and the other instances down. Status: connections fail intermittently with ORA-12514 (most connections fail).
With the database instance 4 up and the other instances down. Status: all connections are successful.

The issue does not reproduce with SQL*Plus or JDBC OCI connections. It only reproduces with JDBC Thin.



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


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