Installing the JDBC drivers varies depending on whether you use the OCI driver or the Thin driver. Let’s start with the OCI driver installation.

Installing the OCI Driver

To install the OCI driver software, follow these steps:

  1. Install the Oracle client software from its distribution CD.

  2. Add the appropriate file to your CLASSPATH environment variable.

  3. If you are using Java 2 Enterprise Edition (J2EE), add the appropriate file to your J2EE_CLASSPATH environment variable.

  4. Add the client binaries to your PATH environment variable.

  5. On Unix or Linux, add the client binaries to the LD_LIBRARY_PATH environment variable.

Install the Oracle Client

If you are going to use the OCI driver, you’ll need the Oracle8i Oracle Client distribution media or the Oracle Enterprise Edition distribution media (typically, these are on CD-ROM) to install the client software. Follow your operating-system-specific instructions to execute the Oracle Universal Installer. Then simply follow the installation instructions from the Oracle Universal Installer’s screen.

The Oracle Universal Installer creates several directories during the installation of the client software on your computer. The directories of interest to you are all under ORACLE_HOME\jdbc. ORACLE_HOME refers to the directory where the Oracle client software was installed. Typically, these directories are:


Contains Oracle’s sample programs, demonstrating the use of SQL92 and Oracle SQL syntax, PL/SQL ...

Get Java Programming with Oracle JDBC now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.