Connecting to an Oracle data source using a custom URL

Use this information to create an Oracle data source that uses a custom JDBC URL to connect to the database.

To connect your Oracle data source with a custom URL, set the Connection Options to Customized URL. Enter the JDBC connecting string into the custom URL field.

Example 1

To connect your Oracle data source to an Oracle database with the service name ORCL on port 1521, enter the following value into the Custom URL field:

(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = host1)(PORT = 1521))(CONNECT_DATA = (SERVICE_NAME = ORCL)))

Example 2

To connect your Oracle data source to an Oracle Connection Manager with the service name ORCL, enter the following value into the Custom URL field:

(DESCRIPTION = (RETRY_COUNT = 20)(RETRY_DELAY = 3)(SOURCE_ROUTE = YES)
  (ADDRESS = (PROTOCOL = TCP)(HOST = host1)(PORT = port1))
  (ADDRESS = (PROTOCOL = TCP)(HOST= host2)(PORT = port2))
  (CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = ORCL))
)

Example 3

To connect your Oracle data source to an Oracle RAC cluster, enter the JDBC connection string into the custom URL field. For example:

(DESCRIPTION =
  (ADDRESS = (PROTOCOL = TCP)(HOST = host1)(PORT = port1))
  (ADDRESS = (PROTOCOL = TCP)(HOST = host2)(PORT = port2))
  (LOAD_BALANCE = yes)
  (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = service-name)
    (FAILOVER_MODE =(TYPE = SELECT)(METHOD = BASIC)(RETRIES = 180)(DELAY = 5))
  )
)