Troubleshooting guide
where:
•
rds
is the replicate SAP HANA database. For a standard connection, this must match
the data server name in the interfaces file entry. See the
Adaptive Server Enterprise
Configuration Guide for UNIX > Set Up Communications Across the Network >
Contents of the interfaces File
and the
Adaptive Server Enterprise Configuration Guide
for Windows > Network Communications Using sql.ini
. For an SAP Secure User Store
connection, this must match what you used as the key to create a user store of encrypted
credentials with the hdbuserstore utility.
•
rdb
is placeholder: You must provide a value, but it is not used..
•
muser
is the maintenance user for the replicate SAP HANA database instance that you
created in the previous step.
•
mpwd
is the replicate SAP HANA database maintenance user password.
•
auser
and
apwd
are unused values supplied only to satisfy the syntax of the create
connection command.
Note: For an SAP Secure User Store connection, the same user who ran the hdbuserstore
utility must run the create connection command.
If you have trouble connecting to the replicate SAP HANA database instance using
ExpressConnect for HANA DB, see the
Replication Server Troubleshooting Guide >
Common Error Messages > Connector Error Messages
.
7.
Use admin show_connections, 'replicate' to display the replicate connection you created.
Configuring Replication Server for Replication from the Primary Database
Configure Replication Server for replication from the primary database.
Granting create object Permission to the rs_username User
Grant create object permission to the user ID specified by the Replication Agent rs_username
parameter.
The rs_username user,which is used for communication between Replication Agent and
Replication Server, must have create object permission before it can be used to create a
replication definition. You must grant this permission manually from Replication Server.
1.
Log in to Replication Server:
isql -Usa -Psa_pass -SSAMPLE_RS
If you have not set up the sample Replication Server instance, enter your Replication
Server instance name in place of SAMPLE_RS.
2.
Enter:
grant create object to SAMPLE_RS_ra
go
where
SAMPLE_RS_ra
is the value for the rs_username parameter you entered in the
resource file.
CHAPTER 4: Oracle-to-SAP HANA Database Replication Setup
34 Replication Server