Migrating Replication Agent 15.1 when upgrading Oracle 9i to 10g

Replication Agent for Oracle migration to support upgrading Oracle 9i to Oracle 10g is a process similar to upgrading Replication Agent for Oracle 12.6 or 15.0 to Replication Agent 15.1.

NoteVerify that the Replication Agent is quiesced prior to upgrading Oracle 9i to Oracle 10g, that is, the replication environment must have completed processing of all transactions prior to upgrading Oracle because the Replication Agent moves the truncation point to the end of the log during Replication Agent migration.

StepsTo migrate from Oracle 9i to Oracle 10g

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

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

  3. As with the log-based Replication Agent upgrade, you may have to re-configure 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 9i to Oracle 10g at the same time, you need to migrate Replication Agent 15.1 only once.