Configuring the BPM Engine to use the Oracle OCI Driver

You must configure the BPM Engine to use the OCI driver instead of the default thin driver. This is configured in the Environment Explorer in the integration server properties sheet.

To configure the engine to use the Oracle OCI driver

1. In the Environment Explorer, right-click the integration or application server, and then click Properties.

2. Click BPM Engine Configuration.

3. On the Properties dialog box, enter the service name in the Oracle Net Service Name field.

   The value to enter is the TNS name configured in the tnsnames.ora file (located at <oracle_home>/network/admin). The following example shows a typical TNS name configuration where ORCL.STC.COM is the Oracle Net Service Name.

   ORCL.STC.COM = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = MyHost)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = orcl) )

4. Fill in the properties.

5. Click OK.

   The following table describes the fields you must configure in the BPM Engine Configuration properties.

   Field	Description
   Persistence Mode	An indicator of whether persistence is enabled. Select one of the Persist to Database options to enable persistence in BPM.
   Database	The database platform in use. Select the correct version of Oracle to enable the OCI feature.
   Database Host	The name of the computer on which the Oracle database resides.
   Database Port	The port on which the Oracle database is listening. The default is 1521.
   Oracle Net Service Name	The TNS name of the database (from the tnsnames.ora). The BPM Engine uses the OCI driver if this property is populated. Otherwise, the BPM Engine uses the default DataDirect driver.
   Database Instance/Schema	The name of the database.
   Database User	The user name to access the monitoring and recovery tables.
   Password	The Password to access the monitoring and recovery tables.