Troubleshooting guide

set username muser
set password mpwd
with log transfer on, dsi_suspended
go
where:
• pds is the value of the rs_source_ds parameter specified in Replication Agent.
•
pdb is the value of rs_source_db specified in Replication Agent.
• muser is the maintenance user for the primary Oracle database. This user must already
exist and have the necessary select permissions in the primary database. See the
Replication Server Options Primary Database Guide .
•
mpwd is the maintenance user password.
For information about the maintenance user, see the Replication Server Heterogeneous
Replication Guide > Sybase Replication Products > Replication Server > Database
Connections > Maintenance User Purpose .
2.
Use admin show_connections, 'primary' to display the primary connection you created.
Initializing the Replication Agent Instance
Initialize the Replication Agent instance.
Note: If you set initialize_instance to yes in your resource file, and if you received no errors
while the instance was created, skip to step 2.
1.
The ra_admin init command verifies that the primary Oracle database is correctly
configured to provide archived logging and supplemental logging, and that the Oracle user
ID used by the Replication Agent has the necessary permissions. In addition to creating
objects in the database to support stored procedure replication, the ra_admin init
command also initializes the Replication Agent System Database (RASD) by reading
schema information, and redo log location information from the primary Oracle database.
To initialize the Replication Agent instance, run:
ra_admin init
go
2.
Enter:
resume
go
If the Replication Agent successfully transfers to a replicating state, you see:
State Action
----------------- --------------------------
REPLICATING Ready to replicate data.
The Replication Agent goes to the REPLICATION DOWN state if an error occurs:
isql –Usa –Psa_pass –SSAMPLE_RS
1> resume
2> go
Msg 32000, Level 20, State 0:
Server 'myra', Procedure 'resume', Line 1:
CHAPTER 4: Oracle-to-SAP HANA Database Replication Setup
Quick Start Guide for SAP HANA Database 45