I had experienced a similar problem (twice).
I believe it is related to locally managed tablespaces.
There is an event that can be put in the init.ora file that
Prevents smon from starting. We put this event in the
init.ora did a startup and shutdown normal a couple of times.
We then removed the event and the database returned to normal.
The event (10061) should only be used at the
direction of oracle support , unfortunately I have
found that not all oracle support people are familiar with this.
At the very least the use of this event will allow you
to open the database and perform exports and experiment
with which tablespace is causing the problem.
If a shutdown normal and startup does not work you may
want to try converting your tablespaces back from locally managed
to dictionary and see if that eliminates the problem.
HTH
Barry
Btw: How are your dbs identical.
Replication ? snapshots ?
-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com] On Behalf Of paquette
stephane
Sent: Monday, January 15, 2001 6:56 AM
To: Multiple recipients of list ORACLE-L
Subject: 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
Received on Mon Jan 15 2001 - 08:48:48 CST
