Re: System startup and Rollback segment problem

Michael

You may be lacking the rollback_segments parameter from your init.ora file, so the rollback segments are there but not online. Have a look at the value of this in v$parameter (select name, value from v$parameter where name like 'rollback%';). If it's empty, add a line to the init.ora file like this:

rollback_segments = r01, r02, r03 ...

where r01 etc. are the names of your rollback segments.

HTH. Pete

"Michael J. Loeffler" 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

--
Regards

Pete

Received on Wed Jun 30 1999 - 14:43:51 CDT