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.
2016-10-15, 855👍, 0💬
Popular Posts:
How To Get the Definition of a User Defined Function Back in SQL Server Transact-SQL? If you want ge...
How To Create a Simple Stored Procedure in SQL Server Transact-SQL? If you want to create a simple s...
How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Somet...
How To Create a Dynamic Cursor with the DYNAMIC Option in SQL Server Transact-SQL? If the underlying...
Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...