Unix/Linux搜寻tnsnames.ora规则

Oracle Net Services configuration files are typically, but not always, located in the$ORACLE_HOME/network/admindirectory

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

The search order for thesqlnet.oraandldap.orafiles is as follows:

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

2.   The$ORACLE_HOME/network/admindirectory

The search order for thecman.ora,listener.ora, andtnsnames.orafiles is as follows:

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

2.   One of the following directories:

o   On Solaris:

o   /var/opt/oracleo   On other platforms:

o   /etc3.   The$ORACLE_HOME/network/admindirectory