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 10.2.0.4 and later
Information in this document applies to any platform.

Symptoms

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.

example:

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



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

ifile=C:\dirB\NETWORK\ADMIN\tnsnames.ora


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

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