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, 1989🔥, 0💬
Popular Posts:
How To Assign Debug Privileges to a User in Oracle? In order to run SQL Developer in debug mode, the...
How To Verify a User name with SQLCMD Tool in SQL Server? The quickest way to verify a user name in ...
How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...
How To Find Out What Privileges a User Currently Has in Oracle? Privileges granted to users are list...
How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Somet...