Ynt: ORA-600 and iOraBugFinder available

From: unal-bilisim <danisment.unal_at_unal-bilisim.com>
Date: Sun, 20 May 2001 04:24:25 -0700
Message-ID: <F001.00308C2C.20010520041521@fatcity.com>

Hi,

iOraBugFinder at level 3 generated following bugs: for ora_3858.trc:
- 700613 PL/SQL PROCEDURE FAILS WITH ORA-600 [733] [11976048] [PGA HEAP] - 801644 INSTANCE FAILS TO RESTART (WITH ORA-600 [733]) AFTER UNCLEAN SHUTDOWN for ora_3912.trc:
- same bugs

your "alter database open" causes these errors. Bug#801644 matches your case. This bug occurs on Digital Unix.
I'm pasting relevant part of this Bug#801644:

It looks like we are hitting this alert because the value of SHMMAX is low (like 4 MB) in your machine. I understand that SHMMAX is 4 MB by default in DEC machine, and skgmqsubareasize() returns the value of SHMMAX. As this is smaller than the size requested by kcratr() who wants SSTTRBUF amount of memory ksm asserts 733. Please try to increase your SHMMAX and see if the problem goes away.

01/22/99 12:39 am *** (CHG: Sta->92) Yep, increasing SHMMAX sorted the problem out. Thanks.

A bit strange that the low SHMMAX value is only a problem after a shutdown abort, but there you go.

Original Message ----- To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Sunday, May 20, 2001 12:50 PM

> I was unsuccessfully trying to analyze (on this URL) one of the traces
> generated due to ORA-600 by one of TEST Database.
> This ORA-600 looks very funny to me. I just changed the
> log_archive_dest parameter to a non-existing destination and ORA-600 was
> there to greet me.
> Platform TRU64 Unix 4.0F Oracle 8.1.6.0.0
> Can someone try to simulate (at your own risk).
> However trace file is attached and sent separately to
> suport_at_unal-bilisim.com. If anybody is interested, I can send directly.
>
> Appreciate your opinion, suggestions and ideas....
>
> Regards,
> Rajesh
>
> -----Original Message-----
> Gazi Unal (Unal Bilisim)
> Sent: Saturday, May 19, 2001 7:45 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi Gurus,
>
> I developed a new web based product named iOraBugFinder.
>
> iOraBugFinder scans Oracle's alert log files and ORA-600/ORA-7445 trace
> files, extracts relevant information from them and generates URL links
> to relevant bugs, notes, forums at Metalink.
>
> It's at
> http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html
>
> regards...
>
> --
> Use itrprof SQL Analyzer.
>
> itrprof SQL Analyzer is a web based tool which analyzes
> SQL_TRACE/Event10046 trace files of Oracle,
> finds bottlenecks and offersinformation on how to tune them.
>
> No download, no setup, just click
> http://www.unal-bilisim.com/products/itrprof/itrprof.html
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Danisment Gazi Unal (Unal Bilisim)
> INET: danisment.unal_at_unal-bilisim.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: Rajesh Dayal
> INET: Rajesh_at_ohitelecom.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: unal-bilisim
  INET: danisment.unal_at_unal-bilisim.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 Sun May 20 2001 - 06:24:25 CDT