Description:
The ActiveMatrix BPM Installation and Configuration guide does not list Oracle JDBC driver version 11.2.0.4.0 (ojdbc6.jar) as a suitable driver for use with Oracle 12c. This is incorrect. When using Oracle 12c to host the ActiveMatrix BPM and/or ActiveMatrix Administrator databases,
you can use either the version 12.1.0.1.0 (ojdbc7.jar) or version 11.2.0.4.0 (ojdbc6.jar) JDBC driver.

If you have upgraded your ActiveMatrix BPM system to version 4.x and also upgraded your database from Oracle 11g to Oracle 12c, you
must ensure you are using a compatible Oracle JDBC driver - either version 12.1.0.1.0 (ojdbc7.jar) or version 11.2.0.4.0 (ojdbc6.jar).
The following sections explain how to do this.


Upgrading the Oracle 11g JDBC Driver to Version 11.2.0.4.0
==========================================================

If you want to use the Oracle 11g driver, you can determine if you have the correct version (11.2.0.4.0) by doing either of the following:

* Look for the following entry in the BPMNode.log file on system startup:
 
  [INFO ] org.hibernate.cfg.SettingsFactory -JDBC driver:Oracle JDBC driver, version: 11.2.0.4.0
 
* In the <TIBCO_HOME>/components/shared/1.0.0/plugins/com.tibco.tpcl.gen.oracle.jdbc_11.2.100.001 folder, open the ojdbc6.jar file.
Examine the META-INF/MANIFEST.MF file and look for the following entry:

  Implementation-Version: 11.2.0.4.0
 
If your ojdbc6.jar driver version is not 11.2.0.4.0:

1. Obtain the 11.2.0.4.0 version of the ojdbc6.jar file from Oracle.

2. Stop the TIBCO Host instance.
 
3. On each machine in the ActiveMatrix BPM system, replace the existing ojdbc6.jar file with the 11.2.0.4.0 version in both of the following
directories:

   - <TIBCO_HOME>/components/shared/1.0.0/plugins/com.tibco.tpcl.gen.oracle.jdbc_11.2.100.001
   
   - <CONFIG_HOME>/tibcohost/Admin-<ActiveMatrixEnterpriseName>-<ActiveMatrixServerName>/data_3.2.x/host/plugins/com.tibco.tpcl.gen.oracle.jdbc_11.2.100.001

4. Start the TIBCO Host instance.
   

Upgrading the Oracle JDBC Driver from Oracle 11g to Oracle 12c
==============================================================

If you want to upgrade the Oracle JDBC driver to the Oracle 12c version (12.1.0.1.0):

1. Stop the TIBCO Host instance.

2. In TIBCO Configuration Tool, run the Configure Third-Party Driver Wizard to configure the
"TIBCO-enabled JDBC driver for Oracle 12.1.0.1.0" JDBC driver with the ojdbc7.jar driver file.

3. Start the TIBCO Host instance.
 
5. In ActiveMatrix Administrator:
   
   a) Select Infrastructure > Environment and select BPMEnvironment.
   
   b) Select Infrastructure > Nodes and select BPMNode.

   c) On the Configuration tab, in the "Features" section, find the "TIBCO enabled JDBC driver for Oracle" entry. In the "Version" dropdown
for this entry, the following versions are listed:

      - 11.2.100.001 (version number for the original Oracle 11g driver)
      - 12.1.100.001 (version number for the new Oracle 12c driver)

   d) Select the new version 12.1.100.001.
   
   e) Click Save.
   
   f) Click "Apply with Resolve". The driver's status changes to "Marked for Uninstall" and the BPMNode is restarted automatically.
   
   g) Wait for the BPMNode and all deployed applications to start, then check that Version 12.1.100.001 of the driver is selected, and that its Status is "Installed".

   h) Repeat steps a) to g) for the SystemNode. (Select the "SystemEnvironment" in step a) so that the node is visible in step b).)

6. Look for the following entry in the BPMNode.log and SystemNode.log files:

      [INFO ] org.hibernate.cfg.SettingsFactory -JDBC driver: Oracle JDBC driver, version: 12.1.0.1.0

   This entry indicates that the Oracle 12c driver has been successfully enabled.

When using Oracle 12c to host the ActiveMatrix BPM and/or ActiveMatrix Administrator databases, you can use either the Version 12.1.0.1.0 (ojdbc7.jar) or Version 11.2.0.4.0 (ojdbc6.jar) JDBC driver. The ActiveMatrix BPM Installation and Configuration guide for ActiveMatrix BPM version 4.0 does not list Oracle JDBC driver version 11.2.0.4.0 (ojdbc6.jar) as a suitable driver for use with Oracle 12c. This is incorrect. This LBN describes how to check and, if necessary, upgrade your Oracle JDBC driver version.

Product: TIBCO ActiveMatrix BPM Version: 4.0 OS: All Supported Operating Systems