Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Shite of the day

RE: Shite of the day

From: Seefelt, Beth <>
Date: Thu, 05 Jun 2003 07:54:54 -0800
Message-ID: <>

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 incompatible with ORACLE version

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 []
> 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
> Quad/Tech Inc, Sussex, WI USA
> > -----Original Message-----
> > Lisa
> >
> > Worry free? I just upgraded another 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 cannot be used by
> > release 135294976

Please see the official ORACLE-L FAQ:
Author: Seefelt, Beth

Fat City Network Services    -- 858-538-5051
San Diego, California        -- Mailing list and web hosting services
To REMOVE yourself from this mailing list, send an E-Mail message
to: (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).
Received on Thu Jun 05 2003 - 10:54:54 CDT

Original text of this message