Verify Oracle TNS Settings in Oracle

Q

How To Verify Oracle TNS Settings in Oracle?

✍: FYIcenter.com

A

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 =
  (DESCRIPTION =
    (ADDRESS = 
      (PROTOCOL = TCP)(HOST = localhost)
      (PORT = 1521)
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = XE)
    )
  )

See other tutorials for more details.

 

ODBC Drivers and DSN Configuration for Oracle

⇒⇒Oracle Database Tutorials

2016-10-15, 140👍, 0💬