I would not do that. Those migrate scripts change the catalog tables to support the 8.1.6 engine and do other things. I would never consider upgrading a system without doing that step.
-----Original Message----- Sent: Wednesday, November 21, 2001 10:36 AM To: Multiple recipients of list ORACLE-L That's exactly what I was saying I think. ie. To quickly move 8.0.5 to 8.1.6, set compatible and everything should run without doing anything else (including the u*****.sql script). You can run migration later if you need new features of 8.1.6. Reasonable statement? Best, Ed -----Original Message----- Sent: Wednesday, November 21, 2001 9:57 AM To: Multiple recipients of list ORACLE-L Ed, COMPATIBLE is there to allow backwards compatibility. If you upgrade from 8.0.5 to 8.1.6 and set COMPATIBLE=8.0.5 in your init.ora, new features will not be turned on, allowing an easier port back to 8.0.5 if necessary. Quoting from Oracle8i Reference Release: "COMPATIBLE lets you use a new release, while at teh same time guaranteeing backward compatibility with an earlier release... This parameter specifies the release with which the Oracle server must maintain compatiibility. It allows you to take advantage of the maintenance imporvements of a new release immediately in you production systems without testing the new functionality in your environment." Henry -----Original Message----- Sent: Wednesday, November 21, 2001 9:30 AM To: Multiple recipients of list ORACLE-L When I read through Oracle's migration info it looks to me like all init ora params from 8.0.5 are supported, though obsolete, in 8.1.6. What is the point of the "compatible" parameter then if you have to run the conversion script on the database? Thanks for answering. Best, Ed On Wed, 21 Nov 2001, Adams, Matthew (GEA, 088130) wrote: > 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 - [EMAIL PROTECTED] > "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:[EMAIL PROTECTED]] > > 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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: Mr. Clark INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Henry Poras INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Ed INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Kevin Lange INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
