RE: PMON CRASHED INSTANCE

Kevin wrote:
<I hope its fixed in 8.1.7 because thats where we are heading to. > Just to remind you all:

8.1.6 IS NO LONGER SUPPORTED (al least for NT).

I had a problem two weeks ago with snapshot too old during analyze table that crashed the instance and they refused to back port a correction that exist in 8.1.7 .

Yechiel Adar, Mehish Computer Services
adary_at_mehish.co.il

> -----Original Message-----
> From: Kevin Lange [SMTP:kgel_at_ppoone.com]
> Sent: Wed, January 30, 2002 6:10 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: PMON CRASHED INSTANCE
>
> I had the same occurance on an 8.0.5 database. We had a long job running
> ,
> also a trucate, that was killed. When this happened the database core
> dumped and died. We looked it up on Metalink and found that it was a
> known
> error with that version of the database. It appears to happen with heavy
> IO
> intensive operations.
>
> Its too bad you have the same error on 8.1.6. I hope its fixed in 8.1.7
> because thats where we are heading to.
>
> -----Original Message-----
> Sent: Wednesday, January 30, 2002 9:11 AM
> To: Multiple recipients of list ORACLE-L
>
>
> 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], [4162056452],
> [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: Kevin Lange
> INET: kgel_at_ppoone.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).
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> This e-mail was scanned by the eSafe Mail Gateway
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
  INET: adary_at_mehish.co.il

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