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
- Install an Oracle client: preferred as Admin/custom installation.
- 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). - Install TIBCO BusinessEvents and add the file
ojdbc7.jar
from the client installation to the folder BE_Home/lib/ext/tpcl. - 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
. - If the installation was performed properly, the studio JDBC test connection should show success.