Re: ORA-600 and iOraBugFinder available

Hi,

it's a a good news...

and,

It's not possible to suggest a bug number. but, bugs are ordered by metalink's score. to narrow down problem, select high level search depth and read high scores first.

Rajesh Dayal wrote:

> Sorry for the delay.....
> Yes you are quite right on this. SHMMAX had a value of 40 M, which I
> changed to suggested
> value and things are OK now.
> We would be benefited more, if these various levels are
> explained to list. I tried once
> more generating report through the Tool but it doesn't suggest me about
> any bug no. directly.
> Hope this will start working soon perfectly. I am sure this tool
> would be of great help
> in crisis. Good work done ;-))
>
> Thanks again,
> Regards,
> Rajesh
> -----Original Message-----
> From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of
> unal-bilisim
> Sent: Sunday, May 20, 2001 4:15 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Ynt: ORA-600 and iOraBugFinder available
>
> 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).

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