Upgrading the JDBC Driver on Oracle 12c

If you upgraded your database from Oracle 11g to Oracle 12c you must ensure that 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).

1. Obtain the 12.1.0.1.0 version of the ojdbc7.jar file from Oracle.
2. Stop the TIBCO Host instance.
3. 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.
4. Start the TIBCO Host instance.
5. In ActiveMatrix Administrator:
   1. Select Infrastructure > Environment and select BPMEnvironment.
   2. Select Infrastructure > Nodes and select BPMNode.
   3. 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
   4. Select the new version 12.1.100.001.
   5. Click Save.
   6. Click Apply with Resolve.
      The driver's status changes to Marked for Uninstall and the BPMNode is restarted automatically.
   7. 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.
   8. 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.