Verifying the Oracle User Roles Created by the Replication Agent

Validate the required Oracle settings.

1. Use SQLPLUS to run this command as the new Oracle user:

   select GRANTED_ROLE from USER_ROLE_PRIVS;
   GRANTED_ROLE
   --------------------
   CONNECT
   RESOURCE
   SELECT_CATALOG_ROLE

   The user who starts the Replication Agent instance must also have read access to the Oracle redo log files and the Oracle archive directory that contains the archive log files to be accessed for replication. If the Replication Agent is configured to remove old archive files, the user must have update authority to the directory and the archive log files.
2. Add the JDBC driver to the CLASSPATH environment variable. For example, you can append the existing CLASSPATH to the new JDBC driver and add this command to the .login script of a UNIX and Linux user:

   setenv CLASSPATH /path_name/driver.jar:$CLASSPATH

   where driver.jar is your JDBC driver (ojdbc14.jar, ojdbc5.jar, ojdbc6.jar, or ojdbc7.jar).

   For Windows, add this to the CLASSPATH environment variable:

   set CLASSPATH=path_name\jdbc\lib\driver.jar;%CLASSPATH%

   where driver.jar is your JDBC driver (ojdbc14.jar, ojdbc5.jar, ojdbc6.jar, or ojdbc7.jar).