JDBC/thin fails to connect using SCAN with NL Exception TNS-04602 Invalid syntax error (Doc ID 2023954.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

JDBC/thin application fails to connect due to "NL Exception". The error is specific to using a SCAN IP and does not reproduce with the VIP address.

The connect error is specific to JDBC/thin.  SQL Plus connections work fine.
Issue reproduces both the JDBC 11.2.0.3 and JDBC 12.1.0.2 drivers.

Example:

 

 

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