Hi,
This is linked to my ora-600 problem.
Of course, the SA is not here today.
How do I verify that the disks are not corrupted ?
This is a Sun E450 with Solaris 5.7.
Disks are from Sun , 18g disks. Nothing fancy.
We're using Veritas Volume Manager
TIA
- "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
> > > > '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
> > > (or the name of mailing list you want to be
> removed
=== message truncated ===
Received on Mon Jan 15 2001 - 08:33:03 CST