Configuring Replication Server for replication to the target database

Creating a Replication Server connection

Navigate to the $SYBASE/MA-15_2/scripts/oracle directory.

Make a copy of the oracle_create_rs152_standby_connection.sql script:

cp oracle_create_rs152_standby_connection.sql
my_oracle_create_rs152_standby_connection.sql

Before executing the my_oracle_create_rs152_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 DirectConnect server, where:
- rs_maint_user and rs_maint_user_pwd are the maintenance user and password created in ECDA Option for Oracle, in step 2 of “Configuring ECDA Option for Oracle”.
- maintuser and password are the user name and password created in ECDA Option for Oracle.
For example:
```
create connection to DCOServer.oratest2
```
```
using profile rs_oracle_to_oracle;standard
```
```
set username maintuser
```
```
set password "password"
```
```
set batch to "off"
```
```
go
```
In the above example, password is a word reserved by Replication Server, and it therefore must be enclosed in double quotes.

Create the connection to the standby database:

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

Log in to SAMPLE_RS and verify the Replication Server connection to the standby 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.