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:
Â
2020-08-13, 1262👍, 0💬
Popular Posts:
What Is an Oracle Instance in Oracle? Every running Oracle database is associated with an Oracle ins...
How To Recreate an Existing Index in SQL Server? If you want to change the definition of an existing...
How To Format DATETIME Values to Strings with the CONVERT() Function in SQL Server Transact-SQL? SQL...
How To Convert Binary Strings into Hexadecimal Character Strings in SQL Server? When a query returns...
How To Calculate DATETIME Value Differences Using the DATEDIFF() Function in SQL Server Transact-SQL...