Migrating from Oracle 9i to Oracle 10g

Replication Agent for Oracle migration to support Oracle 9i to Oracle 10g migration is a similar process as migrating from Replication Agent for Oracle 12.6 to Replication Agent for Oracle 15.0.

NoteYou need to verify that the Replication Agent is quiesced prior to migrating from Oracle 9i to Oracle 10g. That is, the replication environment must have completed processing of all transactions prior to migrating because the Replication Agent moves the truncation point to the end of the log during Oracle 9i to Oracle 10g 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 migrating Oracle, you must re-start the Replication Agent and issue the ra_migrate command.

  3. As with the 12.6 to 15.0 migration, you may have to re-configure the Replication Agent for Oracle instance to read archive logs depending on the configuration in Oracle, which may change following Oracle migration.

If you are migrating from both Replication Agent for Oracle 12.6 to Replication Agent for Oracle 15.0, and from Oracle 9i to Oracle 10g, you need to migrate only once.