Migrating Replication Agent 15.2 when upgrading Oracle 10g to 11g

Replication Agent for Oracle migration to support upgrading Oracle 10g to Oracle 11g is similar to upgrading Replication Agent for Oracle 15.1 to Replication Agent 15.2.

NoteQuiesce the Replication Agent before upgrading Oracle 10g to Oracle 11g. The replication environment must have completed processing of all transactions before upgrading Oracle because the Replication Agent moves the truncation point to the end of the log during Replication Agent migration.

StepsMigrating from Oracle 10g to Oracle 11g

  1. Follow the steps that Oracle provides in their documentation for upgrading from Oracle 10g to Oracle 11g.

  2. After upgrading Oracle, re-start the Replication Agent and issue the ra_migrate command.

  3. As with the log-based Replication Agent upgrade process, you may need to reconfigure the Replication Agent for Oracle instance to read archive logs depending on the configuration in Oracle. This may change following the Oracle upgrade.

If you are upgrading from log-based Replication Agent and upgrading Oracle 10g to Oracle 11g at the same time, migrate Replication Agent 15.2 only once.