JDBC drivers for Oracle databases are provided by Oracle.
If the JDBC driver for your database is not already installed, obtain the appropriate driver from the Oracle Web sitehttp://technet.oracle.com/software/tech/java/sqlj_jdbc/content.html.
To obtain the latest Oracle 10.2 driver for JDK
1.4
Select the link to the Oracle Database 10g Release 2 drivers.
Select the ojdbc14.jar classes for use with JDK 1.4 and JDK 1.5.
To set the CLASSPATH environment variable
Install the JDBC driver on the 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 this line 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.
You must log out and log back in for this change to take effect, or issue the command source .login after the change.
For Windows:
Go to Start | Settings | Control Panel |System | Environment, and add this line to the existing CLASSPATH environment variable, using the semicolon (;) as the path separator, or create the path in the User Variables window:
drive:\path_name\driver
where:
drive is the drive letter.
path_name is the name of the path where you installed the Oracle JDBC driver.
driver is the name of the JDBC driver. For Oracle, the name is ojdbc14.jar.
Click Apply, then OK.
The Oracle primary server must be running the Transparent Network Substrate (TNS) Listener Service. For more information about TNS, see the Oracle Database Net Services Administrator’s Guide.
