Troubleshooting guide

Note: These verification steps are optional because they were performed when you
verified the resource file.
3.
Verify the Replication Agent connection to Replication Server:
a) Enter:
test_connection RS
go
b) This result is returned:
Type Connection
---- ----------
RS succeeded
(1 row affected)
c) If the result indicates a failure, either the server is not responding or the connection
properties ( host , port , user , or password ) are incorrect. Verify the host and port
configuration values, and manually log in to the Replication Server as the configured
user to determine which property is incorrectly defined.
See the Replication Agent Administration Guide .
4.
Verify the Replication Agent connection to the primary database:
a) Enter:
test_connection PDS
go
You see:
Type Connection
---- ----------
PDS succeeded
(1 row affected)
b) If the result indicates a failure:
• The server is not responding, or
• One of the connection properties is incorrect.
Check the tnsnames.ora file and tnsnames configuration values, and manually
log in to the primary Oracle database as the configured user to find which property is
incorrectly defined.
See "Testing network connectivity" in the Replication Agent Administration Guide .
See also
•
Initializing the Replication Agent Instance on page 45
Creating a Replication Server Connection to the Primary Database
Create a Replication Server connection to the primary database.
1.
In Replication Server, create a connection to the primary Oracle database:
create connection to pds.pdb
using profile rs_rs_to_oracle_ra;standard
CHAPTER 4: Oracle-to-SAP HANA Database Replication Setup
44 Replication Server