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. 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 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. If your primary database type is Microsoft SQL Server, identify the port number of the client socket port for the primary data server. Port numbers have a range of 1 to 65,535.
   

   Record the client socket port number as item 5g (pds_port_number) Section 5: Replication Agent Parameter Values for the Primary Data Server on the Installation and Setup Worksheet.

4. If your primary database type is Microsoft SQL Server, identify the name of the primary database server.
   

   Record the primary database server name as item 5h (pds_server_name) in Section 5: Replication Agent Parameter Values for the Primary Data Server on the Installation and Setup Worksheet.

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

6. If your primary database server is DB2 Universal Database, identify the datasource name (DSN) configured in the ODBC driver or the catalogued database alias for the primary database. The value of the datasource name parameter (pds_datasource_name) must be the DB2 database alias that identifies the primary database.
   

   Record the appropriate value for the datasource name (DSN) as item 5j (pds_datasource_name) in Section 5: Replication Agent Parameter Values for the Primary Data Server on the Installation and Setup Worksheet.

7. 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 Primary Database Guide.

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

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

9. (Microsoft SQL Server) Identify the dedicated administration port number (pds_dac_port_number). See the Replication Agent Primary Database Guide.

   Record the DAC port number as item 5n in Section 5: Replication Agent Parameter Values for the Primary Data Server on the Installation and Setup Worksheet.