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 ECO where:

   • rds is the replicate Oracle SID name.

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

   • maintuser and password are the user name and password created in ECO.

   For example:

   create connection to OracleSID_name.OracleSID_name

   using profile rs_oracle_to_oracle;eco

   set username to maintuser

   set password to "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 not using an Oracle ECO connection profile, set dsi_proc_as_rpc to ‘on’ in the create connection command. For example:

   create connection to OracleSID_name.OracleSID_name 
   set error class <error_class> 
   set function string class <function_class> 
   set username <userid>
   set password <password>
   set dsi_dataserver_make to 'ora'
   set dsi_dataserver_type to 'oci'
   set batch to 'off'
   set dsi_proc_as_rpc to 'on'

   If you are using an Oracle ECO connection profile, dsi_proc_as_rpc is enabled by default.
4. For configuring the server connectivity for ECO, 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 –P –SSAMPLE_RS -i 
   my_oracle_create_rs_standby_connection.sql

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

   isql –Usa –P –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.