Running Replication Agent and Oracle on different machines

Do the following to run Replication Agent and the primary Oracle data server on different machines.

StepsSetting up Replication Agent and Oracle to run on different machines

  1. Install the Replication Agent on a machine of the same type of hardware and operating system as the machine on which the primary Oracle data server is running.

  2. Install the Oracle JDBC driver on the same machine as Replication Agent.

  3. If the timezone.dat file is not in a location accessible to both machines, copy the $ORACLE_HOME/oracle/zone.dat file to the Replication Agent machine.

    NoteBe sure to copy the timezone.dat file of the Oracle server that Replication Agent is reading.

  4. Set the Replication Agent pdb_timezone_file configuration parameter to the full path name of the timezone.dat file.

  5. Make sure the Oracle online and archive logs reside in a location accessible to both machines. Use the ra_devicepath command to point Replication Agent to Oracle log files.