Step 1. Configure Rep Server for Oracle replication

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

To apply Heterogeneous Datatype support (HDS) scripts to RSSD

1. Open a command window in the $SYBASE directory of your Rep 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” is displayed. You can ignore this message.

5. Change directories to the $SYBASE/MRO-12_6/scripts directory.

6. Load the 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. Shutdown Rep Server:

   isql –Usa –P –SSAMPLE_RSshutdown
   go
   

   A message indicating that Rep Server is shutdown.

8. Go to $SYBASE/REP-12_6/samp_repserver directory.

9. Run the startup script:

   ./RUN_SAMPLE_RS
   

---

Copyright © 2006. Sybase Inc. All rights reserved.

View this book as PDF