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 03, 2016

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.
***Checked for relevance on 05-Nov-2013***

Symptoms

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)

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