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

On Sep 18, 6:55 pm, Mark D Powell <Mark.Pow..._at_eds.com> wrote:
> 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 --

Actually we have to upgrade Oracle and we are also changing platform from TRU64 UNIX to HP-UX
what we have planned is
firstly we will upgrade oracle on the TRU64 Unix and tune the application
and then we will change the platform from TRU64 to HP-UX Received on Fri Sep 19 2008 - 00:58:24 CDT