Re: rollback segs prob. 7.3.2.3 -> 7.3.3.0

From: Dave Brady <brady_at_fas.harvard.edu>
Date: 1997/11/18
Message-ID: <64sp3n$fdb$1@news.fas.harvard.edu>#1/1

> I've just done this upgrade (on Digital UNIX 4.0B), and now I
> can't open the database:
>
> ORA-01682: rollback segment (2) has unlimited extents
>
> I had created this database with unlimited extents on the rollback segments,
> as I wanted something with which I could experiment.
>
> The Oracle7 Server Messages book does not list this error, so
> I have no clue as to how to correct it.

I found the solution. You need to have this line in your init<SID>.ora to allow for unlimited extents in your rollback segments:

unlimited_rollback_segments = TRUE

Since I was not given the installation guide or release for 7.3.3, I wasn't aware of this parameter.

-- 

Dave Brady                    FAS Computer Services
Sr UNIX Sys Admin/Programmer  Harvard University
brady_at_fas.harvard.edu         LL1A Science Center
Phone: (617) 495-1273         1 Oxford Street
FAX:   (617) 495-1210         Cambridge, MA 02138

Received on Tue Nov 18 1997 - 00:00:00 CST