pds_tns_filename

(Oracle only) The fully-qualified file name identifying the Oracle tnsnames.ora file that contains connection parameters for the primary Oracle data server.

Note: This parameter is available only for Oracle.

Default

None.

Value

A valid Oracle tnsnames.ora file that contains the connection parameters to the primary Oracle data server. This file normally resides in the ORACLE_HOME\network\admin directory.

Comments

When configured, Replication Agent will use the connection information specified in the tnsnames.ora file to connect to the primary database and the pds_host_name and the pds_port_number are ignored. The pds_tns_connection name should be configured to the entry name in the Sybase interfaces file when pds_tns_filename is configured.
Setting of the configuration parameter is required when the Oracle data server instance to be replicated is part of a Real Application Clusters (RAC) configuration.

Warning! The Replication Agent process must have read permission to this file. Access failures will prevent Replication Agent from connecting to the Oracle server.