Re: Problems that can ocuur while upgrading from 9i 1o 10g

From: Mark D Powell <>
Date: Thu, 18 Sep 2008 06:55:31 -0700 (PDT)
Message-ID: <>

On Sep 18, 6:58 am, Jenny <> wrote:
> Our company is planning to uprage from oracle 9i to 10g.
> I want to know what all problem i will face during upgradation..

First, 9i and 10g are marketing labels and not real Oracle version numbers.
Second, upgrade how? Using which method/path? Upgrade in place on same platform, Exp/Imp, New platform, etc ....

 As long as you are following the directions in the Oracle Installation and Migration Guide you should be fine. Pay attention to the OS patch requirements in the manual and be sure to visit the referenced web site for updates to the upgrade process.

The real fun is after you upgrade and you have to re-tune your applications. How much of this you have to do will depend on your application. Some sites have few if any performance issues after upgrading while others have more work than the shop can handle. Based on conversations with other DBA's who have upgraded most sites have only a few issues.

HTH -- Mark D Powell -- Received on Thu Sep 18 2008 - 08:55:31 CDT

Original text of this message