Software QA (13)
SQL Server (1)
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 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost) (PORT = 1521) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE) ) )
See other tutorials for more details.
2007-04-17, 7830👍, 0💬
What Is URI? URI (Uniform Resource Identifier) is a superset of URL. URI provides a simple and exten...
What are the types of variables x, y, y and u defined in the following code? #define Atype int* type...
What are some advantages and disadvantages of Java Sockets? Advantages of Java Sockets: Sockets are ...
How To Use SELECT Statement to Count the Number of Rows? - Oracle DBA FAQ - Understanding SQL SELECT...
What are shared (VB.NET)/Static(C#) variables? Static/Shared classes are used when a class provides ...