< Previous  | TOC | Index | Next  >

Migrating the database from Oracle9i to Oracle 10.2.0.2 on RHEL4

After installing Storage Foundation 5.0 for Oracle RAC 5.0 and Oracle 10.2.0.2 binaries, you can migrate the database.

 To migrate the database from Oracle9i to Oracle 10.2.0.2

1. Start the Oracle9i instances on all the nodes.
2. Verify that CRS is running on all the nodes.
3. Verify the Oracle 10g Listeners on all the nodes are up and running.
4. Verify that the /etc/oratab file has all entries for the instances on all nodes.
5. Log in as the oracle user.

   # su oracle

6. Export the display.
7. Follow Oracle Metalink Note #263809.1 to manually upgrade Oracle 9i databases to Oracle 10.2.0.1 or use dbua upgrade utility. You now have the following up and running:.

   You now have the following up and running:

   • RHEL4 U3
   • Storage Foundation 5.0 for Oracle RAC 5.0
   • Oracle 10.2.0.2 database