Re: Oracle8 Instance Auto-shutdown

From: Piotr Kolodziej <pkol_at_otago.gda.pl>
Date: Wed, 29 Apr 1998 09:00:28 +0200
Message-ID: <6i6jhb$h8r$1@sunrise.pg.gda.pl>

>Rollback segments do not come online automatically unless they are
specified
>in the init.ora. The parameter is
>rollback_segments=(rbs01,rbs02,rbs03....etc) where rbs01, rbs02..are the
>rollback segments. Otherwise you have to issue "alter rollback segment
><segment name> online".
>

Yes, that's the first thing that should have been done.

However, having no on-line rollback segments (except of SYSTEM) SHOULD NEVER force the database shutdown ! See your alert log (default file:
%oracle_home%\rdbms80\trace\<instance_name>alrt.log). Probably there is some information about critical errors, for example ORA-00600.
If it's Oracle 8.0.3.0, you'd better patch it to 8.0.3.1 or higher.

Piotr
pkol_at_otago.gda.pl Received on Wed Apr 29 1998 - 02:00:28 CDT