Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: ORA-00600 on Production DB - Need advice
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,
> -----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).Received on Mon Aug 06 2001 - 12:48:31 CDT
![]() |
![]() |