RE: Shite of the day

What asked for 9.0.2? Are you sure you didn't misread 9.2.0 ?

You said you set COMPATIBLE to 9.0.2 and then started getting these errors -
 ORA-01571: redo version 9.0.2.0.0 incompatible with ORACLE version 8.1.7.0.0

Sounds like maybe you ran a migrate or downgrade script with an invalid COMPATIBLE parameter and that's what hosed it.

-----Original Message-----
Sent: Thursday, June 05, 2003 10:20 AM
To: Multiple recipients of list ORACLE-L

Yes. But why is it asking for 9.0.2? I set it to 9.2, 8.1.7, and 9.0.2 just to give it a try.
-----Original Message-----
Sent: Wednesday, June 04, 2003 7:30 PM
To: Multiple recipients of list ORACLE-L

I guess this is a silly question, but could it be that Oracle didn't like the COMPATIBLE = 9.0.2 since there is no 9.0.2? I don't know how the comparison is done, but if it's a string comparison I wonder if there will be any bugs with the COMPATIBLE check when version 10 comes out.
> -----Original Message-----
> From: Koivu, Lisa [mailto:Lisa.Koivu_at_Fairfieldresorts.com]
>
> No. I guess by manual I mean I didn't use the gui. I ran the
> appropriate upgrade script.
>
> Gosh I hope it doesn't come to exp/imp... I can't even export
> my database.
>
> -----Original Message-----
>
> Lisa, when you say you "manually" migrated, did you use
> exp/imp after a
> fresh CREATE DATABASE in 9i? Also, what platform? 32-bit?
>
> Rich Jesse System/Database Administrator
> rjesse_at_qtiworld.com Quad/Tech Inc, Sussex, WI USA
>
>
> > -----Original Message-----
> > Lisa
> >
> > 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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Seefelt, Beth
  INET: Beth.Seefelt_at_TetleyUSA.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).