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, 844👍, 0💬
Popular Posts:
How To Calculate DATETIME Value Differences Using the DATEDIFF() Function in SQL Server Transact-SQL...
How To Recover a Dropped Index in Oracle? If you have the recycle bin feature turned on, dropped ind...
How To Concatenate Two Text Values in Oracle? There are two ways to concatenate two text values toge...
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...
How To Change the Name of a Database User in SQL Server? If you want to change the name of an existi...