RE: DB Version upgrade with CreateDB/Import "Risky"???

Um, why not just install the software and then run that silly little upgrade script they give you. Oh yeah, and change the oracle_home parameter in the listener and change the compatible parameter in the init.

Not that your way is wrong but seems to be a tad more then what you need to do. Unless of course you need to rearrange stuff for some reason.

-----Original Message-----
Damiano
Sent: Sunday, May 05, 2002 9:23 AM
To: Multiple recipients of list ORACLE-L

Hello fellow Oracle DBAs,

I really need your opinion on this matter:

I routinely do upgrades of Oracle software and databases on all types of systems: Compaq Unix, Netware, Linux, etc. (as do we all from time to time). On one Windows/NT 4 system where I am presently doing an upgrade from a lower version of Oracle 8 to 8.1.7, I am dealing with a particular System Administrator for the NT box who knows a little about Oracle, but that is obviously laboring under some misconceptions.

He strongly believes that the ONLY way one should upgrade a database (once the software has been upgraded) is to do a "migration" (presumably as detailed in the Oracle Migration manual) and he is URGING me to do it this way.

On small databases (i.e. less than 10G) where downtime is not an issue, the way I have always done it and the way I intend to do it this case is:

(1) Take a full database "export" under the old version
(2) Install the Version 8.1.7 software
(3) Recreate from scratch the database under the new software
(4) Do a full database "import" to the new database.

For our systems, I as the DBA believe and have found this to be a fully reliable, quick, and clean method and the preferable way to do it, rather than go through the migration procedure. He on the other hand believes that NOT doing it via the "migration" route is very "risky".

Without going into a long spiel with him about what an upgrade IS as far as the database itself is concerned (i.e. the data dictionary objects being brought up to the new version), and why the way I intend to do it with a full import is perfectly acceptable to accomplish this, I'd like to just offer this person the opinions of some of you out there in ORACLE-L List Land where the Oracle DBA expertise is highly respected for its stature, I.E. so he doesn't have to believe me.

In other words, I don't want to try to convince him against his will......I'd rather have impartial competent experts give him unbiased testimony. Thus I humbly solicit your opinion on this matter. I believe that my above procedure is a simple and fully reliable way of bringing the database up to the new software level......or perhaps it is ***I*** that am laboring under the misconception??? May I please have your take on this.....

Much appreciate,

JDamiano

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: James Damiano
  INET: jadam_at_nhes.state.nh.us

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kimberly Smith
  INET: ksmith2_at_myfirstlink.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).