Re: ORA-00600: ???

Usually, at least 4 systemstate dumps, level 10 are also recommended. Tech support will be greatful for those. I believe that RDA dumps systemstate
at least twice.

On 2002.07.25 01:13 A. Bardeen wrote:
> Leslie,
>
> The trace file should have the current SQL for the
> session that generated the error and I suspect it has
> nothing to do with the drop tablespace command. The
> ORA-600 [18062] is signaled as part of the two-phase
> commit process when it attempts to get the current
> globally unique database ID. You might want to check
> the remote database(s) and see if they have any errors
> in their alert.logs. Then I suggest you log an iTar
> with the trace file of the first occurence of the
> error, the alert.log, and RDA output (Note: 175853.1).
>
> HTH,
>
> -- Anita
>
> --- Leslie Lu <leslie_y_lu_at_yahoo.com> wrote:
> > Hi Ron,
> >
> > Thank you! Actually the "Dropping TS" only happened
> > on 7/15. There are no other special actions since
> > 7/15. And after 7/15, the error shows after "alter
> > database open".
> >
> > Sorry didn't make it clear.
> >
> >
> > --- Ron Rogers <RROGERS_at_galottery.org> wrote:
> > > Leslie,
> > > You say the message appears at 18:20 each day.
> > > Check and see what jobs
> > > have been added to the system since 7/15 that
> > would
> > > effect the database.
> > > Perhaps an erronious, undocumented action has been
> > > added that is
> > > altering your system and dropping a critical
> > > tablespace.
> > > Why would you want to drop a tablespace the same
> > > time every day? Are
> > > you using partitioning and used the wrong command
> > to
> > > drop the partition?
> > > Just a thought.
> > > Ron
> > > ROR mô¿ôm
> > >
> > > >>> dgoulet_at_vicr.com 07/23/02 04:21PM >>>
> > > open an iTAR.
> > >
> > > ____________________Reply
> > > Separator____________________
> > > Author: Leslie Lu <leslie_y_lu_at_yahoo.com>
> > > Date: 7/23/2002 11:54 AM
> > >
> > > Hi all,
> > >
> > > I have a 817 db on NT. In the alter log, I have
> > the
> > > following error since 7/15. (The error repeats
> > > about
> > > 30 times.)
> > >
> > > Mon Jul 15 16:11:32 2002
> > > Errors in file
> > > D:\Oracle\admin\DLYLASTG\udump\ORA01070.TRC:
> > > ORA-00600: internal error code, arguments:
> > [18062],
> > > [], [], [], [], [], [], []
> > >
> > > The actions before the error were ALTER SYSTEM SET
> > > global_names=FALSE; and drop a tablespace.
> > >
> > > And after 7/15, the same message shows every day
> > > around 18:20pm.(The error repeats about 30 times.)
> > >
> > > in the related trace file, I got:
> > >
> > > *** SESSION ID:(12.28226) 2002-07-15 16:15:01.156
> > > *** 2002-07-15 16:15:01.156
> > > ksedmp: internal or fatal error
> > >
> > > What does this mean and what I should do? The
> > > metalink doesn't help too much.
> > >
> > > Thank you.
> > >
> > > Leslie
> > >
> > >
> > >
> > > __________________________________________________
> > > Do You Yahoo!?
> > > Yahoo! Health - Feel better, live better
> > > http://health.yahoo.com
> > > --
> > > Please see the official ORACLE-L FAQ:
> > > http://www.orafaq.com
> > > --
> > > Author: Leslie Lu
> > > INET: leslie_y_lu_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:
> > > INET: dgoulet_at_vicr.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: Ron Rogers
> > > INET: RROGERS_at_galottery.org
> > >
> > > 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).
> >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Yahoo! Health - Feel better, live better
> > http://health.yahoo.com
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > --
> > Author: Leslie Lu
> > INET: leslie_y_lu_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).
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Health - Feel better, live better
> http://health.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: A. Bardeen
> INET: abardeen1_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).
>

-- 
Mladen Gogala
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mladen Gogala
  INET: mgogala_at_adelphia.net

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).