Configuring Replication Server for Oracle replication

This section describes the configuration tasks for configuring Replication Server for Oracle.

Prepare the Replication Server RSSD for replication to an Oracle database. To apply HDS support scripts to RSSD:

1. Set the environment variables by sourcing SYBASE.csh file.

2. Change to the $SYBASE/REP-15_1/scripts directory:

3. Load the following scripts into the RSSD:

   isql -U SAMPLE_RS_RSSD_prim -P SAMPLE_RS_RSSD_prim_ps –SSAMPLE_RS_ERSSD
   –ihds_clt_ase_to_oracle.sql -DSAMPLE_RS_ERSSDisql -U SAMPLE_RS_RSSD_prim -P SAMPLE_RS_RSSD_prim_ps –SSAMPLE_RS_ERSSD
   –ihds_oracle_udds.sql -DSAMPLE_RS_ERSSDisql -U SAMPLE_RS_RSSD_prim -P SAMPLE_RS_RSSD_prim_ps –SSAMPLE_RS_ERSSD
   –ihds_oracle_funcstrings.sql -DSAMPLE_RS_ERSSD
   

   The message “ASA -157 cannot convert to a timestamp” is displayed. You can ignore this message.

4. Go to the $SYBASE/MA-15_1/scripts/oracle directory.

5. Load this script into the RSSD:

   isql -U SAMPLE_RS_RSSD_prim 
   -P SAMPLE_RS_RSSD_prim_ps -SSAMPLE_RS_ERSSD
   -ihds_oracle_new_udds.sql -DSAMPLE_RS_ERSSD
   

6. Shut down Replication Server:

   isql –Usa –P –SSAMPLE_RS
   shutdown
   go
   

7. Navigate to the $SYBASE/REP-15_1/samp_repserver directory:

8. Run the RUN_SAMPLE_RS script, to start the SAMPLE_RS Replication Server.