Replication Server requires changes to the RSSD to support Oracle datatypes. To implement these changes, execute the following 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_0/scripts/hds_oracle_udds.sql
$SYBASE/REP-15_0/scripts/hds_oracle_funcstrings.sql
$SYBASE/REP-15_0/scripts/hds_clt_ase_to_oracle.sql
$SYBASE/REP-15_0/scripts/hds_clt_oracle_to_ase.sql
The 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 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/RAX-15_1/scripts/oracle/hds_oracle_new_udds.sql
$SYBASE/RAX-15_1/scripts/oracle/ hds_oracle_new_setup_for_replicate.sql
$SYBASE/RAX-15_1/scripts/oracle/oracle_create_error_class_1_rs.sql
$SYBASE/RAX-15_1/scripts/oracle/ oracle_create_error_class_2_rssd.sql
$SYBASE/RAX-15_1/scripts/oracle/oracle_create_error_class_3_rs.sql
To apply the script changes for user-defined datatypes
Execute the following existing Replication Server script against your Replication Server System Database (RSSD) database:
$SYBASE/REP-15_0/scripts/hds_oracle_udds.sql
If your Replication Server is version 15.0.1 or earlier, also apply the script from the Replication Agent 15.1 installation to your RSSD:
$SYBASE/RAX-15_1/scripts/oracle/hds_oracle_new_udds.sql
If your Replication Server is version 15.0.1 or earlier, apply the following script to support replication of DDL to an Oracle replicate database:
$SYBASE/RAX-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 replicate database. Use this script instead of the hds_oracle_setup_replicate.sql script provided in the Replication Server install directory. This revised script contains additional changes to support Oracle-to-Oracle DDL replication.
At your RSSD database, apply the script that defines the custom function strings used by Replication Server to communicate with an Oracle replicate database:
$SYBASE/REP-15_0/scripts/hds_oracle_funcstrings.sql
At your RSSD database, apply the scripts that define the class-level translations for the Oracle datatypes:
$SYBASE/REP-15_0/scripts/hds_clt_ase_to_oracle.sql
$SYBASE/REP-15_0/scripts/hds_clt_oracle_to_ase.sql
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/RAX-15_1/scripts/oracle/ oracle_create_error_class_1_rs.sql
Apply the following against your RSSD:
$SYBASE/RAX-15_1/scripts/oracle/ oracle_create_error_class_2_rssd.sql
Apply the following script at Replication Server:
$SYBASE/RAX-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.
