Oracle Instant Client

This section describes how to set up Oracle Instant Client and Oracle Data Provider for .NET for use with Transaction Insight, Foresight Archive and Retrieval System, and Foresight Operational Monitor.

If you are using an Oracle database, you will need the Oracle Instant Client driver on all machines that access the Oracle database. This does not include machines used by those who simply log in to the portal. Any servers hosting the web portal (using IIS and .NET) will also require the Oracle Data Provider for .NET (ODP.NET).

Note: Oracle Instant Client specifies additional OS requirements for IBM AIX platforms. Review the information at https://docs.oracle.com/database/121/AXCLI/pre_install.htm#AXCLI1281 before proceeding with the installation.

 Oracle Instant Client Compatibility

Transaction Insight requires Oracle Instant Client 19c, where 19 is the "major database release number". Transaction Insight is NOT compatible with any other "major" release of Oracle Instant Client. You should, however, use the latest available version that begins with 19.

At this writing, the latest available version of the 19c Oracle Instant Client is 19.6.0.0.0. The following information and examples use this version but apply to any release that begins with 19.

 Download Oracle Instant Client

There are two available packages of the Oracle Instant Client: Basic and Basic Lite. The Basic Lite package is smaller but includes only English error messages and Unicode, ASCII, and Western European character set support. Either package is supported but we recommend the Basic Lite package.

Note: When you obtain third-party software or services, it is your responsibility to ensure you understand the license terms associated with such third-party software or services and comply with such terms.

Download the appropriate package for your operating system from https://www.oracle.com/database/technologies/instant-client/downloads.html:

Platform

Package

Microsoft Windows (x64)

instantclient-basiclite-windows.x64-19.6.0.0.0dbru.zip

AIX5L (64-bit)

instantclient-basiclite-aix.ppc64-19.6.0.0.0dbru.zip

RHEL 8 x86-64

instantclient-basiclite-linux.x64-19.6.0.0.0dbru.zip

The package contains a single directory named "instantclient_19_6". Extract this package into a location of your choice. We will use "C:\oracle" on Windows and "/home/oracle" on Linux-like platforms in our examples.

 Install and Configure Oracle Instant Client

Once the package is extracted, it needs to be referenced in one or more environment variables and some files need to be copied to directories within the Transaction Insight home.

WINDOWS

This section assumes that Oracle Instant Client package has been extracted into the "C:\oracle" directory, the TIBCO products have been installed into "C:\tibco\<product dir>" and that Payara (GlassFish) has been installed into "C:\payara5". Follow the steps below to configure the Oracle Instant Client for use with Transaction Insight.

  • Update PATH
    Add "C:\oracle\instantclient_19_6" to the system PATH. If you have any other version of the Oracle Client in your PATH, remove it. There should only be one version of the Oracle Client in your system PATH.

  • Copy JDBC files
    Copy the file "ojdbc8.jar" from the Instant Client directory into the following locations based on which products are installed.

Product

Location

Foresight Archive and Retrieval System

C:\tibco\Archiver\version\Java\lib

C:\payara5\glassfish\lib\endorsed

Foresight Operational Monitor

C:\tibco\OperationalMonitor\version\java\lib

Transaction Insight

C:\tibco\TransactionInsight\version\environment\java\lib

If using JBoss EAP, run the following commands from JbossHome/Bin/ :

jboss-cli -c --controller=localhost:9990 --command="module add --name=com.oracle --resources=[path to ojdbc8.jar] --dependencies=javax.api,javax.transaction.api" --user=[username] --password=[password]
jboss-cli -c --controller=localhost:9990 --command="/subsystem=ee:list-add(name=global-modules,value={name=com.oracle})" --user=[username] --password=[password]
LINUX

This section assumes that the Oracle Instant Client package has been extracted into the "/home/oracle" directory, the TIBCO products have been installed into "/home/tibco/<product dir>" and that Payara (GlassFish) has been installed into "/home/payara5". Follow the steps below to configure the Oracle Instant Client for use with Transaction Insight.

Copy JDBC files
Copy the file "ojdbc8.jar" from the Instant Client directory into the following locations based on which products are installed.

Product

Location

Foresight Archive and Retrieval System

/home/tibco/Archiver/version/Java/lib

/home/payara5/lib/endorsed

Foresight Operational Monitor

/home/tibco/OperationalMonitor/version/Java/lib

Transaction Insight

/home/tibco/TransactionInsight/version/java/lib

If using JBoss EAP, run the following commands from JbossHome/Bin/ :

jboss-cli -c --controller=localhost:9990 --command="module add --name=com.oracle --resources=[path to ojdbc8.jar] --dependencies=javax.api,javax.transaction.api" --user=[username] --password=[password]
jboss-cli -c --controller=localhost:9990 --command="/subsystem=ee:list-add(name=global-modules,value={name=com.oracle})" --user=[username] --password=[password]

Oracle Data Provider for .NET

Oracle Data Provider for .NET (ODP.NET) is required when connecting to an Oracle database for both

  • TI Portal

  • Back end components such as Importer and TIUtilities.

Like the Oracle Instant Client, TI Portal supports the latest version of ODP.NET. At this writing, the latest available version of the ODP.NET driver is 19.3. The following information and examples use this version but apply to any release that is more recent than 12.1

At this writing, the latest available version of the 12.1 ODP.NET driver is 12.1.0.2.1. The following information and examples use this version but apply to any release that begins with 12.1.

 Download Oracle Data Provider for .NET

There are several different packages of the Oracle Data Provider for .NET. For simplicity we recommend the 64-bit ODAC xcopy version which is named ODAC193Xcopy_x64.zip http://download.oracle.com/otn/other/ole-oo4o/ODAC193Xcopy_x64.zip

  • Download the package.

  • Extract this package into a temporary location of your choice.

 Install Oracle Data Provider for .NET

Within the extracted files, locate odp.net4\odp.net\managed\common\Oracle.ManagedDataAccess.dll.

Copy the dll to the following directories: 

<Environments>\<env name>\bin, such as:
C:\tibco\TransactionInsight\version\Environments\env name\bin
<Environments>\<env name>\TIWeb\bin, such as:
C:\tibco\TransactionInsight\version\Environments\env name\TIWeb\bin