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.

    Requires Free Membership to View

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

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.