System startup and Rollback segment problem

From: Michael J. Loeffler <mloeffler_at_teletrade.com>
Date: Wed, 30 Jun 1999 18:50:17 GMT
Message-ID: <377a65ba.584508748@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 - 13:50:17 CDT