Collections:
Verify Oracle TNS Settings in Oracle
How To Verify Oracle TNS Settings in Oracle?
✍: FYIcenter.com
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.
⇒ Define DSN with ODBC Manager in Oracle
⇐ Create Tables for ODBC Connection Testing in Oracle
2016-10-15, 1715🔥, 0💬
Popular Posts:
What Is a Parameter File in Oracle? A parameter file is a file that contains a list of initializatio...
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and l...
How To Create a Table Index in Oracle? If you have a table with a lots of rows, and you know that on...
How to download and install Microsoft SQL Server Management Studio Express in SQL Server? Microsoft ...
Where to find answers to frequently asked questions on Transaction Management: Commit or Rollback in...