Chapter 3: Installing Sybase Replication Agent

Informix and Oracle JDBC drivers

JDBC drivers for Informix and Oracle databases are provided by the database vendors. 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:

For Informix:

http://www.ibm.com/software/data/informix/tools/jdbc/

For Oracle:

http://technet.oracle.com/software/tech/java/sqlj_jdbc/content.html

To set up a JDBC driver for Informix or Oracle data servers

Install the JDBC driver on the machine on which Sybase Replication Agent resides or where Sybase Replication Agent can access it.
Add the location of the JDBC driver to the CLASSPATH environment variable.
- For Oracle:
  
  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.
- For Informix:
  
  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/ifxjdbc.jar:$CLASSPATH
```
  where path_name is the name of the path where you installed the Informix 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 your existing CLASSPATH environment variable, using the semicolon (;) as the path separator, or create the path in the User Variables panel:
```
drive:\path_name\ifxjdbc.jar
```
  where:
  - drive is the drive letter.
  - path_name is the path to the directory where you installed the Informix JDBC driver.
  Click Apply, then OK.
On Oracle, the Oracle primary server must be running the Transparent Network Substrate (TNS) Listener Service. See the Oracle networking document for more information about TNS.

View this book as PDF