Troubleshooting guide

CHAPTER 4: Oracle-to-SAP HANA Database
Replication Setup......................................................23
System Architecture ............................................................23
Prerequisites ........................................................................24
Planning Your Installation ...................................................24
System Requirements ..................................................24
Identify the Sybase Installation Directory .....................25
Replication Agent Installation Directory ...............25
Accessing and Downloading Products from SMP........25
Installing Replication Components ....................................26
Installing Replication Server .........................................26
Installing Replication Agent ..........................................29
Verifying the Installation .......................................31
Configuring Replication Components ..............................32
Configuring Replication Server .....................................32
Obtaining the SAP HANA Database ODBC
Drivers .............................................................32
Configuring Replication Server for Replication to
SAP HANA Database ......................................32
Configuring Replication Server for Replication
from the Primary Database .............................34
Configuring Replication Agent .....................................35
Primary Oracle Database Configuration for
Replication .......................................................35
Creating the Replication Agent Instance .............38
Verifying the Replication Agent Instance
Installation .......................................................43
Creating a Replication Server Connection to the
Primary Database ...........................................44
Initializing the Replication Agent Instance ...........45
Testing Replication ..............................................................47
Resetting the Primary Oracle Database for
Replication ................................................................48
Contents
iv Replication Server