unix/linux搜尋tnsnames.ora規則

Oracle Net Services configuration files are typically, but not always, located in the $ORACLE_HOME/network/admin directory. Depending on the type of file, Oracle Net uses a different search order to locate the file.

The search order for the sqlnet.ora and ldap.ora files is as follows:

1.    The directory specified by the TNS_ADMIN environment variable, if this environment variable is set

2.    The $ORACLE_HOME/network/admin directory

The search order for the cman.ora, listener.ora, and tnsnames.ora files is as follows:

1.    The directory specified by the TNS_ADMIN environment variable, if this environment variable is set

2.    One of the following directories:

o    On Solaris:

o    /var/opt/oracle

o    On other platforms:

o    /etc

3.    The $ORACLE_HOME/network/admin directory