This section describes the required configurations for Replication Server for replication to the target Oracle data server.
To create a Replication Server connection to replicate
Navigate to the Replication Agent scripts $SYBASE/RAX-15_1/scripts/oracle directory.
Create the Oracle error class.
Execute these three scripts:
The oracle_error_class_1_rs.sql and oracle_error_class_3_rs.sql scripts
are executed to the Replication Server. The oracle_error_class_2_rssd.sql script
is executed in the RSSD.
isql -Usa -P -SSAMPLE_RS -i oracle_create_error_class_1_rs.sqlisql -U SAMPLE_RS_RSSD_prim -P SAMPLE_RS_RSSD_prim_ps -SSAMPLE_RS_ERSSD -i oracle_create_error_class_2_rssd.sql -DSAMPLE_RS_ERSSDisql -Usa -P -SSAMPLE_RS -i oracle_create_error_class_3_rs.sql
Make a copy of the oracle_create_rs_standby_connection.sql script:
cp oracle_create_rs_standby_connection.sql 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 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 set error class oracle_error_class set function string class rs_oracle_function_class set username maintuser set password “password” set batch to “off” 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_rs_standby_connection.sql
To verify the Replication Server connection to the replicate database, 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.
