- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: "mlock failed" error after changing oracle buf...
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-26-2003 05:02 AM
тАО03-26-2003 05:02 AM
"mlock failed" error after changing oracle buffer pools
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-26-2003 05:07 AM
тАО03-26-2003 05:07 AM
Re: "mlock failed" error after changing oracle buffer pools
Have a look at the below document.
http://www2.itrc.hp.com/service/cki/docDisplay.do?docLocale=en_US&docId=200000066176954
Cheers !!!
Mathew.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-26-2003 05:41 AM
тАО03-26-2003 05:41 AM
Re: "mlock failed" error after changing oracle buffer pools
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-26-2003 05:46 AM
тАО03-26-2003 05:46 AM
Re: "mlock failed" error after changing oracle buffer pools
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-26-2003 06:52 AM
тАО03-26-2003 06:52 AM
Re: "mlock failed" error after changing oracle buffer pools
rgds
Lukasz
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-26-2003 09:11 AM
тАО03-26-2003 09:11 AM
Re: "mlock failed" error after changing oracle buffer pools
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
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-26-2003 08:32 PM
тАО03-26-2003 08:32 PM
Re: "mlock failed" error after changing oracle buffer pools
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
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-26-2003 10:45 PM
тАО03-26-2003 10:45 PM
Re: "mlock failed" error after changing oracle buffer pools
# 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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-27-2003 04:12 AM
тАО03-27-2003 04:12 AM
Re: "mlock failed" error after changing oracle buffer pools
Since you're getting this error system fragmentation is occurring and this only happens when there's not enough utilization of memory.