Mirror Replication Agent for Oracle migration process to support Oracle 9i to Oracle 10g migration.
NOTE: U need to verify that the Mirror 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 Mirror Replication Agent moves the truncation point to the end of the log during Oracle 9i to Oracle 10g migration.
Steps to 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 Mirror Replication Agent and issue the
OR Now u have to do :
Create a new 10g database with the DBCA (database configuration assistant).
Create the user and any custom tablespaces that u have in your 9i database.
You may need to export then import only one schema, if that is what ur application uses.
CAUTION: It is good practice to take all necessary backups and build temp server with same version…. before doing anything
Rest depends on u and ur employer !