JDBC Connection to RAC Database Fails With "NL Exception Was Generated" (Doc ID 1205594.1)

Last updated on MARCH 27, 2023

Applies to:

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)

The connect string URL resembles the following:

Changes

Cause

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