René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback
 

Connect descriptor [Oracle Net]

A client needs a connect descriptor in order to connect to an Oracle instance.
A connect descriptor usually has two components:
  • The address of the listener (ADDRESS section)
  • The SID of the instance. (CONNECT_DATA section)
The connect descriptor looks in its most basic form like so
(DESCRIPTION=
   (ADDRESS=
      (address-specific-things)
   )
   (CONNECT_DATA=
      (connect-data-specific-things)
   )
)

ADDRESS section

Yet to be finished...

CONNECT_DATA section

Yet to be finished...

Assigning a net service name to a connect descriptor

Since a connect descriptor is rather lengthy in its syntax, it's possible to define a net service name as an alias for the connect descriptor. One can then use the net service name in place of the connect descriptor. This can be done, for example, in the tnsnames.ora file.