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, 1877🔥, 0💬
Popular Posts:
What Is Program Global Area (PGA) in Oracle? A Program Global Area (PGA) is a memory buffer that is ...
How to download Microsoft SQL Server 2005 Express Edition in SQL Server? Microsoft SQL Server 2005 E...
How To Drop a Stored Procedure in Oracle? If there is an existing stored procedure and you don't wan...
How To Verify a User name with SQLCMD Tool in SQL Server? The quickest way to verify a user name in ...
How to download and install Microsoft SQL Server Management Studio Express in SQL Server? Microsoft ...