Oracle Connection Manager is a network solution that serves as a proxy to Oracle database servers and clusters. In addition to being a single point of access, Oracle Connection Manager offers a number of network solutions, including increased scalability, simplified access control, and improved availability. The driver supports Oracle Connection Manager for connections that are defined using the TNSNAMES.ORA file.
To connect to Oracle Connection Manager:
In the TNSNAMES.ORA file:
Define the net service name entry for your Oracle Connection Manager service. When using Oracle Connection Manager, the definition must contain the keyword-value pair SOURCE_ROUTE=YES. Refer to the documentation for your Oracle database for details and the latest information.
Oracle net service name definitions support the SOURCE_ROUTE keyword at the DESCRIPTION_LIST, DESCRIPTION, and ADDRESS_LIST levels. Currently, the driver supports defining SOURCE_ROUTE at the DESCRIPTION and ADDRESS_LIST levels, but not at the DESCRIPTION_LIST level.
For the driver:
Set the TNSNames File (TNSNamesFile) to specify the name(s) and location(s) of the TNSNAMES.ORA file(s) that contains the net service name definition for your Oracle Connection Manager service.
Set the Server Name (ServerName) option to specify the net service name for the Oracle Connection Manger service defined in the TNSNAMES.ORA file. The corresponding net service name entry in the TNSNAMES.ORA file is used to obtain connection information.
The following examples demonstrate a basic connection through Oracle Connection Manager.
In the TNSNAMES.ORA file: