Configure Replication Server for Oracle replication

This section describes the required configurations for Replication Server for Oracle.

To apply Heterogeneous Datatype support (HDS) scripts to RSSD

1. Open a command window in the $SYBASE directory of your Replication Server installation.

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

3. Change directories to the $SYBASE/$SYBASE_REP/scripts directory.

4. 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_ERSSD
   

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

   isql -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” appears. You can ignore this message.

5. Go to the $SYBASE/MA-15_0/scripts/oracle directory.

6. 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
   

7. Shut down Replication Server:

   isql –Usa –P –SSAMPLE_RSshutdown
   go
   

   A message appears indicating that Replication Server is shut down.

8. Go to the $SYBASE/$SYBASE_REP/samp_repserver directory.

9. Run the start-up script:

   ./RUN_SAMPLE_RS &
   

---

Copyright © 2007. Sybase Inc. All rights reserved.

View this document as PDF