Replication Server requires changes to the RSSD to support Oracle datatypes. To implement these changes, execute the following Replication Server scripts against the RSSD database.
In each script, you must set the “use RSSD” statement
to point to the correct RSSD for your Replication Server.
$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
If your Replication Server is version 15.1 or earlier, execute the following Mirror Replication Agent script against the RSSD:
$SYBASE/MA-15_1/scripts/hds_oracle_new_udds.sql
To define the Oracle error class in both Replication
Server and the RSSD
At the 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 the Replication Server, execute the $SYBASE/MA-15_1/scripts/oracle/oracle_create_error_class_3_rs.sql script.