CRITICAL SKILL 4.3
Define Connections
This section will discuss the core components required to handle Oracle connections.
A Connect Descriptor
A connect descriptor is used to define the service name and the location of the database. The address component of a connect descriptor defines the protocol, host name, and port number. Though port numbers can be between 1 to 65535, those from 1 to 1024 are usually reserved for special processes. The connect data component of the description describes the service to which you want to connect. If you do not include the instance_name in your descriptor, it will default to the Oracle SID if not defined.
A sample connect descriptor for customer.us.trubix.com looks like the following:
(DESCRIPTION = (ADDRESS=(PROTOCOL=tcp) ...
Get Oracle Database 10g: A Beginner's Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
