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.
If the Replication Server version is 15.2 or later and you have already created a connection using the Replication Server create connection command with the using profile clause, your RSSD objects have already been loaded by the connection profile, and you can skip these instructions.If your Replication Server is version 15.0 or earlier, correctly define the Oracle error class in both Replication Server and the RSSD:
At Replication Server, execute the $SYBASE/RAX-15_2/scripts/oracle/oracle_create_error_class_1_rs.sql script.
At the RSSD database, execute the $SYBASE/RAX-15_2/scripts/oracle/oracle_create_error_class_2_rssd.sql script.
At Replication Server, execute the $SYBASE/RAX-15_2/scripts/oracle/oracle_create_error_class_3_rs.sql script.