Re: Problems that can ocuur while upgrading from 9i 1o 10g
Date: Thu, 18 Sep 2008 06:55:31 -0700 (PDT)
Message-ID: <bc277344-4789-43e4-9207-ebcd11366374@59g2000hsb.googlegroups.com>
On Sep 18, 6:58 am, Jenny <jjohni..._at_gmail.com> 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