Setting Up Oracle and Microsoft SQL Server JDBC Drivers

JDBC drivers for Oracle and Microsoft SQL Server databases are provided by the database vendors. If the JDBC driver for your database is not already installed, obtain the appropriate driver from the vendor Web site.

For the Oracle JDBC driver, go to the Oracle download page for JDBC drivers. Scroll down to Drivers, and click JDBC Drivers.
For the Microsoft SQL Server JDBC driver, go to Microsoft download page for JDBC drivers.

Install the JDBC driver on the host machine on which Replication Agent resides.
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.
  
  Note: Microsoft SQL Server is not available on UNIX.
- 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.
  
  For Microsoft SQL Server, the name is sqljdbc.jar.
  Click Apply > OK.
Note: Replication Agent for Microsoft SQL Server must be installed on Microsoft Windows.
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.