| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: PMON CRASHED INSTANCE
Seema,
Do you have any idea about the BUG no.?
Thanks,
Ashoke
>>> oracledbam_at_hotmail.com 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" <mandaa1_at_eos.medtronic.COM>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>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
>
> >>> RROGERS_at_galottery.org 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
>
> >>> oracledbam_at_hotmail.com 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: oracledbam_at_hotmail.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).
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Ashoke Mandal
> INET: mandaa1_at_eos.medtronic.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: Seema Singh INET: oracledbam_at_hotmail.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: Ashoke Mandal INET: mandaa1_at_eos.medtronic.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).Received on Fri Feb 01 2002 - 13:37:43 CST
 |
 |