<abc_at_iom.com> wrote in message
news:3d5e8347.237848017_at_news.sf.sbcglobal.net...
>
> Ok, while learning Oracle 9i, I really screwed the pooch this time.
>
> I had a database I created in oracle 9.0.3 (compatibility set for 8).
> I wanted to upgrade the server to release 9.2. Being the newbie that
> I am, I installed right over my original installation (and, yes, I
> looked in the manuals first).
>
> After rebooting, my database fired up, I got a message to the effect
> that "compatible must be 9.0.3 or higher in order to use Automatic
> Segment Space Management". The database was mouunted but not open.
>
> Well I went through many gyrations. I figured it had something to do
> with the redo logs remaining open or some unfinished business. I
> ended up reinstalling my old 9.0.3 software. No luck. When I did
> this and tried to open the instance, no matter what I logged in as, it
> said that I lacked the security privileges.
>
> Now, I reinstalled 9.2 and give it another toss. Now when I try to
> open the database I get the message:
>
> ORA-01571 -redo version 9.0.3.0.0 incompatible with Oracle Version
> 9.0.0.0.
>
> Without giving you ALL the dirty details, any thoughts on how I might
> recover from this? Can you fix a broken database that you can't log
> into?
>
Your best bet will probably be to delete everything and start again, but
this time read the instruction manual first.
Regards,
Paul
Received on Sun Aug 18 2002 - 14:40:56 CDT
