Q

Problems encountered during upgrade to 10g

I'm trying to upgrade from Oracle 9.0.1.4 to Oracle 10g. Can you please tell me the problems I'm likely to encounter during upgrade?

I'm trying to upgrade from Oracle 9.0.1.4 to Oracle 10g. Can you please tell me the problems I'm likely to encounter during upgrade? Thanks in advance.

A database upgrade from Oracle9i Release 1 to Oracle 10g Release 2 is a substantial change. Because I have no information about your applications or databases, it is impossible for me to predict whether you will encounter any difficulties as a result of this upgrade.

I would recommend reviewing the Oracle 10g Release 2 Upgrade Guide, as well as the New Features guide.

The upgrade guide, in particular, contains excellent information on how to prepare for an upgrade, as well as perform sufficient functional testing. I would recommend practicing the upgrade several times in a non-production environment. This testing should include application and functional testing each time the upgrade is performed. Be sure to create a test plan prior to testing, and make sure it is followed by everyone testing the supported applications.

This was first published in June 2006

Dig deeper on Oracle database installation, upgrades and patches

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close