Creating a Replication Server Connection to the Primary Database

Create a Replication Server connection to the primary database.

Go to the $SYBASE/RAX-15_5/scripts/oracle (UNIX or Linux) or %SYBASE%\RAX-15_5\scripts\oracle directory (Windows).

Make a copy of the oracle_create_rs_primary_connection.sql script.

cp oracle_create_rs_primary_connection.sql
my_oracle_create_rs_primary_connection.sql

Before executing the my_oracle_create_rs_primary_connection.sql script against your Replication Server, change all occurrences of {pds}.{pdb} to the name of the Replication Server connection used for the connection from Replication Agent for Oracle, where:
- pds is the name of the primary Oracle server.
- pdb is the primary Oracle System ID (SID).
For example, NY.NYora92.

Note:
Save these values to be used later for the rs_source_ds and rs_source_db parameters in the Replication Agent oracle.rs file.
Change sys and sys_pwd to the user ID and password of the Oracle user who must have permission to apply DML operations against all user tables to be replicated, where:
- sys is the user ID of the Oracle user (sys).
- sys_pwd is the password of the Oracle user (change_on_install).
Note:
This user must be a valid user in the Oracle database, and it must be different from the user defined by the Replication Agent pds_username parameter, which is used for Replication Agent connections to the primary database.

This example creates a Replication Server connection to the primary database:
```
create connection to NY.NYora92
```
```
set error class rs_sqlserver_error_class
```
```
set function string class rs_oracle_function_class
```
```
set username sys
```
```
set password change_on_install
```
```
with log transfer on, dsi_suspended
```
```
go
```
Execute the script in Replication Server:
```
isql –Usa –P –SSAMPLE_RS -i 
<script_path>\my_oracle_create_rs_primary_connection.sql
```
where <script_path> is the full path to my_oracle_create_rs_primary_connection.sql.
You see a message indicating that the Replication Server connection to the primary database has been created.