Re: ignored duplicate rollback segment

Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1069705536.347636_at_yasure>...
> yls177 wrote:
>
> > sybrandb_at_yahoo.com wrote in message news:<a1d154f4.0311170617.1a2f78a1_at_posting.google.com>...
> >
> >>yls177_at_hotmail.com (yls177) wrote in message news:<c06e4d68.0311170018.353f8111_at_posting.google.com>...
> >>
> >>>i have this set of messages appearing regularly in my alert file.
> >>>
> >>>Ignored duplicate rollback segment 12 in ROLLBACK_SEGMENTS parameter
> >>>Ignored duplicate rollback segment 2 in ROLLBACK_SEGMENTS parameter
> >>>Ignored duplicate rollback segment 13 in ROLLBACK_SEGMENTS parameter
> >>>Ignored duplicate rollback segment 14 in ROLLBACK_SEGMENTS parameter
> >>>Ignored duplicate rollback segment 15 in ROLLBACK_SEGMENTS parameter
> >>
> >>So verify the rollback_segments parameter in init.ora and discover you
> >>do have duplicated segment names in it.
> >>
> >>Sybrand Bakker
> >>Senior Oracle DBA
> >
> >
> >
> >
> > in my initsid.ora, i had the following rollback segments
> > rollback_segments = (PRS_1,PRS_10,PRS_11,PRS_12,PRS_13,PRS_14,PRS_2,PRS_3,PRS_4,PRS_5,PRS_6,PRS_7,PRS_8,PRS_9,
> > prs_10, prs_11,
> > prs_12, prs_13, prs_14, prs_15, prs_16, prs_17, prs_18, prs_19,
> > prs_20, prs_21, prs_22, prs_23, prs_24, prs_25, prs_26, prs_27,
> > prs_28, prs_29, prs_30)
> >
> > as you could see.... rollback segment, 12, 13, 14, are declared twice.
> >
> > but PRS_2, prs_15 are declared once.
> >

yup. but prs_2 , prs_15 are only declared once...

> > my understanding tells me that PRS_12 and prs_12 are the same,
> > irregardless of big case?
> >
> > another question is what happens to PRS_2, prs_15. they are declared
> > once only.
>
> Get rid of the dups and bounce the database.
Received on Mon Nov 24 2003 - 23:04:16 CST