| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: ORA-00600 on Production DB - Need advice
Hey, who's to say. How did you disable the cache?
David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002
"Wong, Bing"
<bing.wong_at_Ingram To: Multiple recipients of list
ORACLE-L <ORACLE-L_at_fatcity.com>
Micro.com> cc:
Sent by: Subject: RE: ORA-00600 on Production
DB - Need advice
root_at_fatcity.com
08/06/2001 02:23
PM
Please respond to
ORACLE-L
This may not be related to your problem. My shop had problem with 8.1.7,
HP-UX 11.0 - 32 bit. We encountered memory leak bug. Oracle knew about
it
and had not had a patch yet, I think. So we disable the db handle caching.
-----Original Message-----
[mailto:DBarbour_at_austin.isd.tenet.edu]
Sent: Monday, August 06, 2001 10:58 AM
To: Multiple recipients of list ORACLE-L
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 Liststo: 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).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: 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).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
--
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 Liststo: 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 - 14:02:50 CDT
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |