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, 1678🔥, 0💬
Popular Posts:
How To Convert Characters to Numbers in Oracle? You can convert characters to numbers by using the T...
How To Use "IF ... ELSE IF ..." Statement Structures in SQL Server Transact-SQL? "IF ... ELSE IF ......
Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for ...
How To Install PHP on Windows in MySQL? The best way to download and install PHP on Windows systems ...
How to download and install SQL Server 2005 Sample Scripts in SQL Server? If you want to learn from ...