Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: ORA-600 and iOraBugFinder available
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:
A bit strange that the low SHMMAX value is only a problem after a
shutdown
abort, but there you go.
> 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: 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).Received on Sun May 20 2001 - 08:34:16 CDT