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

Binley,

If you really want to know, instead of just insulting me outright:

1. I followed Note 159657.1 for a "manual" upgrade. And in step 31 it directs to use u0807010.sql. I then applied patch 2878462, and went on to apply patch 2761332. So as you can see, I did my homework here. The problems started when I set compatible to a value other than 8.1.7. I had the database open and operational at version 9.2.0.3 prior to this problem.
2. I tried 9.0.2 after trying 9.2.0 because that's what it thought it was. It's hosed anyway. Why not try it? Searching Metalink did not reveal any suggestions.
3. Yes of course the arclogs do not exist, this db was never in arclog mode. Which is exactly why when it started asking for arclogs I was pretty confused.

I am trying it again and hoping that it works this time.

I'll tell you what's worry-free: upgrading on Unix. Only once in 5 years did I have a problem of this magnitude.

If you have any suggestions or constructive comments, I'd be glad to hear them. That's why I posted this problem to the list, along with letting everyone else know about the perils I enountered in this upgrade. I may not post too often to this list, but I do glance through the postings just to get a feeling for what others are doing/experiencing/testing/using.

If you are going to post comments of a sarcastic or demeaning tone, aimed at me or at anyone else, I suggest you keep them to yourself.

Lisa

-----Original Message-----
Sent: Wednesday, June 04, 2003 9:18 PM
To: Multiple recipients of list ORACLE-L

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Koivu, Lisa
  INET: Lisa.Koivu_at_Fairfieldresorts.com

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