Re:ORA-00600: ???
Leslie, It appears that there is an action occuring on your database at 18:20 each day that needs the tablespace that was deleted. It might be a scheduled job or an application that is external to the server. try restoring the tablespace from your backup and see if the errors continue. I also would start investigation the reason for the ALTER and DROP commands. An ITAR would help speed up the process. Ron [EMAIL PROTECTED] 07/23/02 07:09PM 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 Netw ork 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
Re:ORA-00600: ???
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
Re:ORA-00600: ???
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).
Re:ORA-00600: ???
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).
Re:ORA-00600: ???
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).
