Seema, Do you have any idea about the BUG no.?
Thanks, Ashoke >>> [EMAIL PROTECTED] 01/31/02 03:45PM >>> AShoke Its oracle Bug which fixed in 8.1.7.During the time may be yours IOWAIT was high. Thx -Seema >From: "Ashoke Mandal" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: Re: PMON CRASHED INSTANCE >Date: Thu, 31 Jan 2002 12:50:30 -0800 > >Hi All, > >I had almost the same situation. My production database crashed by itself >with the following errors: > >PMON: terminating instance due to error 600 >ORA-07445: exception encountered: core dump [kghispih()+56] [SIGSEGV] >[Address not mapped to object] [97812236] [] [] >ORA-00600: internal error code, arguments: [17148], [2263082536], [], [], >[], [], [], [] > >Oracle 8.1.6.3.0 >Sun Solaris 5.6 > >Any idea. > >Thanks, >Ashoke > > >>> [EMAIL PROTECTED] 01/30/02 10:55AM >>> >Seema, >It looks like the user tried to cancel the operation. ORA-01013. after >they started the truncate. Could be it caused the insanity and crashed >the system. That might be why you never saw it before. Try to create the >same failure on a test system and see if the cancel causes a crash. >ROR m���m > > >>> [EMAIL PROTECTED] 01/30/02 10:10AM >>> >Hi >My instance was crashed when one of users was truncating the table.the > >following are the error message in alert log >Wed Jan 30 00:15:13 2002 >Errors in file pathname/udump/ora8_ora_9453.trc: >ORA-07445: exception encountered: core dump [ksqcmi()+5792] [SIGSEGV] >[Address not mapped to object] [0] [] [] >ORA-01013: user requested cancel of current operation >Wed Jan 30 00:15:19 2002 >Errors in file path/bdump/ora8_pmon_4339.trc: >ORA-00600: internal error code, arguments: [1100], [41Received: from >CONNECT-MTA by galotter62056452], >[4162056452], [], [], [], [], [] >Wed Jan 30 00:15:21 2002 >PMON: terminating instance due to error 600 >Instance terminated by PMON, pid = 4335 >I checked metalink and found its a oracle bug.But this is happening >first >time.I have truncated so many tables but v=never faces such >situation.During >the instance crash the IOWAIT was high.THis is on oracle enterprise >edition >8.1.6.0.0. on solaris 5.7 >IS any one faced such situation .if yes then how come out from this >situation.I don't want to upgrate 8.1.7 till now. >Thx >-seema > > > > > >_________________________________________________________________ >Join the world�s largest e-mail service with MSN Hotmail. >http://www.hotmail.com > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Seema Singh > 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). > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Ashoke Mandal > 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). _________________________________________________________________ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh 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: Ashoke Mandal 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).
