Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: System startup and Rollback segment problem

Re: System startup and Rollback segment problem

From: XU <xux_at_informa.bio.caltech.edu>
Date: 30 Jun 1999 19:44:18 GMT
Message-ID: <7lds2i$8ja@gap.cco.caltech.edu>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US