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:

    (ADDRESS = 
      (PROTOCOL = TCP)
      (HOST = dba.fyicenter.com)
      (PORT = 1521)

The above "connect identifier" defines "TNS_XE" with the following connection information:

  • The network hostname: dba.fyicenter.com.
  • The network port number: 1521.
  • The name of the target database instance: XE.


Connect SQL*Plus Session to Oracle Server in Oracle

Requirements for SQL*Plus Connection in Oracle

Introduction to Command-Line SQL*Plus Client Tool

⇑⇑ Oracle Database Tutorials

2020-08-13, 1826🔥, 0💬