Re: Shite of the day (now 9i upgrade)

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 <ORACLE-L_at_fatcity.com> 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: Binley.Lim_at_xtra.co.nz

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: 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).