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:
What Is a Connect Identifier
What Is a Connect Identifier? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool
✍: FYIcenter.com
A "connect identifier" is an identification string of a single set of connection information to a specific target database instance on a specific Oracle server.
Connect identifiers are defined and stored in a file called tnsnames.ora located in $ORACLE_HOME/network/admin/ directory. Here is one example of a "connect identifier" definition:
FYI_XE = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = dba.fyicenter.com) (PORT = 1521) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE) ) )
The above "connect identifier" defines "TNS_XE" with the following connection information:
2007-04-28, 5638👍, 0💬
Popular Posts:
How to convert a Unix timestamp to a Win32 FILETIME or SYSTEMTIME? The following function converts a...
.NET INTERVIEW QUESTIONS - What are types of compatibility in VB6? There are three possible project ...
What's the difference between J2SDK 1.5 and J2SDK 5.0? There is no difference, Sun Microsystems just...
How To Display a Past Time in Days, Hours and Minutes? - MySQL FAQs - Managing Tables and Running Qu...
. How can a servlet refresh automatically if some new data has entered the database? You can use a c...