Replication Server and RSSD scripts

Replication Server requires changes to the RSSD to support Oracle datatypes. To implement these changes, execute the following 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

The Mirror Replication Agent installation has supplemental script changes to support additional Replication Server user-defined datatypes for new Oracle datatypes and replication of DDL commands.

The following revised Replication Server scripts are shipped with Mirror Replication Agent 15.1 and must be applied in addition to the aforementioned scripts when the installed Replication Server is version 15.0.1 or earlier:

• $SYBASE/MA-15_1/scripts/oracle/hds_oracle_new_udds.sql

• $SYBASE/MA-15_1/scripts/oracle/ hds_oracle_new_setup_for_replicate.sql

• $SYBASE/MA-15_1/scripts/oracle/oracle_create_error_class_1_rs.sql

• $SYBASE/MA-15_1/scripts/oracle/ oracle_create_error_class_2_rssd.sql

• $SYBASE/MA-15_1/scripts/oracle/oracle_create_error_class_3_rs.sql

1. Execute the following existing Replication Server script against your Replication Server System Database (RSSD) database:

   $SYBASE/REP-15_1/scripts/hds_oracle_udds.sql

2. If your Replication Server is version 15.0.1 or earlier, also apply the script from the Mirror Replication Agent 15.1 installation to your RSSD:

   $SYBASE/MA-15_1/scripts/oracle/hds_oracle_new_udds.sql

3. If your Replication Server is version 15.0.1 or earlier, apply the following script to support replication of DDL to an Oracle standby database:

   $SYBASE/MA-15_1/scripts/oracle/hds_oracle_new_setup_replicate.sql

   This script is used to define Replication Server objects that must be created in the standby database. Use this script instead of the hds_oracle_setup_replicate.sql script provided in the Replication Server installation directory. This revised script contains additional changes to support Oracle-to-Oracle DDL replication.

4. At your RSSD database, apply the script that defines the custom function strings used by Replication Server to communicate with an Oracle standby database:

   $SYBASE/REP-15_1/scripts/hds_oracle_funcstrings.sql

5. At your RSSD database, apply the scripts that define the class-level translations for the Oracle datatypes:

   • $SYBASE/REP-15_1/scripts/hds_clt_ase_to_oracle.sql

     $SYBASE/REP-15_1/scripts/hds_clt_oracle_to_ase.sql

6. To correctly define the Oracle error class for Replication Server 15.0.1 or an earlier version, use three scripts:

   • Apply the following script at Replication Server:

     $SYBASE/MA-15_1/scripts/oracle/ oracle_create_error_class_1_rs.sql

   • Apply the following against your RSSD:

     $SYBASE/MA-15_1/scripts/oracle/ oracle_create_error_class_2_rssd.sql

   • Apply the following script at Replication Server:

     $SYBASE/MA-15_1/scripts/oracle/ oracle_create_error_class_3_rs.sql

For more information, see Chapter 4, "Database Server Issues,” in the Replication Server Heterogeneous Replication Guide.