From MATT.ADAMS@APPL.GE.COM Wed, 21 Nov 2001 06:03:05 -0800 From: "Adams, Matthew (GEA, 088130)" Date: Wed, 21 Nov 2001 06:03:05 -0800 Subject: RE: Upgrade 8.0.5 to 8.1.6 Message-ID: MIME-Version: 1.0 Content-Type: text/plain Title: RE: Upgrade 8.0.5 to 8.1.6 Ed,   There's more to it than just setting the COMPATIBLE parameter.  The basic steps are 1) install new 8.1.6 executables 2) copy init.ora file from old 8.0.5 home to 8.1.6 home,   making whatever modifications are necessary due to   new or obsoleted parameters 3) startup database 4) run  u0800050.sql as sys.  This modifies internal Oracle objects to new forms needed by 8.1.6 software.  Once this is done, NEVER open the database using the old version, as it can corrupt the database. ---- Matt Adams - GE Appliances - matt.adams@appl.ge.com "Doing linear scans over an associative array is like trying to club someone to death with a loaded Uzi."     - Larry Wall (creator of Perl) > -----Original Message----- > From: Ed [mailto:mrclark@xnet.com] > Sent: Tuesday, November 20, 2001 6:00 PM > To: Multiple recipients of list ORACLE-L > Subject: Upgrade 8.0.5 to 8.1.6 > > > A DBA here is trying to upgrade several 8.0.5 databases to 8.1.6 > by using export/import.  This will probably work, but wouldn't it be > easier to just do a cold backup and open them using the > COMPATIBLE parameter in the 8.1.6 environment?  Is there > any downside to using export/import? (ie. will it affect snapshots, > db links, etc...).  > > I thought the whole point of the compatible parameter was that > it let you open up an older database with no questions asked. > Then you could run any of the upgrade .sql scripts at your leisure, > yes? > > Best, > > Ed > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Ed >   INET: mrclark@xnet.com > > 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@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). >