tnsnames.ora file

A configuration file that contains net service names mapped to connect descriptors. This file is used for the local naming method.

The tnsnames.ora file must reside in one of the following locations:

1. The directory specified by the TNS_ADMIN environment variable If the TNS_ADMIN environment variable is not defined as a variable on Windows NT, it may be in the registry.

2. The node's global configuration directory. For Sun Solaris, this directory is /var/opt/oracle. Windows NT does not have a central directory.

3. The $ORACLE_HOME/network/admin directory on UNIX or the ORACLE_HOME \network\admin directory on Windows operating systems.

Related Topics

Oracle Net Services Configuration Overview

Copyright © 1996, 2009, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.
Other names may be trademarks of their respective owners.