Configuring Replication Server for Oracle replication

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

Applying heterogeneous datatype support (HDS) scripts to RSSD

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

Set the environment variables.
- Windows – navigate to the %SYBASE% directory of your Replication Server installation and set the environment variables by executing SYBASE.bat.
- UNIX and Linux – navigate to the $SYBASE directory and set the environment variables by sourcing SYBASE.csh.
Change to this directory:
- Windows – %SYBASE%\REP-15_0\scripts
- UNIX and Linux – $SYBASE/REP-15_0/scripts

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.

Change to this directory:
- Windows – %SYBASE%\RAX-15_0\scripts
- UNIX and Linux – $SYBASE/RAX-15_0/scripts

Load the following 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

Shut down Replication Server:

isql –Usa –P –SSAMPLE_RS
shutdown
go

Navigate to this directory:
- Windows – %SYBASE%\REP-15_0\samp_repserver
- UNIX and Linux – $SYBASE/REP-15_0/samp_repserver
Run the RUN_SAMPLE_RS.bat file on Windows, and the RUN_SAMPLE_RS script on UNIX and Linux, to start the SAMPLE_RS Replication Server.