How to: locate Oracle network configuration file (TNSNAMES.ORA)

TNSNAMES.ORA is a configuration file which stores information about connection strings to Oracle databases. It is located under %ORACLE_HOME%networkadmin (or on Unix server $ORACLE_HOME/network/admin). You may also use set oracle_home command to quickly check the configured value of this environment variable on a Windows machine.\n\nBrowsing through this file allows you to find out such connection properties as protocol, host, port and sid. Alternatively if you know connection name/alias you may use tnsping command to resolve alias and find out all connection parameters (let’s say to use them for configuring connection in Oracle SQL Developer).

Leave a Reply

Your email address will not be published. Required fields are marked *