ORA-00600 on Production DB

From: <DBarbour_at_austin.isd.tenet.edu>
Date: Mon, 06 Aug 2001 09:43:21 -0700
Message-ID: <F001.00361AFB.20010806095812@fatcity.com>

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:
INET: DBarbour_at_austin.isd.tenet.edu

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 - 11:43:21 CDT

ORA-00600 on Production DB - Need advice