Re: ORA-01545....

From: Kumar, Sai (EXCHANGE:PERPK:3374) <saikumar_at_nortel.com>
Date: Fri, 04 Dec 1998 14:29:31 -0500
Message-ID: <3668381B.2A2D4760@nortel.com>

Mike wrote:

> Hello,
>
> Can't figure this out, I received the following error during startup and
> Oracle just shutdown after this message:
>
> ORA-01545 Rollback Segment "RB2" Specified Not Available
>
> I've looked into the error book and Oracle's web, solution assumed the
> system is up... Any help is much appreciated....
>
> mc

Mike,

 Their are 3 possibilities of getting this problem :-

  (i) Check your init.ora parameter file to see if

       you have RB2 rollback segment specified.
       rollback_segment = (RB1,RB2);
  (ii)  Incase u have specified RB2 on the init.ora
         file, probably you would have changed the
         status of RB2 as offline . You can check this
         on dba_rollback_segs. Make it online.
   (iii) Remove the RB2 from init.ora file and try
          starting up the database.

Try these. Oracle doesn't recognize a problem during shutdown. When it startsup it checks the init.ora parameter file, that's where it validates the parameter.

Thanks
Sai Kumar Received on Fri Dec 04 1998 - 13:29:31 CST