What is a connect descriptor?

Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.

What is a connect descriptor?

Rating:

A connect descriptor is a specially formatted description that provides the location of a database and the name of the database service. In other words, a connect descriptor contains the destination database service and network route information. The destination database service is indicated by using its service name for Oracle9i or Oracle8i databases or its Oracle System Identifier (SID) for Oracle release 8.0 databases. The network route provides the location of a listener.

A connect descriptor has two sections, ADDRESS and CONNECT_DATA. The ADDRESS section of the connect descriptor contains protocol addresses of one or more listeners. The CONNECT_DATA section of the connect descriptor contains the destination database's service name or Oracle System Identifier (SID).

The following example shows a connect descriptor that enables clients to connect to a database service called sales.us.acme.com:

(DESCRIPTION=
(ADDRESS= (PROTOCOL=tcp) (HOST=sales-server) (PORT=1521))
(CONNECT_DATA= (SERVICE_NAME=sales.us.acme.com)))

Rating: