| 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-600 and ORA-603 issues with dlm resource hash list
hmmm..HP....
do a "man -k dlm" and find something
like 'dlmstats'. It'll be a 'big' command
with lots of cmd line flags. That should
get/find you lock up/down converts.
Go to the specifics from there. Expect to find "most" of your converts are from null to shared, or vice versa...then, an order magniture (at least) fewer from shared to exclusive, etc. That's normal.
Most decent dlmstats utilities will give you rudimentary waits and statistics. See if everything seems copacetic there.
There are (although i honestly do NOT think this
is your issue) UDP internode comms parameters that might be optimized up to,
say, 256K-size
send/receive buffers.
What I'd look at is is the OS dlm version and
patching and *its* kernel settings. I know nothing about HP, so maybe one of
the truly
informed on the list can chime in on that.
If, OTOH, you are in a version of Oracle that internalizes the dlm (9i for sure, e.g.) then you'll likely have more knobs and dials to twist there.
hope these hazily recalled, partially correct, and potentially irrelevant comments prove useful, if only as an example of what *not* to do.
Ross,
The HP info for one of the two nodes is, HP-UX proteus B.11.00 U 9000/800.
As to the conversion stats, how do I determine/obtain those ?
I'll have to get the kernal setting tomorrow; I'm working from home today, so no hard-copy.
-----Original Message-----
Sent: Monday, December 17, 2001 11:40 AM
To: Multiple recipients of list ORACLE-L
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).
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 - 12:13:01 CST
 |
 |