Observe these requirements when configuring Replication Agent.
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.
(Oracle only): Enable supplemental logging.
Make sure that the connection configuration is set correctly for network communications with the primary database, Replication Server, and RSSD.
(Microsoft SQL Server) Initialize each primary database server. Also, configure the database to allow a remote TCP/IP connection and to allow a remote DAC connection.
Use the ra_admin 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).
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.
(Oracle) If Replication Server is version 15.0 or earlier, apply the scripts distributed with Replication Agent to correctly define the Oracle error class.
At Replication Server, execute the $SYBASE/RAX-15_5/scripts/oracle/oracle_create_error_class_1_rs.sql script.
At the RSSD database, execute the $SYBASE/RAX-15_5/scripts/oracle/oracle_create_error_class_2_rssd.sql script.
At Replication Server, execute the $SYBASE/RAX-15_5/scripts/oracle/oracle_create_error_class_3_rs.sql script.
To avoid DDL synchronization errors with multiple Replication Agents, use the all, marked, and unmarked keywords with the pdb_setrepddl command.
See the Replication Agent Reference Manual and Replication Agent Primary Database Guide for details about these parameters and command keywords.