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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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 > > > > > > >>> [EMAIL PROTECTED] 07/23/02 04:21PM >>> > > > open an iTAR. > > > > > > ____________________Reply > > > Separator____________________ > > > Author: Leslie Lu <[EMAIL PROTECTED]> > > > 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: [EMAIL PROTECTED] > > > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
