Oracle Observations

May 23, 2007

Where are those tnsnames entries defined?

Filed under: SQL*Net — bigdaveroberts @ 3:53 pm

One thing that surprised me when running oracle utilities through truss was the first location that Oracle tries to find the tnsnames data from.

Rather that looking in $ORACLE_HOME/network/admin or $TNS_ADMIN for tnsnames.ora, it appears that the first thing it does is look in the .tnsnames.ora file in the current working directory.

Blog at