Determine and record the values of the Replication Agent configuration parameters for the primary data server.
Completing Section 5 of the Installation and Setup
worksheet
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.”
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 data server, ASM connection, ASM username, 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 username 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 “Installation and Setup worksheet.”
The asm_tns_filename is
required only if the pds_tns_filename does
not already have the ASM connection information.
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.”
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.”
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.”
If your primary database server is DB2 Universal Database, identify the data source name (DSN) configured in the ODBC driver or the catalogued database alias for the primary database. The value of the data source name parameter (pds_datasource_name) must be the DB2 database alias that identifies the primary database.
Record the appropriate value for the data source 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.”
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 for more information.
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.”
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 J2SE 5.0 on the Java internationalization pagehttp://java.sun.com/javase/technologies/core/basic/intl/.
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.”
For Microsoft SQL Server. Identify the dedicated administration port number (pds_dac_port_number). For more information, 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.”
