Item |
Description |
Example value |
Your value |
---|---|---|---|
5a |
pds_tns_filename This 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 |
|
5b |
pds_tns_connection This value is for Oracle only. The Oracle connection name that identifies the primary database connection in the Oracle tnsnames.ora file |
SALES_DB_CONN |
|
5c |
asm_tns_filename This 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. Set this parameter only if the redo logs of your primary Oracle are under Automatic Storage Management. |
/path2/tnsnames.ora |
|
5d |
asm_tns_connection This value is for Oracle only. Identifies the Oracle ASM connection name found in the tnsnames.ora file. Set this parameter only if the redo logs of your primary Oracle are under Automatic Storage Management. |
+ASM1_CONN |
|
5e |
asm_username This value is for Oracle only. Identifies the Oracle user name to be used when connecting to the ASM server. Set this parameter only if the redo logs of your primary Oracle are under Automatic Storage Management. |
sys as sysdba |
|
5f |
asm_password This value is for Oracle only. Password for Oracle ASM access for the user specified in asm_username. Set this parameter only if the redo logs of your primary Oracle are under Automatic Storage Management. |
change_on_install |
|
5g |
pds_port_number This value is for Microsoft SQL Server only. This is the client socket port number for the primary database gateway server. |
1111 |
|
5h |
pds_server_name This value is for Microsoft SQL Server only. This is the name of the Microsoft SQL Server primary database server. |
doc_23 |
|
5i |
pds_database_name This is the name of the primary database on the primary database server. Replication Agent uses this value to determine which database is the primary database. For Oracle, use the $ORACLE_SID. For Microsoft SQL Server and for UDB, use the actual name of the primary database. |
sales_db |
|
5j |
pds_datasource_name This value is for DB2 Universal Database only. This is the data source name (DSN) of the ODBC driver or the catalogued database alias for the primary database. |
sales_db_alias |
|
5k |
pds_username This is the user ID that Replication Agent uses to log in to the primary database. |
pds_user |
|
5l |
pds_password This is the password for pds_username. |
pds_pw |
|
5m |
This is the Java-equivalent of the primary database character set. Unless 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. |
|
|
5n |
pds_dac_port_number This value is for Microsoft SQL Server only. The dedicated administration connection port number that Replication Agent uses to connect to the primary database during the server-level initialization of the primary data server. |
1348 |