First, you will want to thoroughly review the Oracle 10gR2 new features and upgrade guides available on Oracle's Technology Network Web site. The upgrade guide will not only describe the upgrade process in detail, it also discusses how to develop a testing plan to perform upgrade, functional and performance testing.
Second, you will want to perform the entire upgrade process and testing procedures on a non-production system. And, hopefully, you will be able to go through the entire process several times before you attempt it on a production system.
Third, remember to test, test, test! I cannot emphasize enough the importance of not only testing the upgrade procedure, but also coordinating with the application support teams to undertake functional testing of the applications that your database supports.
Finally, remember to document all your test plans and processes that are executed throughout the testing phase and actual upgrade.
Dig Deeper on Oracle database export, import and migration
Related Q&A from Maria Anderson
Can I use /var/opt/oracle/oratab to specify listener information? Continue Reading
We would like to migrate our database from Oracle 8.1.7 to Oracle 10g. We would like to know the impact for our application developed using Delphi ... Continue Reading
I have been trying to install Oracle 8.1.7 on SUSE Linux 9.0 and got the error: "Error in invoking target install of makefile /opt/oracle/...../*.mk." Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.