Q
Manage Learn to apply best practices and optimize your operations.

Upgrading to 10g on Unix Server

We are going to upgrade from Oracle9i to Oracle 10g on Unix Server. Are there any precautions we should take before migration, and what methods should we follow?

We are going to upgrade from Oracle9i to Oracle 10g on Unix Server. Are there any precautions we should take before migration, and what methods should we follow?

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

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close