Oracle Net configuration files

Oracle Net may be configured via several files, but only two are mandatory files: The listener.ora file must reside on the Oracle server. It contains configuration data for running the tnslsnr listener process (Linux) and OracleTNSListener Windows service (Windows) including a list of databases for which it should listen for connection requests. The tnsnames.ora file must reside on an Oracle client. It contains the connect descriptors and their aliases for the databases to which this client connects. This file must also reside on an Oracle server. On Windows, Siemens Digital Industries Software also configures the sqlnet.ora file, which must reside on the Oracle server and client and contains additional configuration parameters. There are other files that can be created but if they do not exist, Oracle assumes defaults. Additionally, certain files only apply to products and functions which Teamcenter is not likely to use. These files may reside in several locations. The search path that Oracle uses to locate these files on Linux is as follows: HOME/.file-name.ora TNS_ADMIN/file-name.ora ORACLE_HOME/network/admin/file-name.ora The search path that Oracle uses to locate these files on Windows is as follows: file-name.ora in the current directory TNS_ADMIN\file-name.ora ORACLE_HOME\network\admin\file-name.ora TNS_ADMIN is an environment variable that can point to any directory on the system where you want to keep these files. On Windows, file-name.ora implies the listener.ora, tnsnames.ora and sqlnet.ora files. On Linux, file-name.ora implies both the listener.ora and tnsnames.ora files. Note that in the case of the HOME directory location, these files are hidden.