Verify Oracle TNS Settings in Oracle


How To Verify Oracle TNS Settings in Oracle?



If you have installed an Oracle server or an Oracle client tool on your local system, the TNS is automatically installed with a simple configuration file, tnsnames.ora, to define Oracle connect identifiers.

For example, if you have Oracle XE server installed, you will have the tnsnames.ora located at \oraclexe\app\oracle\product\10.2.0\server\NETWORK\ADMIN. It should contain a connect identifier called XE defined as:

XE =
    (ADDRESS = 
      (PROTOCOL = TCP)(HOST = localhost)
      (PORT = 1521)

See other tutorials for more details.


ODBC Drivers and DSN Configuration for Oracle

⇒⇒Oracle Database Tutorials

2016-10-15, 140👍, 0💬