RE: ORA-600 and ORA-603 issues with dlm resource hash list

From: Mohan, Ross <MohanR_at_STARS-SMI.com>
Date: Mon, 17 Dec 2001 09:25:07 -0800
Message-ID: <F001.003DE061.20011217084022@fatcity.com>

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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Mohan, Ross
INET: MohanR_at_STARS-SMI.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------