Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: System startup and Rollback segment problem
Check the rollback_segments value in your init<SID>.ora file. For example,
it shoud be set to = (r01,r02,r03,r04) if you have all these four
non-system rollback segments.
Robert Xu
Michael J. Loeffler (mloeffler_at_teletrade.com) wrote:
: 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 - 14:44:18 CDT