Determine and record the values of the Mirror Replication Agent configuration parameters for the primary data server.
To complete Section 5 of the Installation and
Setup worksheet
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.”
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.”
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.”
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 5i (pds_port_number) in Section 5: Mirror 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 5j (pds_server_name) in Section 5: Mirror 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 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.
Record the database name as item 5k (pds_database_name) in Section 5: Mirror Replication Agent parameter values for the primary data server on the “Installation and Setup worksheet.”
Identify the user ID and password that Mirror Replication Agent uses to log in to the primary data server.
This user ID must not 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 Mirror Replication Agent Primary Database Guide for more information.
Record this primary data server user ID as item 5l (pds_username) and the password as item 5m (pds_password) in Section 5: Mirror 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 5n in Section 5: Mirror Replication Agent parameter values for the primary data server on the “Installation and Setup worksheet.”
If your primary database is Microsoft SQL Server, identify the dedicated administrative connection port number (pds_dac_port_number). For more information, see the Mirror Replication Agent Primary Database Guide.
Record the DAC port number as item 5o in Section 5: Mirror Replication Agent parameter values for the primary data server on the “Installation and Setup worksheet.”
