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.
Verify 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.
To migrate from Oracle 9i to Oracle 10g
Follow the steps that Oracle provides in their documentation for upgrading from Oracle 9i to Oracle 10g.
After upgrading Oracle, you must re-start the Replication Agent and issue the ra_migrate command.
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.