JDBC 11.2.0.2 Connecting to SCAN Listener Throws Error "oracle.net.ns.NetException: NL Exception was generated"
(Doc ID 1369165.1)
Last updated on AUGUST 30, 2023
Applies to:
JDBC - Version 11.2.0.2.0 to 11.2.0.3.0 [Release 11.2]Information in this document applies to any platform.
Symptoms
This issue occurs using JDBC driver 11.2.0.2 and 11.2.0.3 with wallets involved connecting to a RAC database via a SCAN listener. Although SQL*Plus and JDBC OCI will connect successfully in this configuration, and JDBC thin works fine when connecting to the local listeners, trying to go via SCAN fails with:
Caused by: oracle.net.ns.NetException: NL Exception was generated
at oracle.net.resolver.AddrResolution.resolveAddrTree(AddrResolution.java:623)
at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:420)
at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:872)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:395)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1595)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:361)
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 |