Creating a Replication Server connection
Navigate to the $SYBASE/RAX-15_2/scripts/oracle (UNIX or Linux) or %SYBASE%\RAX-15_2\scripts\oracle (Windows) directory.
Make a copy of the oracle_create_rs152_standby_connection.sql script named 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:
rds is the DirectConnect server name.
rdb is any valid identifier. Sybase recommends that you use the Oracle SID name.
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 to maintuser
set password to "password"
go
In the above example, password is
a RepServer reserved word and therefore, must be enclosed in double
quotes.
Create the connection to the replicate 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 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.
