What Is a Connect Identifier in Oracle

Q

What Is a Connect Identifier in Oracle?

✍: FYIcenter.com

A

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:

  • 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, 1843🔥, 0💬