topic Re: "mlock failed" error after changing oracle buffer pools in Operating System - HP-UX

"mlock failed" error after changing oracle buffer pools

Lukasz Geleta — Wed, 26 Mar 2003 13:02:26 GMT

After changing some oracle parameters:

11c11
< db_block_buffers =900000
---
> db_block_buffers =1207200
14c14
< buffer_pool_recycle = ("buffers:25000","lru_latches:5")
---
> buffer_pool_recycle = ("buffers:307200","lru_latches:5")
22c22
< db_block_lru_latches = 16
---
> db_block_lru_latches = 12

we started to get the following message in the system log:

Mar 25 00:50:28 scpf vmunix: mlock_region failed..

It is being logged every 30 second. Could anybody explain what this message means and what parameters are to be altered (perhaps some kernel parameters) to get rid of this.

rgds

Lukasz

Re: "mlock failed" error after changing oracle buffer pools

Varghese Mathew — Wed, 26 Mar 2003 13:07:02 GMT

Lukasz,

Have a look at the below document.

http://www2.itrc.hp.com/service/cki/docDisplay.do?docLocale=en_US&docId=200000066176954

Cheers !!!
Mathew.

Re: "mlock failed" error after changing oracle buffer pools

Michael Steele_2 — Wed, 26 Mar 2003 13:41:30 GMT

From a search on the same error: "mlock failed"

1) Region size requested is larger than available lockable memory.

2) Region must be contigous & available memory is heavily fragmented & a contigous region large enough is not available.

You kernel parameters need to be revisited with oracle.

Re: "mlock failed" error after changing oracle buffer pools

Michael Steele_2 — Wed, 26 Mar 2003 13:46:31 GMT

Your database is too small for the server. Reduce nfile, ninode and nproc.

When you run:

sar -v 5 5

...for nproc, ninod and nfile is your numerator only ~ 10% of the denominator? They should be around 60 or 70% but this depends.

Re: "mlock failed" error after changing oracle buffer pools

Lukasz Geleta — Wed, 26 Mar 2003 14:52:49 GMT

Sorry for the lame question but what do you mean by "database is too small for the system"

rgds

Lukasz

Re: "mlock failed" error after changing oracle buffer pools

Steven E. Protter — Wed, 26 Mar 2003 17:11:44 GMT

I think its here.

setprivgrp command

/etc/privgrp

Syntax in the file is groupid function

or command line as root, example dba owns oracle

setprivgrp dba MLOCK

Has this been done? Are you current on OS patches?

SEP

Re: "mlock failed" error after changing oracle buffer pools

Yogeeraj_1 — Thu, 27 Mar 2003 04:32:42 GMT

hi lukasz,

Make sure the dba group has the MLOCK privilege.

To check if a group has the MLOCK privilege, execute:

% /usr/bin/getprivgrp

If the dba group is not listed, then set it:

% /usr/sbin/setprivgrp MLOCK

Note, the next reboot will clear this privilege. To automate this at startup,

create /etc/privgroup with the entry

dba MLOCK

This can be tested with

% /usr/sbin/setprivgrp -f /etc/privgroup

See 'man 1m setprivgrp' for more information.

Also, are there errors in your alert.log?

Regards
Yogeeraj

Re: "mlock failed" error after changing oracle buffer pools

T G Manikandan — Thu, 27 Mar 2003 06:45:38 GMT

I think some kernel value has crossed the amount of lockable memory on the system.

# echo "total_lockable_mem/D"|adb -k /stand/vmunix /dev/kmem

Just check the available lockable memory on the system

The lockable memory is inversely proportional to some of the kernel parameters.

Revert

Re: "mlock failed" error after changing oracle buffer pools

Michael Steele_2 — Thu, 27 Mar 2003 12:12:48 GMT

What does "...database too small for the system..." mean?

Since you're getting this error system fragmentation is occurring and this only happens when there's not enough utilization of memory.