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-----
unal-bilisim
Sent: Sunday, May 20, 2001 4:15 PM
To: Multiple recipients of list ORACLE-L
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 <[EMAIL PROTECTED]>
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
> [EMAIL PROTECTED] 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: [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: Rajesh Dayal
> 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: unal-bilisim
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: Rajesh Dayal
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).
