Unfortunately, the stack trace from my problem is
different from the stack trace of bug 1397075 (and I
did not drop any locally managed tbs).
According to Oracle, it seems to be a corruption in
uet$ (all my tbs are locally managed except system)
Oracle will open a new bug. (Do I have a t-shirt ?)
What bothers me is that it can happen again since no
correction have been applied.
- "Trassens, Christian" <CTrassens_at_uni2.es> a
écrit : > Hi,
>
> You've received the symptons of the bug 1397075.
> Have you dropped a read
> only tablespace locally managed ??.
>
> Startup mount the database and issue and alter
> database datafile '......'
> offline drop; for each datafile of the tblsp that
> you intended to drop. And
> then you can open the database and drop the
> tablespace with option including
> contents;
>
> Regards.
>
> > -----Mensaje original-----
> > De: paquette stephane
> [SMTP:stephane_paquette_at_yahoo.com]
> > Enviado el: lunes 15 de enero de 2001 11:20
> > Para: Multiple recipients of list ORACLE-L
> > Asunto: ORA-600 with smon crashing the db as soon
> it is started
> >
> > Hi,
> >
> > On Solaris 5.7/Oracle 816 (64 bit), I have a
> server
> > with 3 identical databases. 2 of them have crashed
> > late friday night and I'm not able to start them.
> >
> > I started them but just after the db are opened,
> smon
> > crash them with have ORA-600 [kcbgcur_9].
> >
> > Since there is an ORA-600, I've called Oracle
> support.
> >
> > If anyone had this one, I'd be glad to hear it.
> >
> > TIA
> >
> > =====
> > Stephane Paquette
> > DBA Oracle
> > stephane_paquette_at_yahoo.com
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Get email at your own domain with Yahoo! Mail.
> > http://personal.mail.yahoo.com/
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > --
> > Author: =?iso-8859-1?q?paquette=20stephane?=
> > INET: stephane_paquette_at_yahoo.com
> >
> > Fat City Network Services -- (858) 538-5051
> FAX: (858) 538-5051
> > San Diego, California -- Public Internet
> access / Mailing Lists
> >
>
> > To REMOVE yourself from this mailing list, send an
> E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> ORACLE-L
> > (or the name of mailing list you want to be
> removed from). You may
> > also send the HELP command for other information
> (like subscribing).
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Trassens, Christian
> INET: CTrassens_at_uni2.es
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Stephane Paquette
DBA Oracle
stephane_paquette_at_yahoo.com
Received on Mon Jan 15 2001 - 05:56:32 CST
