Replication Server requires changes to the RSSD to support Oracle datatypes.
In each script, you must modify the “use RSSD” statement,
replacing “RSSD” with the actual database name
that is the correct RSSD for your Replication Server.
To set up Replication Server changes in the RSSD, execute the following Replication Server scripts against the RSSD database:
$SYBASE/REP-15_1/scripts/hds_oracle_udds.sql
$SYBASE/REP-15_1/scripts/hds_oracle_funcstrings.sql
$SYBASE/REP-15_1/scripts/hds_clt_ase_to_oracle.sql
$SYBASE/REP-15_1/scripts/hds_clt_oracle_to_ase.sql
Also, if your Replication Server is version 15.1 or earlier, execute the following Mirror Activator script against the RSSD:
$SYBASE/MA-15_1/scripts/hds_oracle_new_udds.sql
To correctly define the Oracle error class in both Replication Server and the RSSD, do the following:
At Replication Server, execute the $SYBASE/MA-15_1/scripts/oracle/oracle_create_error_class_1_rs.sql script.
At the RSSD database, execute the $SYBASE/MA-15_1/scripts/oracle/oracle_create_error_class_2_rssd.sql script.
At Replication Server, execute the $SYBASE/MA-15_1/scripts/oracle/oracle_create_error_class_3_rs.sql script.
