It is worry-free if you follow the upgrade instructions, and not skip around like you appear to have done.
Did you run u0801070.sql at all? Did you check for any errors it might have produced? Both your errors indicate there was a problem in that area. Where did you dig COMPATIBLE = 9.0.2 from? There's no such release. Mere details, but details are important in a manual upgrade. If you decide to back-down COMPATIBLE to 8.1.7, did you run the downgrade script, check the outputs and follow the instructions? You need to do the following in order: - run the downgrade script and follow the instructions - run "alter database reset compatibility;" (OK, this bit is not that obvious in the documentation) - modify init.ora and restart If the database is in noarchivelog, isn't it reasonable that archivelogs do not exist? As for dropping redologs, eeeek! ----- Original Message ----- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, June 05, 2003 2:40 AM > Oh-My-Gosh. > > Worry free? I just upgraded another 8.1.7.4 database to 9.2. When I set the COMPATIBLE parm to 9.0.2 (or 9.2, which would make sense) I get really messy errors: > > ORA-00402: database changes by release 9.0.1.3.0 cannot be used by release > 135294976 > > ORA-01571: redo version 9.0.2.0.0 incompatible with ORACLE version 8.1.7.0.0 > > So then I tried to set it back to 8.1.7, or comment out COMPATIBLE altogether, and I get the same type of error. It won't open at all. > > I tried initiating recovery. This database is in noarc mode. It starts looking for arclogs that *do not* exist. I also tried to drop the redo log groups and recreate them. Still, no dice. > > Again, unbreakable my FUNDAMENT. > > So has anyone seen this before? I opened a tar yesterday and promptly confused support. > > Lisa -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Binley Lim INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).
