JDBC drivers for Oracle databases are provided by the database vendor. If the JDBC driver for your database is not already installed, obtain the appropriate driver from the database vendor or the vendor’s Web site:
http://technet.oracle.com/software/tech/java/sqlj_jdbc/content.html
To set up a JDBC driver for Oracle data servers
Install the JDBC driver on the machine on which Mirror Replication Agent resides or where Mirror Replication Agent can access it.
See the release notes for the exact version
of the JDBC driver to use.
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/ojdbc14.jar:$CLASSPATH
where path_name is the path where you installed the Oracle 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.
On Windows 2000 or 2003, 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 panel:
drive:\path_name\ojdbc14.jar
where:
drive is the drive letter.
path_name is the name of the path where you installed the Oracle JDBC driver.
Click Apply, then OK.
Verify that the Oracle primary server is running the Transparent Network Substrate (TNS) Listener Service. See the Oracle networking document for more information about TNS.
