Configuring Replication Server for Replication to the Target Data Server

Create a Replication Server connection to the replicate data server.

1. Navigate to the $SYBASE/RAX-15_5/scripts/oracle (UNIX or Linux) or %SYBASE%\RAX-15_5\scripts\oracle (Windows) directory.
2. Make a copy of the oracle_create_rs_standby_connection.sql script named my_oracle_create_rs_standby_connection.sql.
3. Before executing the my_oracle_create_rs_standby_connection.sql script against your Replication Server, change all occurrences of {rds}.{rdb} to the name of the connection that Replication Server uses to connect to ExpressConnect for Oracle where:

   • rds is the replicate Oracle System ID (SID) name.

   • rdb is any valid identifier. SAP recommends that you use the replicate Oracle SID name.

   • maintuser and password are the user name and password created in ExpressConnect for Oracle.

   For example:

   create connection to OracleSID_name.OracleSID_name
   using profile rs_oracle_to_oracle;eco
   set username maintuser
   set password "password"
   go

   Note: In the previous example, password is a Replication Server reserved word and therefore, must be enclosed in double quotes.
   If you are using an ExpressConnect for Oracle connection profile, dsi_proc_as_rpc is enabled by default.
4. For configuring the server connectivity for ExpressConnect for Oracle, copy the tnsnames.ora file to the \RS_installation_directory\REP-15_5\connector\oraoci\network\admin directory.
5. Create the connection to the replicate database:
   

   isql –Usa -Psa_pass –SSAMPLE_RS -i my_oracle_create_rs_standby_connection.sql

6. Log in to SAMPLE_RS, and verify the Replication Server connection to the standby database:

   isql –Usa –Psa-pass –SSAMPLE_RS
   admin who
   go

   You should see a message returned for the DSI connection {rds}.{rdb}. Verify that the status is “Awaiting Message” or “Awaiting Command.”

7. Exit the isql session with the quit command.