Oracle Driver

Oracle Driver

Driver Name: oracle

Driver Connection String Options:

• dsn: Conditional. Data Source Name as specified in tnsnames.ora, or a fully qualified connection string. If not specified, both host and service_name must both be specified and a connection string will be dynamically generated. Use of this parameter negates the ability to use mstdlib's load balancing and failover logic, but facilitates the use of Oracle's equivalent functionality. An example of a fully qualified connection string would be:

  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(Host = 10.100.10.168)(Port = 1521))
    (CONNECT_DATA = (SERVICE_NAME = orcl))
  )

• host: Conditional. If dsn is not specified, this parameter must be specified along with the service_name parameter. This is the hostname or IP address of the server. If not using the default port of 1521, may append a ":port#" to the end of the host. For specifying multiple hosts in a pool, hosts should be comma delimited. Cannot be used with dsn.

  host=10.40.30.2,10.50.30.2:11521  

• service_name: Conditional. If dsn is not specified, this parameter must be specified along with the host parameter. Cannot be used with dsn.

  service_name=orcl 

Example with dsn:

dsn='(DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(Host = 10.100.10.168)(Port = 1521))
      (CONNECT_DATA = (SERVICE_NAME = orcl))
    )'

Example without dsn:

host=10.100.10.168;service_name=orcl