Re: Oracle8 Instance Auto-shutdown

From: Venkat <vreddy_at_ix.netcom.com>
Date: Tue, 28 Apr 1998 15:58:33 -0400
Message-ID: <6i5ced$7tl@sjx-ixn6.ix.netcom.com>

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".

Venkat

>I'm currently running Oracle 8.0.3 on a Windows NT Server with service
>pack 3.
>I recently experience a similar crash. While running several deletes and
>inserts
>on the database with an application I wrote in Pro C I ran into an error
>(which resulted from the data I was using). As a result of the error the
>Oracle instance
>shutdown. I was able to bring the instance backup with svrmgrl using the
Received on Tue Apr 28 1998 - 14:58:33 CDT