Section 5: Mirror Replication Agent parameter values for the primary data server

Determine and record the values of the Mirror Replication Agent configuration parameters for the primary data server.

StepsCompleting Section 5 of the Installation and Setup worksheet

  1. If your primary database type is ASE, identify the ASE interfaces file that contains the connection properties for the primary data server.

    Record the ASE interfaces file name as item 5a (pds_interfaces_file) and record the connection name as item 5b (pds_server_name) in Section 5: Mirror Replication Agent parameter values for the primary data server on the “Installation and Setup worksheet.”

  2. If your primary database type is Oracle, identify the tnsnames.ora file name that contains the connection property to the primary database and connection name for the primary data server.

    Record the tnsnames.ora file name as item 5c (pds_tns_filename) and record the connection name as item 5d (pds_tns_connection) in Section 5: Mirror Replication Agent parameter values for the primary data server on the “Installation and Setup worksheet.”

  3. If you are using Oracle Automatic Storage Management (ASM), identify the tnsnames.ora file name that contains the connection property for the ASM database. If it is the same tnsnames.ora file as configured in pds_tns_filename, you may leave asm_tns_filename not set. Also identify the name of the ASM connection, ASM username, and ASM password.

    Record the tnsnames.ora file name as item 5e (asm_tns_filename), the ASM connection name as item 5f (asm_tns_connection), the ASM username as item 5g (asm_username), and the ASM password as item 5h (asm_password) in Section 5: Mirror Replication Agent parameter values for the primary data server on “Installation and Setup worksheet.”

    NoteThe asm_tns_filename is required only if the pds_tns_filename does not already have the ASM connection information.

  4. Identify the name of the primary database on the primary data server.

    The value of the pds_database_name parameter can be identical to the value of rs_source_db (worksheet item 2b), as long as the value of the pds_database_name parameter exists as a valid database at the primary database server.

    If your primary database server is Oracle, you must use the value of the ORACLE_SID system environment variable (%ORACLE_SID% on Microsoft Windows, or $ORACLE_SID on UNIX).

    Record the database name as item 5i (pds_database_name) in Section 5: Mirror Replication Agent parameter values for the primary data server on the “Installation and Setup worksheet.”

  5. Identify the user ID and password that Mirror Replication Agent uses to log in to the primary data server.

    NoteThis user ID cannot be the same as the Replication Server maintenance ID for the primary database connection.

    This primary data server user ID must have several database-level privileges for the primary database. For more information, see the Mirror Replication Agent Primary Database Guide.

    Record this primary data server user ID as item 5j (pds_username) and the password as item 5k (pds_password) in Section 5: Mirror Replication Agent parameter values for the primary data server on the “Installation and Setup worksheet.”

  6. Identify the character set of the primary database and determine the Java-equivalent character set.

    For a list of valid Java character sets, see Character Encodings for Java SE 6 on the Java internationalization pagehttp://java.sun.com/javase/technologies/core/basic/intl/.

    Record the name of the equivalent Java character set as item 5l in Section 5: Mirror Replication Agent parameter values for the primary data server on the “Installation and Setup worksheet.”