Collections:
What Is a Connect Identifier in Oracle
What Is a Connect Identifier in Oracle?
✍: 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:
⇒ Connect SQL*Plus Session to Oracle Server in Oracle
⇐ Requirements for SQL*Plus Connection in Oracle
2020-08-13, 4561🔥, 0💬
Popular Posts:
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...
Where to find answers to frequently asked questions on PHP Connections and Query Execution for MySQL...
Where to find reference information and tutorials on MySQL database functions? I want to know how to...