Troubleshooting guide
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.
Creating the Replication Agent Instance
A single installation of the Replication Agent can support replication from multiple databases,
however, one Replication Agent instance is needed for each Oracle database that is to be
replicated.
Prepare and create a Replication Agent instance for each Oracle database being replicated.
1.
Obtain the Oracle JDBC driver from Oracle, and update the CLASSPATH environment
variable.
To find the JDBC connection that communicates with the primary Oracle instance, locate
the JDBC driver that was available when the Oracle release was originally created.
• For Oracle 10g:
$ORACLE_HOME/jdbc/lib/ojdbc14.jar
• For Oracle 11g Release 1:
$ORACLE_HOME/jdbc/lib/ojdbc5.jar
• For Oracle 11g Release 2:
$ORACLE_HOME/jdbc/lib/ojdbc6.jar
Replication Agent may require a newer version of the JDBC driver, which can be found at
http://www.oracle.com/technetwork/indexes/downloads/index.html
.
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, or
ojdbc6.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, or
ojdbc6.jar).
3.
Record the location of the tnsnames.ora file, and record the connection name from
that file for the Replication Agent to use to connect to the Oracle primary database. You
can find these values from any machine from which you can use an Oracle SQLPLUS
session to connect to the desired Oracle instance. The ORACLE_SID is from the
environment variable, $ORACLE_SID.
CHAPTER 4: Oracle-to-SAP HANA Database Replication Setup
38 Replication Server