I just started/stop the db with event 10061 several
times, thanks to Barry Botuck.
Now let's see if I removed the event....
- "Trassens, Christian" <CTrassens_at_uni2.es> a
écrit : > Well, I suppose if it crashes when acceses
to uet$,
> you can consider
> enabling the event 10269. However and answering your
> question, there isn't a
> way to prevent SMON starting. Remember that it's one
> of the backgrounds
> processes.
>
> Analyzing your assumption, did you ever clone those
> databases ?. And did you
> create each one with different names ?. Did anything
> weird happen when you
> do it or did you do something non-conventional to
> clone if you'd cloned, of
> course ??.
>
> Regards.
>
> > -----Mensaje original-----
> > De: paquette stephane
> [SMTP:stephane_paquette_at_yahoo.com]
> > Enviado el: lunes 15 de enero de 2001 15:20
> > Para: Multiple recipients of list ORACLE-L
> > Asunto: RE: ORA-600 with smon crashing the db as
> soon it is started
> >
> > 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
>
=== message truncated ===
Received on Mon Jan 15 2001 - 11:01:25 CST
