JDBC drivers for Oracle are provided by the database vendors. If the JDBC driver for your database is not already installed, obtain the appropriate driver from the Web site of the vendor and then set the CLASSPATH environment variable.
Obtaining the latest Oracle driver for JDK 1.6
Select one of these links to the Oracle Database 11g drivers. For the JDBC driver for Oracle
Select the ojdbc5.jar classes for use with JDK 1.5.
Setting the CLASSPATH environment variable
Install the JDBC driver on the host machine on which Mirror Replication Agent resides or where Mirror Replication Agent can access it.
Add the location of the JDBC driver to the CLASSPATH environment variable.
For UNIX:
Add the following to the .login file of the user account that is used to start and stop the Mirror Replication Agent instance:
setenv CLASSPATH /path_name/driver:$CLASSPATH
where:
path_name is the name of the path where you installed the JDBC driver.
driver is the name of the JDBC driver. (For Oracle, it is ojdbc5.jar)
You must log out and log back in for this change to take effect, or issue the command source .login after the change.
For Microsoft Windows:
Go to 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, the name is ojdbc5.jar
Click Apply, then OK.
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.
