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).

Please follow and like us:

Leave a Reply

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