Troubleshooting guide

Prerequisites
Review the prerequisites before you begin setting up Oracle-to-SAP HANA database
replication.
Make sure:
• You are familiar with Oracle and SAP HANA database.
• You have valid licenses for Replication Server with ExpressConnect for HANA DB and
Replication Server Options.
• Oracle Database 10g or 11g Enterprise Edition is installed and configured to serve as the
source (primary) database from which Replication Agent replicates transactions, and SAP
HANA database is installed and configured as the target (replicate) database to which
Replication Server with ExpressConnect for HANA DB replicates transactions.
• If Oracle 10g or 11g Release 1 is the primary database, install the Oracle JDBC
™
thin
driver for Oracle 10g or 11g and for JDK 1.4 and 1.5. If the primary database is Oracle 11g
Release 2, install the Oracle JDBC thin driver 11.2 for JDK 1.6.
• TCP/IP connectivity is available between all hosts.
• Any operating system patches required for Java have been installed.
• The Replication Agent has direct access to the Oracle online and archived redo logs.
Do not use Replication Server reserved words for object names or connection names. A
complete list of reserved words is in the Replication Server Reference Manual .
Planning Your Installation
Before installing the replication components, verify the system requirements, identify the
Sybase installation directories, and obtain the installation software.
System Requirements
Make sure the target computer on which you are installing the replication components meets
the minimum memory and disk space requirements.
See the Replication Server Installation Guide > Planning Your Installation > System
Requirements and the Replication Agent Installation Guide > Planning Your Installation >
System Requirements .
To improve performance by avoiding multiple network hops, install Replication Server and
the SAP HANA database on the same machine. Replication Agent must have direct access to
the Oracle online and redo logs and must be installed on the same machine as the primary
database.
Note: The only versions of Linux that ExpressConnect for HANA DB supports are Red Hat
Enterprise Linux 6 and SuSE Linux Enterprise Server (SLES) 11.
CHAPTER 4: Oracle-to-SAP HANA Database Replication Setup
24 Replication Server