RE: ORA-00600 on Production DB - Need advice

Thank you Kirti,

I saw some incorrect usages of iOraBugFinder. So, I added more explanation to iOraBugFinder page.

in fact, I wasn't going to analyze alert.log. because alert.log doesn't include detailed information. If alert.log is uploaded, it should be uploaded with Bug depth of 0. Bug depth of 0 is least selective. to narrow down returned bugs, select highest level bug depth and upload trace files instead of alert.log. Decrease Bug depth until you find your bug.

Number of returned bugs depends on bugs status and your database support licence with Oracle. If bugs are not published or you don't have database support licence, you can not see the bugs. In this case, it's recommended sending iOraBugFinder results to your support services. This may reduce your response time from support. Some of Oracle support services have started to use iOraBugFinder. If you don't want to lose time on support, upload yourself first. if you can not find your bug, send iOraBugFinder results to support. iOraBugFinder has capability of sending emails.

I'm planing some other web based db utils. if you have a product advice, don't hesitate to email me.

6/8/01 09:50:37, "Deshpande, Kirti" <kirti.deshpande_at_verizon.com> wrote:

>David,
>The ulimit looks okay to me. The value shown is equivalent to 'unlimited'.
>While you are waiting for the OWS, try getting your alert.log analyzed for
>ORA-600 at
>http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html. It
>may find something that you may not have come across. Are there any other
>trace files that may tell you more?
>
>Regards,
>
>- Kirti Deshpande
> Verizon Information Services
> http://www.superpages.com
>
>> -----Original Message-----
>> From: DBarbour_at_austin.isd.tenet.edu
[SMTP:DBarbour_at_austin.isd.tenet.edu]
>> Sent: Monday, August 06, 2001 12:58 PM
>> To: Multiple recipients of list ORACLE-L
>> Subject: ORA-00600 on Production DB - Need advice
>>
>>
>> Mondays, gotta love em, they make Fridays worth the wait. I've got a
>> production database (8.1.7, HP-UX 11.0 - 64 bit) that started throwing an
>> ora-600 when users try to log in. I've created a TAR (3 hours ago), but
>> haven't gotten any response. Here's the error:
>>
>> ERROR:
>> ORA-00600: internal error code, arguments: [kzckini: nzdsi_i], [28750],
>> [],
>> [],
>> [], [], [], [
>>
>> Metalink has a couple of messages stating that this is an OS problem
>> related to the ulimit size, availability of virtual memory, and the
>> ability
>> to create a pga. Suggested remedy is to increase the ulimit. My SA has
>> dismissed this as a cause. I've knocked all the users off, but still
>> can't
>> log in. When I run ulimit I get the following:
>> qe2n1: /u001/app/oracle/product/8.1.7/dbs>>ulimit
>> 4194303
>>
>> Any suggestions?
>>
>> David A. Barbour
>> Oracle DBA, OCP
>> AISD
>> 512-414-1002
>>
>>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Deshpande, Kirti
> INET: kirti.deshpande_at_verizon.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).