This section describes the required configurations for Replication Server for replication to the target Oracle database.
To create a Replication Server connection to replicate
Navigate to the Mirror Replication Agent scripts $SYBASE/MA-15_1/scripts/oracle directory.
Create the Oracle error class with the following 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 -ioracle_create_error_class_1_rs.sqlisql -U SAMPLE_RS_RSSD_prim -P SAMPLE_RS_RSSD_prim_ps -SSAMPLE_RS_ERSSD -ioracle_create_error_class_2_rssd.sql -DSAMPLE_RS_ERSSDisql -Usa -P -SSAMPLE_RS -ioracle_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 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_rs_standby_connection.sql
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_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.
