Re: System startup and Rollback segment problem

From: Kenny Gump <kgump_at_mylanlabs.com.nospam>
Date: Wed, 30 Jun 1999 16:29:12 -0400
Message-ID: <377a7e3f.0@news.mountain.net>

First log in to the database as a DBA and query dba_rollback_segs and get the name of all non-system rollback segments. Next edit your init.ora file and add the following line: (Assuming I have rollback segments r01, r02 and r03)

rollback_segments = (r01, r02, r03)

This will bring these rollback segments online automatically at startup. By default only SYSTEM rollback segment comes online at startup.

Kenny Gump

Michael J. Loeffler wrote in message <377a65ba.584508748_at_news.albany.net>...
>Hi -
>
> I am finishing up getting a new system online.
>The old Oracle system was v7.0.16 and the new system is v8.0.5
>
>The problem I am having is whenever I have to reboot the new system
>(machine reboot) and then try to insert rows into Oracle, I get the
>following error message:
>
>ORA-01552: cannot use system rollback segment for non-system
>tablespace 'TELETRADE_DATA'
>
>I then have to run a script to recreate my rollback segments, and then
>inserts work properly. My question is what am I missing in the Oracle
>startup files? As far as I can tell, I duplicated the startup scripts
>from our older system running v7 (which works just fine). Was there a
>change from v7 to v8 that might affect this?
>
>Can anyone point me in the right direction?
>Thanks very much!
>-------------------------------------------------------------------
>All opinions expressed are my own, and not necessarily
>those of my company.
>
>Michael J. Loeffler
>Manager of Information Systems
>Teletrade, Inc.
>
>MichaelL_at_Teletrade.com
Received on Wed Jun 30 1999 - 15:29:12 CDT