Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Check the Oracle TNS Settings
How To Check the Oracle TNS Settings? - Oracle DBA FAQ - ODBC Drivers, DSN Configuration and ASP Connection
✍: 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.
2007-04-17, 8006👍, 0💬
Popular Posts:
Can JavaScript steal text from your clipboard? It is true, text you last copied for pasting (copy &a...
What is difference between Association, Aggregation and Inheritance relationships? In object oriente...
How Can we change priority & what levels of priority are provided by Dot Net? Thread Priority ca...
What is the difference between strings and character arrays? A major difference is: string will have...
Can two catch blocks be executed? No, once the proper catch section is executed the control goes fin...