Re: Problems that can ocuur while upgrading from 9i 1o 10g
Date: Thu, 18 Sep 2008 18:26:16 -0700 (PDT)
On Sep 18, 8:58 pm, 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..
Read the upgrade guide. Then read it again. Look in Metalink - it covers things that have happened elsewhere.
Problems will depend on your specific site. We only found one minor change in PL/SQL that broke one of our packages; the rest went smoothly, but we'd done functional and load tests on an exact copy of our production DB, so we knew what to expect. Many sites don't have that luxury.
From what I've heard, having a lot of non-default init.ora settings can also cause you grief. During our upgrade I took the opportunity to restore a whole lot of parameters to their defaults in 10g, as well as enabling ASMM. Joel wrote "Justify all init.ora changes and settings", and I agree - a lot of init.ora files have settings added years ago and never touched subsequently. A thorough review will probably show up a lot that just aren't required under 10g.