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.=20
> -----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
>=20
> Well, that's what Oracle support told me.=20
> Those databases where created from the start with
> locally managed tablespaces.=20
> I've run dbv on the datafiles but it reported nothing.
>=20
> What amaze me, is that 2 databases out of 3 crashed at
> amost the same time (22:30 and 22:35).=20
> Pretty weird.
>=20
> Is there a way (with an hidden parameter) to prevent
> smon to start or to start and do nothing when starting
> the database ?
>=20
>=20
> --- "Trassens, Christian" <CTrassens_at_uni2.es> a
> =E9crit : > 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 ?.
> >=20
> > Regards.
> >=20
> > > -----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
> > >=20
> > > So, let us know the workaround.....if it had one.
> > >=20
> > > > -----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
> > > >=20
> > > > 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).
> > > >=20
> > > > According to Oracle, it seems to be a corruption
> > in
> > > > uet$ (all my tbs are locally managed except
> > system)
> > > >=20
> > > > Oracle will open a new bug. (Do I have a t-shirt
> > ?)
> > > >=20
> > > > What bothers me is that it can happen again
> > since no
> > > > correction have been applied.=20
> > > >=20
> > > > =20
> > > >=20
> > > > --- "Trassens, Christian" <CTrassens_at_uni2.es> a
> > > > =E9crit : > Hi,
> > > > >=20
> > > > > You've received the symptons of the bug
> > 1397075.
> > > > > Have you dropped a read
> > > > > only tablespace locally managed ??.
> > > > >=20
> > > > > 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;
> > > > >=20
> > > > > Regards.
> > > > >=20
> > > > > > -----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
> > > > > >=20
> > > > > > Hi,
> > > > > >=20
> > > > > > 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.
> > > > > >=20
> > > > > > I started them but just after the db are
> > opened,
> > > > > smon
> > > > > > crash them with have ORA-600 [kcbgcur_9].
> > > > > >=20
> > > > > > Since there is an ORA-600, I've called
> > Oracle
> > > > > support.
> > > > > >=20
> > > > > > If anyone had this one, I'd be glad to hear
> > it.
> > > > > >=20
> > > > > > TIA
> > > > > >=20
> > > > > > =3D=3D=3D=3D=3D
> > > > > > Stephane Paquette
> > > > > > DBA Oracle
> > > > > > stephane_paquette_at_yahoo.com
> > > > > >=20
> > > > > >
> > __________________________________________________
> > > > > > Do You Yahoo!?
> > > > > > Get email at your own domain with Yahoo!
> > Mail.=20
> > > > > > http://personal.mail.yahoo.com/
> > > > > > --=20
> > > > > > Please see the official ORACLE-L FAQ:
> > > > > http://www.orafaq.com
> > > > > > --=20
> > > > > > Author: =3D?iso-8859-1?q?paquette=3D20stephane?=3D
> > > > > > INET: stephane_paquette_at_yahoo.com
> > > > > >=20
> > > > > > Fat City Network Services -- (858)
> > 538-5051=20
> > > > > 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).
> > > > > --=20
> > > > > Please see the official ORACLE-L FAQ:
> > > > > http://www.orafaq.com
> > > > > --=20
> > > > > Author: Trassens, Christian
> > > > > INET: CTrassens_at_uni2.es
> > > > >=20
> > > > > 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).
> > > >=20
> > > >=20
> > > > =3D=3D=3D=3D=3D
> > > > Stephane Paquette
> > > > DBA Oracle
> > > > stephane_paquette_at_yahoo.com
> > > >=20
> > > >
> > __________________________________________________
> > > > Do You Yahoo!?
> > > > Get email at your own domain with Yahoo! Mail.=20
> > > > http://personal.mail.yahoo.com/
> > > > --=20
> > > > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > > > --=20
> > > > Author: =3D?iso-8859-1?q?paquette=3D20stephane?=3D
> > > > INET: stephane_paquette_at_yahoo.com
> > > >=20
> > > > Fat City Network Services -- (858) 538-5051=20
> > 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=20
> =3D=3D=3D message truncated =3D=3D=3D
>=20
>=20
> =3D=3D=3D=3D=3D
> Stephane Paquette
> DBA Oracle
> stephane_paquette_at_yahoo.com
>=20
> __________________________________________________
> Do You Yahoo!?
> Get email at your own domain with Yahoo! Mail.=20
> http://personal.mail.yahoo.com/
> --=20
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --=20
> Author: =3D?iso-8859-1?q?paquette=3D20stephane?=3D
> INET: stephane_paquette_at_yahoo.com
>=20
> 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
Received on Mon Jan 15 2001 - 09:19:34 CST
