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:
Install the Oracle client software from its distribution CD.
Add the appropriate
classesXXX.zipfile to your CLASSPATH environment variable.
If you are using Java 2 Enterprise Edition (J2EE), add the appropriate
classesXXX.zipfile to your J2EE_CLASSPATH environment variable.
Add the client binaries to your PATH environment variable.
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 refers to the directory where the
Oracle client software was installed. Typically, these
Contains Oracle’s sample programs, demonstrating the use of SQL92 and Oracle SQL syntax, PL/SQL ...