Setting Up Replication Agent and Oracle on Different Machines

Run Replication Agent and the primary data server on different machines.

  1. Install Replication Agent on a machine of the same hardware and operating system as the machine on which the primary data server is running.
  2. Install the JDBC driver on the same machine as Replication Agent.
  3. If the timezone.dat file is not accessible to both machines, copy the $ORACLE_HOME/oracle/timezone.dat file to the Replication Agent machine.
    Make a copy of the timezone file available on the machine hosting the Replication Agent. To determine which timezone file is used by the primary Oracle instance, connect to the Oracle instance and execute:
     select * from V$TIMEZONE_FILE
  4. Set the Replication Agent pdb_timezone_file configuration parameter to the full path name of the timezone.dat file.
  5. If Replication Agent for Oracle is configured to truncate Oracle archive logs directly, make sure the Oracle archive logs are accessible to both machines. Use the ra_devicepath command to point Replication Agent to the log files.