Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: ORA-600 and ORA-603 issues with dlm resource hash list
just out of curiosity, what flavor of Unix? What are your dlm lock conversion statistics? what are your OS kernel settings for udp buffers at?
-----Original Message-----
Sent: Friday, December 14, 2001 6:10 PM
To: Multiple recipients of list ORACLE-L
Hello,
Anyone out there having fun on OPS with the dlm resource hash list ORA-600 and ORA-603 errors. We are getting them more frequently with increased load on the system. See below for some particulars. The really bad part is having a critical process die with the 603 error.
applicable init.ora parameters:
lm_locks = 180000 lm_ress = 120000 dml_locks = 7250 _lm_direct_sends = lkmgr
alertlog error:
Thu Dec 13 14:34:36 2001
Errors in file /u01/app/oracle/admin/IPMP/bdump/p000_17980_ipmp2.trc:
ORA-00600: internal error code, arguments: [526], [3339519528], [1], [dlm
resour
ce hash list], [38628], [3338960552], [34261], []
Thu Dec 13 14:34:38 2001
Errors in file /u01/app/oracle/admin/IPMP/bdump/p000_17980_ipmp2.trc:
ORA-00600: internal error code, arguments: [600], [], [], [], [], [], [], []
Thu Dec 13 14:34:41 2001
Errors in file /u01/app/oracle/admin/IPMP/bdump/p000_17980_ipmp2.trc:
ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [600], [], [], [], [], [], [], []
Thank you,
Paul Sherman
DBA
voice - 781-501-4143 (office)
fax - 781-278-8341 (office)
email - psherman_at_elcom.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sherman, Paul R.
INET: PSherman_at_elcom.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).
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 Dec 17 2001 - 11:25:07 CST