Setting Up the Oracle JDBC Driver

The JDBC driver for Oracle is provided by the database vendor. If the JDBC driver for your database is not already installed, obtain the appropriate driver from the vendor Web site.

1. Install the JDBC driver on the host machine on which Replication Agent resides.
   
2. Add the location of the JDBC driver to the CLASSPATH environment variable.

   • On UNIX:

     Add the following to the .login file of the user account that is used to start and stop the Replication Agent instance:

     setenv CLASSPATH /path_name/driver:$CLASSPATH

     where:

     • path_name is where you installed the JDBC driver.

     • driver is the name of the JDBC driver.

     Log out and log back in for this change to take effect, or issue source .login after the change.

   • On Microsoft Windows:

     Select Start > Settings > Control Panel > System > Environment, and add the following to the existing CLASSPATH environment variable, using the semicolon (;) as the path separator, or create the path in the User Variables pane:

     drive:\path_name\driver

     where:

     • drive is the drive letter.

     • path_name is where you installed the JDBC driver.

     • driver is the name of the JDBC driver:

       • For Oracle versions 11g Release 1 and earlier, the name is ojdbc5.jar. For Oracle version 11g Release 2, the name is ojdbc6.jar.

     Click Apply > OK.

3. On the Oracle host machine, the Oracle primary server must be running the Transparent Network Substrate (TNS) Listener Service. See the Oracle networking document for more information about TNS.