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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]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 <[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: 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).
Re: ORA-600 and iOraBugFinder available
Danisment Gazi Unal (Unal Bilisim) Sun, 20 May 2001 06:52:24 -0700
- ORA-600 and iOraBugFinder available Rajesh Dayal
- RE: ORA-600 and iOraBugFinder avai... Rajesh Dayal
- Danisment Gazi Unal (Unal Bilisim)