Configure Replication Server for replication to standby

This section describes how to configure Replication Server for replication to standby.

To create a Replication Server connection to standby

Go to the $SYBASE/MA-15_0/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_rs.sql script is executed in the RSSD.

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


isql -U SAMPLE_RS_RSSD_prim -P SAMPLE_RS_RSSD_prim_ps 
–SSAMPLE_RS_ERSSD –i oracle_create_error_class_2_rssd.sql 
-DSAMPLE_RS_ERSSD


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

Make a copy of the oracle_create_rs_standby_connection.sql directory:

cp oracle_create_rs_standby_connection.sql myma_oracle_create_rs_standby_connection.sql

Before executing the myma_oracle_create_rs_standby_connection.sql script against your Replication Server, change occurrences of value {rds}.{rdb} to the name of the connection that Replication Server will use to connect to DirectConnect for Oracle, where:

rds is the DCO 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 DirectConnect for Oracle, in step 1 of configuring ECDA.
maintuser and password are the user name and password created in DCO.

Here is an example:

create connection to DCOServer.oratest2set error class oracle_error_classset function string class rs_oracle_function_classset username maintuserset password “password”set batch to "off"go

In the previous example, “password” is a Replication Server reserved word, and it must be enclosed in double quotes.

Create the connection to the standby database:

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

The connection to the standby database is created.

To verify the Replication Server connection to the standby database, log in to SAMPLE_RS and verify the Replication Server connection to the standby database:

isql –Usa –P –SSAMPLE_RSadmin whogo

You should see a message returned for the DSI connection {rds}.{rdb}. Verify that the status is “Awaiting Message” or “Awaiting Command.”

Exit isql.