JDBC Connection to RAC Database Fails With "NL Exception Was Generated"

(Doc ID 1205594.1)

Last updated on SEPTEMBER 22, 2017

Applies to:

JDBC - Version 10.2.0.1 and later
Information in this document applies to any platform.

Symptoms


JDBC connections to a RAC database fail with the following exception:


Exception in thread "main" java.sql.SQLException: Io exception: NL Exception was generated
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:274)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:342)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:395)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:156)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:595)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at ConnectTest.main(ConnectTest.java:48)


The connect string URL resembles the following:

(DESCRIPTION=
   (ADDRESS=
      (PROTOCOL=TCP)
      (HOST=<host1>)
      (PORT = <PORT>)
   )
   (ADDRESS=
      (PROTOCOL=TCP)
      (HOST=<host2>)
      (PORT=<PORT>)
   )
   (LOAD_BALANCE=yes)
   (CONNECT_DATA=
      (SERVER=DEDICATED)
      (SERVICE_NAME=TEST)
   )
)

 

Changes

 

Cause

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