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: RE: 8174 32 bit to 9204 64 big

Re: RE: 8174 32 bit to 9204 64 big

From: <solbeach_at_cox.net>
Date: Sat, 3 Apr 2004 9:52:14 -0500
Message-Id: <20040403145214.HJRM2477.fed1mtao01.cox.net@smtp.west.cox.net>


> From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
> Tim
> I think this is a very important issue for all of us. An upgrade offers
> the potential to corrupt a database even in the best of circumstances, and
> we should strive to reduce that risk.

IMO, bugs are bugs and software is too dumb to know whether it is being invoked from an installation script or from an upgrade script. For example is CATPROC.SQL has a bug in it, bad things will happen within the Data Dictionary regardless of doing a fresh install or an upgrade/migration. In an ideal world both a fresh installation & import or an upgrade should get you to the same end condition. In the past I've avoided using GUI wizards because they were to much black magic for me. However I recently used DBUA to upgrade a DB from V7.3.4.5 to V9.2.0.4 painlessly. I had done about a dozen test upgrades before doing the actual production DB for real and was completely confident that no issues would result. The upgrade was 100% successful (& painless). I'll always take the path which requires less time & effort as long as I am confident that I'll be successful. Needless to say, prior to statring DBUA I was sure I has a solid backup in case Murphy showed up to ruin me day. Actually this database went from Solaris V2.6 (32-bit) to Solaris 9 (64-bit) running 64-bit Oracle V9.2.0.4.

For once Oracle got something right!



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 Sat Apr 03 2004 - 08:48:38 CST

Original text of this message

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