Can the event 10061 be mid-long term solution ?
> No. this event disables smon from cleaning up.
> And it should not stay in the init.ora for any length of time.
Regards,
Barry
-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com] On Behalf Of paquette
stephane
Sent: Tuesday, January 16, 2001 2:35 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: ORA-600 with smon crashing the db as soon it is started
Hi,
The compatible parameter is set to 8.1.0, not 8.1.6
All tbs are read-write.
If it's a bug, it means a lot of other people should
have it . Oracle 816 on Solaris 5.7 is a popular mix.
I can migrate to 817 , I just received the cd last
week. I can also switch from locally to dictionnary
managed tbs :-(
Can the event 10061 be mid-long term solution ?
- sheisey_at_att.net a écrit : > Stephane, You are
running into a bug. There seems to
> be a
> couple of solutions to this problem. One solution is
> to
> use dictionary managed tablespaces. Another solution
> is
> DO NOT set compatible=8.1.6. The event 10061 level
> 10 is
> another work around. This also seems to be a problem
> with
> read only locally managed tablespaces and was fixed
> by
> making the tablespace read-write.
>
> Scott
> > 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,
>
=== message truncated ===
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
Received on Tue Jan 16 2001 - 07:44:08 CST
