Completing Section 5: Replication Agent Parameter Values for the Primary Data Server

Determine the values of the Replication Agent configuration parameters for the primary data server, and record them in Section 5 of the worksheet.

1. 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 5a (pds_tns_filename) and record the connection name as item 5b (pds_tns_connection) in Section 5: Replication Agent Parameter Values for the Primary Data Server on the Installation and Setup Worksheet.

2. 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 can leave asm_tns_filename unset. Also identify the name of the ASM data server, ASM connection, ASM user name, and ASM password.

   Record the tnsnames.ora file name as item 5c (asm_tns_filename), the ASM connection name as item 5d (asm_tns_connection), the ASM user name as item 5e (asm_username), and the ASM password as item 5f (asm_password) in Section 5: Replication Agent Parameter Values for the Primary Data Server on the Installation and Setup Worksheet. The asm_tns_filename is required only if the pds_tns_filename does not already have the ASM connection information.

3. 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.

   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 5g (pds_database_name) in Section 5: Replication Agent Parameter Values for the Primary Data Server on the Installation and Setup Worksheet.

4. Identify the user ID and password that Replication Agent uses to log in to the primary data server. This 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. See the Replication Agent for Oracle Primary Database Guide.

   Record this primary data server user ID as item 5h (pds_username) and the password as item 5i (pds_password) in Section 5: Replication Agent Parameter Values for the Primary Data Server on the Installation and Setup Worksheet.

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

   For a list of valid Java 7 character sets, see the Supported Encodings on the internationalization page at http://docs.oracle.com/javase/7/docs/technotes/guides/intl/encoding.doc.html.

   Record the name of the equivalent Java character set as item 5j in Section 5: Replication Agent Parameter Values for the Primary Data Server on the Installation and Setup Worksheet.