My Oracle Support Banner

What Is Required In Order To Use Oracle "Thick" Driver (OCI) With ODI? (Doc ID 602706.1)

Last updated on AUGUST 27, 2019

Applies to:

Oracle Data Integrator - Version 3.2.03.01 and later
Information in this document applies to any platform.

Goal

Can Oracle Data Integrator (ODI) use the Oracle Thick driver (OCI connection type) without any additional installation than the JDBC driver file (ojdbc14.jar, ojdbc5.jar, ojdbc6.jar, ojdbc7.jar... according to the Java version)?

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
 The version of the JDBC driver must match the version of the Oracle Home.
 The precise jar file (and its name) is dependent on the JVM used - and the internal version must be compatible with the Oracle database version.
 You must place the ORACLE_HOME directory in which the client-side file for the required native libraries resides, in your PATH environment variable.
 To use the "Thick" driver (OCI), from a Java point of view, you will need to specify the directory containing the shared library for the native calls.
 To use the "Thick" driver on a 64-bit Operating System
 Finally, set the URLs to the Oracle Data Server(s) to use the "Thick" flavor of JDBC driver.
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.