Well, that's what Oracle support told me.
Those databases where created from the start with
locally managed tablespaces.
I've run dbv on the datafiles but it reported nothing.
What amaze me, is that 2 databases out of 3 crashed at
amost the same time (22:30 and 22:35).
Pretty weird.
Is there a way (with an hidden parameter) to prevent
smon to start or to start and do nothing when starting
the database ?
- "Trassens, Christian" <CTrassens_at_uni2.es> a
écrit : > Sorry, I've read it again and I have a
doubt. How
> could it be the uet$
> corrupted ?. Or did you transform an dictionary to
> local with
> dbms_space_admin ?.
>
> Regards.
>
> > -----Mensaje original-----
> > De: Trassens, Christian [SMTP:CTrassens_at_uni2.es]
> > Enviado el: lunes 15 de enero de 2001 13:15
> > Para: Multiple recipients of list ORACLE-L
> > Asunto: RE: ORA-600 with smon crashing the db as
> soon it is started
> >
> > So, let us know the workaround.....if it had one.
> >
> > > -----Mensaje original-----
> > > De: paquette stephane
> [SMTP:stephane_paquette_at_yahoo.com]
> > > Enviado el: lunes 15 de enero de 2001 12:56
> > > Para: Multiple recipients of list ORACLE-L
> > > Asunto: RE: ORA-600 with smon crashing the db as
> soon it is started
> > >
> > > 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
> > >
> > >
> __________________________________________________
> > > 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
=== message truncated ===
Received on Mon Jan 15 2001 - 08:18:01 CST