Obtain and Install the Driver for Oracle OCI Client

Use the instructions in this section to set up the connections between an Oracle data source and TDV, and between TDV and a client interface.

For Oracle versions 11g and 12c

These instructions are for the 11g and 12c versions of Oracle. TDV uses the Oracle 11g R2 Type 2 client to connect to Oracle Type 2 data sources. If possible, use the Oracle 11g driver to connect to all Oracle versions.

Note: If you expect to use XML types in your TDV environment, download and install the Oracle OCI Type 2 driver. The Oracle Thin driver does not support schema-based XML documents.

Instructions for installing and configuring Oracle drivers are provided for both Windows and UNIX.

To configure an Oracle OCI type 2 JDBC adapter for TDV (on Windows)

Install an Oracle client instance on the machine where TDV server is running.

You can download the appropriate Oracle client for your platform from this URL:

http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html

The Oracle client instance must have Oracle net services components for the OCI adapter. Oracle administrator and runtime clients contain net services components by default. Use a 32-bit or 64-bit Oracle client, as appropriate for the TDV installation. See Oracle documentation about how to set up an Oracle client.

The Oracle client instance contains a Java driver (ojdbc6.jar) and a native library (ocijdbc11.dll or ocijdbc12.dll).

Set up TNS names.

TNS names are created in Oracle Net Configuration Assistant. These TNS names contain information about how to connect to a physical Oracle database. See Oracle documentation for details on how to set up TNS names.

Copy the Java driver ojdbc6.jar file to:

<TDV_install_dir>\apps\dlm\cis_ds_oracle_type2\lib

Copy the native library ocijdbc11.dll file to:

<TDV_install_dir>\jdk\bin

Set up environment variables on the machine that hosts TDV Server.

—

Set the ORACLE_HOME environment variable to something like: <ORACLE_INSTALLATION>\product\11.2.0\client_1.

—

Add ORACLE_HOME\bin to system PATH.

—

Set the CLASSPATH environment variable to use Oracle JDBC adapter from ORACLE_HOME\jdbc\lib.

If you expect to use XML types in your TDV environment:

Obtain xdb6.jar from the Oracle website. For example:

http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html.

Copy xdb6.jar to <TDV_install_dir>\apps\server\lib.

Obtain xmlparserv2.jar from the Oracle website. For example:

http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html

Download the Oracle Database 11g Release 2 Client (11.2.0.1.0) for Microsoft Windows (x64), choose "Runtime" during installation. The final installation has the jar file under <INSTALL_DIR>/product/11.2.0/client_1/lib.

Copy xmlparserv2.jar to <TDV_install_dir>\apps\server\lib.

Stop and restart TDV Server.

You can now add Oracle data sources that use the OCI adapter.

To configure an Oracle OCI Type 2 JDBC adapter for TDV (on UNIX)

Export the path for OCI libraries.

Install an Oracle client instance on the machine where TDV Server is running. You can download the appropriate Oracle client for your platform from this URL:

http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html

The Oracle client instance contains a Java driver (ojdbc6.jar) and native library files for specific platforms:

Oracle Version	Platform	File Name
11g	Linux/AIX/UNIX	libocijdbc11.so
12c	Linux/UNIX	libocijdbc12.so

10.

Set up TNS names.

11.

Copy the Java driver ojdbc6.jar file to:

<TDV_install_dir>/apps/dlm/cis_ds_oracle_type2/lib

12.

Set up environment variables on the machine that hosts TDV Server.

—

Set the ORACLE_HOME environment variable to something like <ORACLE_INSTALLATION>/product/11.2.0/client_1. It is recommended that you set your environment variables in a system init script rather than use the EXPORT command.

—

Add ORACLE_HOME/lib to the library path environment variable for your platform:

—

Linux: LD_LIBRARY_PATH

—

AIX: LIBPATH

—

Set the CLASSPATH environment variable to use Oracle JDBC adapter from ORACLE_HOME/jdbc/lib.

13.

If you expect to use XML types in your TDV environment:

Obtain xdb6.jar from the Oracle website. For example:

http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html

Copy xdb6.jar to <TDV_install_dir>\apps\server\lib.

Obtain xmlparserv2.jar from the Oracle website. For example:

http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html

Download the Oracle Database 11g Release 2 Client (11.2.0.1.0) for Microsoft Windows (x64), choose “Runtime” during installation. The final installation has the JAR file under <INSTALL_DIR>/product/11.2.0/client_1/lib.

Copy xmlparserv2.jar to <TDV_install_dir>\apps\server\lib.

14.

Stop and restart the TDV Server.

You can now add Oracle data sources that use the OCI adapter.

For Oracle version 19c

These instructions are for the 19c versions of Oracle.

Instructions for installing and configuring Oracle drivers are provided for both Windows and UNIX.

To configure an Oracle OCI type 2 JDBC adapter for TDV (on Windows)

15.

Download the following files for configuring the Oracle 19c OCI environments:

—

https://download.oracle.com/otn_software/nt/instantclient/19500/instantclient-basic-windows.x64-19.5.0.0.0dbru.zip

—

https://download.oracle.com/otn_software/nt/instantclient/19500/instantclient-sqlplus-windows.x64-19.5.0.0.0dbru.zip

—

https://download.oracle.com/otn_software/nt/instantclient/19500/instantclient-tools-windows.x64-19.5.0.0.0dbru.zip

—

https://download.oracle.com/otn_software/nt/instantclient/19500/instantclient-sdk-windows.x64-19.5.0.0.0dbru.zip

The Oracle client instance contains a Java driver (ojdbc10.jar and xdb.jar) and the following native libraries:

—

oci.dll

—

ocijdbc19.dll

—

ociw32.dll

—

oramysql19.dll

—

orannzsbb19.dll

—

oraocci19.dll

—

oraocci19d.dll

—

oraociei19.dll

—

oraons.dll

—

orasql19.dll

—

orasqlplusic19.dll

Copy the Java driver files (ojdbc10.jar and xdb.jar) to:

<TDV_install_dir>\apps\dlm\cis_ds_oracle_type2\lib

Copy the native library files to:

<TDV_install_dir>\jdk\bin

16.

Set up TNS names.

17.

Set up environment variables on the machine that hosts TDV Server.

Set the ORACLE_HOME environment variable to:

<ORACLE_INSTALLATION>\instantclient_19_5

Add ORACLE_HOME to system PATH.

Set the CLASSPATH environment variable to use Oracle JDBC adapter from ORACLE_HOME

18.

Stop and restart TDV Server.

You can now add Oracle data sources that use the OCI adapter.

To configure an Oracle OCI type 2 JDBC adapter for TDV (on Unix)

19.

Download the following files for configuring the Oracle 19c OCI environments:

—

https://www.oracle.com/database/technologies/oracle19c-linux-downloads.html

The Oracle client instance contains Java drivers (ojdbc10.jar and xdb.jar) and the following native libraries:

—

libipc1.so

—

libmql1.so

—

libnnz19.so

—

libocci.so

—

libociei.so

—

libocijdbc19.so

—

liboramysql19.so

—

libsqlplusic.so

—

libsqlplus.so

Copy the Java driver files (ojdbc10.jar and xdb.jar) to:

<TDV_install_dir>/apps/dlm/cis_ds_oracle_type2/lib

Copy the native library files to:

<TDV_install_dir>/apps/server/lib/svn/lin64

20.

Set up TNS names.

21.

Set the following environment variables in the .bash_profile and make it available:

export ora_home=<ORACLE_INSTALLATION>

export PATH=$PATH:$ora_home/instantclient_19_5

export ORACLE_BASE=$ora_home

export ORACLE_HOME=$ORACLE_BASE/instantclient_19_5

export LD_LIBRARY_PATH=$ORACLE_HOME

export NLS_LANG=<LANGUAGE>

export TNS_ADMIN=$ORACLE_HOME/network/admin

export CLASSPATH=$ORACLE_HOME

22.

Stop and restart TDV Server.

You can now add Oracle data sources that use the OCI adapter.