JDBC/thin does not Currently Support the IFILE Clause Inside a TNSNAMES.ORA File

(Doc ID 1270872.1)

Last updated on MARCH 08, 2017

Applies to:

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


Since version 10.2 the JDBC/thin driver has the ability to read a tnsnames.ora file using the oracle.net.tns_admin property.

The JDBC/thin driver however cannot access additional TNS content pointed to by an IFILE clause residing inside the tnsnames.ora.
This is a JDBC/thin specific issue as the JDBC/OCI does not have this limitation.


java -Doracle.net.tns_admin=C:\dirA\network -classpath ".\ojdbc6.jar" Test

Content of C:\dirA\network\tnsnames.ora:


The JDBC/thin driver cannot read TNS entries located in C:\dirB\NETWORK\ADMIN\tnsnames.ora  while the JDBC/OCI can.


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