Configuring Replication Server for replication to the target data server

Creating a Replication Server connection

Navigate to the $SYBASE/RAX-15_5/scripts/oracle (UNIX or Linux) or %SYBASE%\RAX-15_5\scripts\oracle (Windows) directory.
Make a copy of the oracle_create_rs_standby_connection.sql script named my_oracle_create_rs_standby_connection.sql.
Before executing the my_oracle_create_rs_standby_connection.sql script against your Replication Server, change all occurrences of value {rds}.{rdb} to the name of the connection that Replication Server uses to connect to ECO where:
- rds is the Oracle SID name.
- rdb is any valid identifier. Sybase recommends that you use the 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
```
In the previous example, password is a Replication Server reserved word and therefore, must be enclosed in double quotes.

If you are not creating the connection using one of the Replication Server's Oracle ECO connection profiles, 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 one of Replication Server's Oracle ECO connection profiles, dsi_proc_as_rpc is enabled by default.
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.

Create the connection to the replicate database:

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

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.”
Exit the isql session with the quit command.