This section describes the configuration requirements for each component.
Configure the primary database as follows:
Add the Replication Agent user login name to the primary database, and grant the user appropriate permission to be able to perform tasks necessary to support replication.
Add the Maintenance User login name (as specified in the Replication Server create connection command) to the primary database.
For Oracle: Enable supplemental logging, and disable the recycle bin.
For Microsoft SQL Server: Initialize the data server. Also, configure the database to allow a remote TCP/IP connection and to allow a remote DAC connection.
Configure the Replication Agent instance as follows:
Make sure that the connection configuration is set correctly for network communications with the primary database, Replication Server, and RSSD.
Use the pdb_xlog init command to initialize Replication Agent. This command validates that the primary database is prepared for replication, sets up Replication Agent system objects in the primary database, and initializes the RASD (Oracle and Microsoft SQL Server only).
Configure the Replication Server as follows:
Use the Replication Agent user login name, with connect source and create object permission granted.
Identify or create the Replication Agent user login name for the RSSD.
Define the database Replication Definition and Subscription for the primary and standby database.
Apply the Heterogeneous Datatype Support Scripts at the RSSD.
For Oracle: If Replication Server is version 15.0 or earlier, apply the scripts distributed with Replication Agent to correctly define the Oracle error class. See “RSSD” for details.
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 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
Also, if your Replication Server is version 15.0 or earlier, execute the following Replication Agent script against the RSSD:
$SYBASE/RAX-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/RAX-15_1/scripts/oracle/oracle_create_error_class_1_rs.sql script.
At the RSSD database, execute the $SYBASE/RAX-15_1/scripts/oracle/oracle_create_error_class_2_rssd.sql script.
At Replication Server, execute the $SYBASE/RAX-15_1/scripts/oracle/oracle_create_error_class_3_rs.sql script.
