Troubleshooting guide

CHAPTER 4
Oracle-to-SAP HANA Database
Replication Setup
Implement a sample replication system for replication from Oracle to SAP HANA database.
Use the tasks in this document to set up a proof-of-concept or test replication system. Only
basic Oracle features are addressed in the example scenario. In particular, Oracle Automatic
Storage Management (ASM) and Real Application Clusters (RAC) are not addressed in this
guide, although Replication Agent does support these features. See the Replication Agent
Primary Database Guide
These tasks use the sample Replication Server instance SAMPLE_RS. If you have already
installed Replication Server, skip to the configuration procedures.
The replication of sequences is not discussed in this document. To set up sequence replication,
see the Replication Agent Installation Guide and the Replication Agent Primary Database
Guide .
For the most current information on Replication Server and its components, see the
Replication Server Release Bulletin .
System Architecture
There are multiple components required to implement an Oracle-to-SAP HANA Database
replication system.
• A primary Oracle data server
• A replicate SAP HANA database
• A Replication Server (with ExpressConnect for HANA DB)
• The Replication Server Options components:
• Replication Agent for Oracle
Figure 2: Sybase Replication System for an Oracle Primary and SAP HANA
Database Replicate
Quick Start Guide for SAP HANA Database 23