Where is the SQL*Net configuration files located?

The SQL*Net configuration files (like SQLNET.ORA and TNSNAMES.ORA) can be found in one of the following locations (SQL*Net searches for it in this order):

  • Directory pointed to by the TNS_ADMIN parameter ($TNS_ADMIN on Unix)
  • /etc (Unix only)
  • /var/opt/oracle (Unix only)
  • $ORACLE_HOME/network/admin (or sometimes net8/admin directory)