Upgrading the JDBC Driver on Oracle 11g R2

If you are using Oracle 11g R2 you must ensure that your Oracle JDBC driver meets the minimum version requirement of 11.2.0.4.0.

If you are using Oracle 12c ignore this section and see Upgrading the JDBC Driver on Oracle 12c instead.

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 log file on system startup: 
    16 Apr 2014 11:03:27,276 [Job_Executor4] [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 the version is not 11.2.0.4.0, you must upgrade it.

Procedure

  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.