Replication Agent requires the following to connect to an Oracle primary data server:
The JDBC driver must be installed and referenced in the CLASSPATH system variable of the Replication Agent host machine. Java uses the contents of the CLASSPATH system variable to identify the search locations for Java classes. For the Oracle JDBC driver, the full path and file name must be included in the CLASSPATH variable, for example, drive:\<path_name>\ojdbc14.jar.
See the Replication Agent Release Bulletin for the version of the JDBC driver that is supported.
For JDBC connectivity, the TNS Listener process for the Oracle primary data server must be running.
Table 4-14 contains a description of the Replication Agent configuration parameters that must be set.
Configuration parameters |
Description |
|---|---|
pds_tns_filename |
The fully-qualified file name identifying the Oracle tnsnames.ora file that contains connection properties for the primary Oracle data server.
|
pds_tns_connection |
The Oracle connection name that identifies the primary database connection in the Oracle tnsnames.ora file.
|
asm_tns_filename |
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.
|
asm_tns_connection |
Identifies the Oracle ASM connection name found in the tnsnames.ora file.
|
asm_username |
Identifies the Oracle user name to be used when connecting to the ASM server.
|
asm_password |
Password for Oracle ASM access for the user specified in the asm_username.
|
pds_username |
The Oracle user ID that the Replication Agent uses to log in to the primary database. This user ID must be granted permissions as described in “Oracle primary database permissions”. |
pds_password |
Password for the Oracle user ID that the Replication Agent uses to log in to the primary database. |
pds_host_name |
Name of the host machine on which the Oracle data server resides. |
pds_database_name |
Name of the Oracle SID, from which transactions will be replicated. |
If both the pds_tns_filename and pds_tns_connection properties
are set, the pds_host_name, pds_port_number,
and pds_database_name configuration
properties are not used.