How To Check the Oracle TNS Settings


How To Check the Oracle TNS Settings? - Oracle DBA FAQ - ODBC Drivers, DSN Configuration and ASP Connection



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.

2007-04-17, 6877👍, 0💬