Section 7: Replication Server parameter values for the standby data server

Determine and record the values of the parameters for the standby data server. These values are used in the materialization step.

StepsTo complete Section 7 of the Installation and Setup worksheet

  1. Identify the DirectConnect service name. The value should be the name of the Oracle instance connect string in item 6a.

    Record the host machine name as item 7a (standby host name) on the worksheet in “Section 7: Replication Server parameter values for the standby data server”.

  2. Identify the name of the standby database on the standby data server. Usually, it is the Oracle SID.

    Record the database name as item 7b (standby database name) on the worksheet in “Section 7: Replication Server parameter values for the standby data server”.

  3. Identify the standby database client user ID and password that Replication Server uses to log in to the standby database to apply DDL commands.

    This user ID must have authority in the standby database to create any schema or issue any DDL command standby from the primary database.

    The Mirror Replication Agent sends this ID and password to Replication Server together with any DDL command executed at the primary database.

    NoteThe value for the ddl_username must not be the same as the value of the maintenance user defined in Replication Server for the standby connection.

    Record the name as item 7c (ddl_username) and the password as item 7d (ddl_password) on the worksheet in “Section 7: Replication Server parameter values for the standby data server”.