Troubleshooting guide

password information listed in the tnsname.ora file for the Oracle, Replication Server,
and RSSD connections.
Set the value of rs_source_ds to the value you chose for
pds
when you created a
Replication Server connection from the primary database.
Set the value of rs_source_db to the value you chose for
pdb
when you created a
Replication Server connection from the primary database.
When you create a Replication Agent instance with a resource file:
The asa_password configuration parameter value must not contain single quotes,
double quotes, or a semicolon.
The pds_username and pds_password configuration parameter values must not
contain single or double quotes if the create_pds_username parameter is set to
yes.
The resource file is self-documenting, with each parameter described. See the
Replication
Agent Administration Guide
. For a complete list of configuration parameters, see
the
Replication Agent Reference Manual
.
Warning! The rs_source_ds and the rs_source_db values must match the
{pds.pdb}
values of your Replication Server primary connection name that you configured when you
created a Replication Server connection from the primary database.
Table 2. Resource File Parameters
Parameter Description Example Values
instance name Any valid name. myra
admin_port Port number that Replication Agent uses. 9030 (if in use, select a different
port number)
ltm_admin_user User name for administering the Replication
Agent instance.
sa
ltm_admin_pw Password for the user administering the Rep-
lication Agent instance.
The default password policy is
that the password must be be-
tween 6 and 255 characters. For
example:
sa_pass
pds_host_name Machine (host) where Oracle is installed. jdoe_host1
pds_port_number Port number for Oracle. 1521
pds_database_name $ORACLE_SID NYora92
pds_username User ID that Replication Agent uses to ac-
cess primary data server.
RA_USER
pds_password Password for pds_username. sybase
CHAPTER 4: Oracle-to-SAP HANA Database Replication Setup
40 Replication Server