Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: UPgrade from 8163 to 9.2?????

Re: UPgrade from 8163 to 9.2?????

From: Faan DeSwardt <faan_at_sbcglobal.net>
Date: Tue, 13 Jul 2004 10:17:36 -0700
Message-ID: <003d01c468fd$4c3c2080$cf63400a@verifone.com>


Seema,

This should be a breeze and I have done it many times i.e. 8.1.x -> 9.2.x. The only DB's that offer some challenge are Oracle Apps DB's since Oracle has very tight dependencies between the Apps code and the version of the DB. Check the proper interoperability patches and dependencies on Metalink and test, tar, bug, patch, test, etc. Nothing new to the Oracle Apps upgrade scenario but you definitely want to thoroughly check your custom code as there are some nasty surprises in the way the CBO behaves between 8.x and 9.x.

The oldest version I've done is from 8.0.6 to 9.2.0 in a single upgrade script just 2 months ago for an OLTP database and no issues so far.

Obviously test upgrades and proper UAT will reveal any surprises specific to your env.

Thoroughly check the upgrade doc and make sure you have covered all the bases e.g. specific options need special attention.

Good Luck!

-f

> Hi
> I have couple of Databases runing on SUN E450 Solaris 5.7 with
> Oracle8.1.6.3.
> I'm planning to upgrade to 9.2. Wondering how risky is this process? If
> someone have had such situation may share their experience.Please also
> suggest what are precausion we need to take care of during migration.
> Which one is safer, need to install Oracle9.2 into diffrent oracle home
or
> upgrade 8.1.6.3 to 8.1.7 and then 9.2
> thanks
> -Seema
>
> _________________________________________________________________
> MSN Toolbar provides one-click access to Hotmail from any Web page FREE
> download! http://toolbar.msn.click-url.com/go/onm00200413ave/direct/01/
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Tue Jul 13 2004 - 12:12:50 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US