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

Item

Description

Example value

Your value

5a

pds_interfaces_file

NoteThis value is for ASE only.

A valid ASE interfaces file that contains the connection properties to the primary ASE data server.

  • On UNIX: $SYBASE /ASE-15_0 /interfaces

  • On Microsoft Windows: %SYBASE%\ini\sql.ini

5b

pds_server_name

NoteThis value is for ASE only.

The ASE connection name that identifies the primary database connection in the ASE pds_interfaces_file.

If you are configuring an ASE cluster, use the cluster server name.

ase_server

5c

pds_tns_filename

NoteThis value is for Oracle only.

The fully-qualified file name identifying the Oracle tnsnames.ora file that contains connection properties for the primary Oracle data server.

/path1/tnsnames.ora

5d

pds_tns_connection

NoteThis value is for Oracle only.

The Oracle connection name that identifies the primary database connection in the Oracle tnsnames.ora file

SALES_DB

5e

asm_tns_filename

NoteThis value is for Oracle only.

Identifies the Oracle tnsnames.ora filename where the ASM connection information is located. If this is the same tnsnames.ora file as configured in pds_tns_filename, you can leave this parameter unset.

NoteSet this parameter only if the redo logs of your primary Oracle are under Automatic Storage Management.

/path2/tnsnames.ora

5f

asm_tns_connection

NoteThis value is for Oracle only.

Identifies the Oracle ASM connection name found in the tnsnames.ora file.

NoteSet this parameter only if the redo logs of your primary Oracle are under Automatic Storage Management.

+ASM1

5g

asm_username

NoteThis value is for Oracle only.

Identifies the Oracle user name to be used when connecting to the ASM server.

NoteSet this parameter only if the redo logs of your primary Oracle are under Automatic Storage Management.

sys as sysdba

5h

asm_password

NoteThis value is for Oracle only.

Password for Oracle ASM access for the user specified in asm_username.

NoteSet this parameter only if the redo logs of your primary Oracle are under Automatic Storage Management.

change_on_install

5i

pds_database_name

This is the name of the primary database on the primary database server.

Mirror Replication Agent uses this value to determine which database is the primary database.

NoteFor Oracle, use the $ORACLE_SID.

sales_db

5j

pds_username

This is the user ID that Mirror Replication Agent uses to log in to the primary database.

pds_user

5k

pds_password

This is the password for pds_username.

pds_pw

5l

RA_JAVA_DFLT_CHARSET

This is the Java-equivalent of the primary database character set.

NoteUnless you want to override the default character set that the JVM finds on your system, you do not need to explicitly set the character set-related environment variable, RA_JAVA_DFLT_CHARSET. However, the system default character set must match the character set of the primary database.

  • On UNIX: ISO8859_1

  • On Windows: Cp850