| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: ORA-600 with smon crashing the db as soon it is started
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
>=20
>=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
> > > >
>=20> To REMOVE yourself from this mailing list, send an E-Mail message
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing =
Lists
> --------------------------------------------------------------------
 |
 |