Troubleshooting guide
Record the ORACLE_SID value for the instance you want to connect to.
4.
(Optional) If your operating system has a Java 6.0.x-compatible JRE or JDK installed, you
can use the Oracle iSQL (the browser-based interface to SQL*PLUS) demo items to
connect to Oracle using the JDBC driver and to verify the connection information.
See
Verification of a JDBC Client Installation
in the
Oracle Database JDBC Developer's
Guide and Reference Guide
.
5.
Obtain a local copy of the Oracle timezone file, so Replication Agent can correctly
process the Oracle timestamp with timezone datatype.
Note: This step is required only if the Replication Agent is on a machine (host) other than
the Oracle host and does not have access to the Oracle timezone file.
There are two timezone files in the $ORACLE_HOME/oracore/zoneinfo (UNIX
or Linux) or %ORACLE_HOME%\oracore\zoneinfo (Windows) directory:
• The timezone*.dat binary file is the default file that contains the most commonly
used time zones.
• The timezlrg*.dat binary file contains a larger set of defined time zones.
The Oracle instance uses the timezone file from the ORA_TZFILE environment
variable. If ORA_TZFILE is not set, use the default timezone file.
Determine which timezone file is used by the primary Oracle instance and make a copy
of that file available on the machine hosting the Replication Agent.
Note: These files are Oracle version- and platform-dependent. You cannot use a
timezone file from a little-endian platform on a big-endian platform, nor can you use a
timezone file from a version of Oracle that is different than the version of the primary
Oracle.
6.
Locate the Replication Agent for Oracle resource file template.
The majority of configuration values required to create and initialize a Replication Agent
can be recorded and stored in a resource file. Using a resource file provides a means to
record or retain the configuration information for a Replication Agent instance, allowing
an instance to be removed and re-created.
The resource file template (oracle.rs) is in the Replication Agent directory
$SYBASE/RAX-15_5/init (UNIX or Linux) or %SYBASE%\RAX-15_5\init
(Windows).
7.
Create an instance resource file:
Copy the resource file template $SYBASE/RAX-15_5/init/oracle.rs (UNIX or
Linux) or %SYBASE%\RAX-15_5\init\oracle.rs (Windows) to another file that
contains the configuration information for a new instance, for example, myra.rs.
Change the values assigned to properties in the resource file so they match the values
required for your environment. The majority of these values are the location, user, and
CHAPTER 4: Oracle-to-SAP HANA Database Replication Setup
Quick Start Guide for SAP HANA Database 39