Installing an OCI Driver - OCI Driver Support

This procedure installs an OCI driver for the Oracle database.

Instructions assume you are working with a local database for testing purposes. Adapt the instructions if you are working with a remote database.
    Procedure
  1. Install an Oracle client: preferred as Admin/custom installation.
  2. Admin/Custom installation will create the file tnsnames.ora.

    Configuration while creating the file tnsnames.ora should match the database server configuration (database server is running on a remote machine).

  3. Install TIBCO BusinessEvents and add the file ojdbc7.jar from the client installation to the folder BE_Home/lib/ext/tpcl.
  4. The connect URL used in the TIBCO BusinessEvents is jdbc:oracle:oci:@DBServerHostName:1521:DBInstance.

    This URL can be found in the file tnsnames.ora.

  5. If the installation was performed properly, the studio JDBC test connection should show success.