Paul, I missed your original thread on this problem,
but I suggest you call support. The problem you are
seeing may be related to bug# 2009263.
I am making some assumptions that you are running on
HP 64bit and you are running on either 8.1.6 or 8.1.7.
There are some little things you might need to know.
In 8.1.7 lm_lock and lm_ress parameters can't be set
using the syntax you have used below and the
_lm_direct_sends parameter should be set to "all"
which is the default or just removed. The bug 1189628
only appears to cause problems with tru64 or HP 64bit
OPS and there is a patch for the problem. Setting
_lm_direct_sends forces Oracle to use only 1 message
channel and this can become performance issue.
Hope this helps,
Scott
- "Mohan, Ross" <MohanR_at_STARS-SMI.com> wrote:
> 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
>
> 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).
Do You Yahoo!?
Check out Yahoo! Shopping and Yahoo! Auctions for all of
your unique holiday gifts! Buy at
http://shopping.yahoo.com
or bid at
http://auctions.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Scott
INET: oraracdba_at_yahoo.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).
Received on Mon Dec 17 2001 - 16:36:50 CST