Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SPFILE and rollback_segments parameter

Re: SPFILE and rollback_segments parameter

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Fri, 19 Apr 2002 20:47:37 +1000
Message-ID: <a9osnj$i4v$1@lust.ihug.co.nz>


I *DO* wish that people wouldn't just include error numbers and expect the rest of humanity to know the text of them all off by heart. What was wrong with including the "Oracle instance terminated: disconnection forced" text that I had to look up??

I'm almost certain that if you did what the rest of the error message told you to do, you'd find the cause of the problem. Read the alert log, and you'll find a message along the lines that 'undo tablespace X doesn't exist'.

In other words (which pre-empted my next question) you are mixing 9i and 8i features. I suspect you've got an undo tablespace specified in the spfile, which doesn't actually exist. (Incidentally, why on Earth you are bothering with old-fashioned rollback segments now you have 9i, I can't imagine).

Regards
HJR "Janne Keskitalo" <Janne.Keskitalo_at_oulu.fi> wrote in message news:a9opji$siu$1_at_ousrvr3.oulu.fi...
> I'm stuck and could really use some help. I'm trying to get my rollback
> segments online on startup by using the initialization parameter
> "rollback_segments". Previously when I used traditional init.ora file it
> worked perfectly, but now with the spfile, no such luck. I did "alter
system
> set rollback_segments='(rbs01, rbs02, rbs03, rbs04)' scope=spfile;". Then
I
> did shutdown, startup and got ORA-01092. It works if I specify only one
> rollback segment, like "alter system set rollback_segments='rbs04'
> scope=spfile;", but I need them all. I have tried different syntaxes, used
> lower and upper case, but found no solution.
>
> I can get all the segments online manually after startup.
>
> (Oracle version 9.0.1, Solaris Sparc)
>
> Thanks...
>
> --
> JKe
>
>
>
>
Received on Fri Apr 19 2002 - 05:47:37 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US