Modifying the Oracle Database Adapter service form for OCI

To configure OCI communication between the Oracle adapter and the Oracle database, you must modify the Oracle adapter service form.

Procedure

Select the Use OCI communication with Oracle check box.
If the Use OCI communication with Oracle check box is selected, the adapter uses the JDBC OCI driver to communicate with the Oracle database server. When this check box is not selected, the adapter uses the JDBC Thin driver to communicate with the Oracle database server.
Enter a value for the Oracle Service Alias field that corresponds to the net service alias listed in the tnsnames.ora file.
The net service alias name is on the left side of the equals (=) sign in the tnsnames.ora file. The example tnsnames.ora file in Configuring Oracle Net Services uses PRODONE as the net service name for TAF. For this example configuration, enter PRODONE in the Oracle Service Alias field.

What to do next

If you are using the JDBC OCI driver, and you want to use SSL communication, then you must complete further configuration. The Use SSL communication with Oracle check box is only for the JDBC Thin driver. To enable SSL communication between the Oracle adapter and the Oracle database for the JDBC OCI driver, you must include SSL information in the Oracle Net Services files.

The information in the following files serves as an example of how you can configure Transparent Application Failover with SSL:

sqlnet.ora:

SQLNET.AUTHENTICATION_SERVICES= (TCPS)
NAMES.DIRECTORY_PATH= (TNSNAMES)

SSL_VERSION = 3.0
SSL_CLIENT_AUTHENTICATION = FALSE
SSL_SERVER_DN_MATCH = YES

WALLET_LOCATION =
  (SOURCE =
    (METHOD = FILE)
    (METHOD_DATA =
      (DIRECTORY = C:\temp\client)
    )
  )

tnsnames.ora:

PRODONESSL =
(DESCRIPTION_LIST =
  (FAILOVER = true)
  (LOAD_BALANCE = false)
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCPS)(HOST = YourFirstHost)(PORT = 2484))
    )
    (CONNECT_DATA =
      (SERVER = dedicated)
        (FAILOVER_MODE = 
           (BACKUP = PRODTWOSSL)
           (TYPE = select)
           (METHOD = basic)
           (RETRIES = 20)
           (DELAY = 3)
        )
      (SERVICE_NAME = ORCL)
    )
    (SECURITY =
      (SSL_SERVER_CERT_DN = "CN=client, C=US")
    )
  )
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCPS)(HOST = YourSecondHost)(PORT = 2484))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = ORCL)
    )
    (SECURITY =
      (SSL_SERVER_CERT_DN = "CN=client, C=US")
    )
  )
)

PRODTWOSSL =
(DESCRIPTION_LIST =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCPS)(HOST = YourSecondHost)(PORT = 2484))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = ORCL)
    )
    (SECURITY =
      (SSL_SERVER_CERT_DN = "CN=client, C=US")
    )
  )
)

For more information about configuring SSL for the JDBC OCI driver, see the "Stores for Client Authentication" subsection of Configuring the SSL connection.