Re: Rollback segments always offline after instance started

I think I muddied the waters because the Oracle Instance Manager does not use the INTORCL.ORA parameter file when you use it to stop and restart the instance (unless of course you tell it to).

Everything seems to be working now.

Thanks,

Randy

Pete Sharman <psharman_at_us.oracle.com> wrote in message news:378BC4E1.25F3C7AE_at_us.oracle.com...
> Randy
>
> Theoretically not. A couple of things to check:
>
> 1. Is there a "#" as the first character on the line rollback_segments is
on?
> This is a comment character which comments out the whole line. Remove it
if
> needed.
>
> 2. Are you starting the database with the right parameter file? Is the
> initorcl.ora file in the default location? I'm guessing from the SID name
that
> this is on an NT box, so check the strtorcl.cmd file to see what one is
being
> used.
>
> HTH.
>
> Pete
>
> Randy Baker wrote:
>
> > I had to delete and recreate all the non-system rollback segments on our
> > server, and now I have to manually place them online each time the
instance
> > is started. I have "rollback_segments=" statement in my INITORCL.ORA
file,
> > is there something else I need to do?
> >
> > Thanks,
> >
> > Randy
>
> --
> Regards
>
> Pete
>
>
Received on Wed Jul 14 1999 - 08:09:13 CDT