- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: oracle 8.1.6 ioctl error and MLOCK
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
тАО06-19-2002 06:02 PM
тАО06-19-2002 06:02 PM
Reading the board indicates this seems to be either a problem with oracle not having access to MLOCK or oracle expecting async io??.
Ive checked my config:
L class servers/hpux 11.00/oracle 8.1.6
databases on raw disk
fs_async is not set in the kernel (set to 0)
no MLOCK privledges for dba
Can I run setprivgrp with oracle running, or do I need to bring down the db's ? (No real test env with oracle on it)
If I set up the MLOCK priv's will I then run into further problems with fs_async? Is Oracle expecting fs_async to be set to 1??
Any comments appreciated.
Regards
Steph
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-19-2002 08:08 PM
тАО06-19-2002 08:08 PM
Re: oracle 8.1.6 ioctl error and MLOCK
hi
U have to add asyncdsk to kernel and do a setprivgrp to the oracle group.
in my server it is like this
crw-rw-rw- 1 root sys 101 0x000000 Oct 11 2000 async
crw-rw-rw- 1 bin bin 101 0x000000 Oct 11 2000 asyncdsk
setprivgrp "oracle group" MLOCK and u have to restart oracle. then oracle with use async IO. i had a same experience with sybase at my site once.
this link will help u
http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0x7e97abe92dabd5118ff10090279cd0f9,00.html
http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0xd0b1ba808b46d611abda0090277a778c,00.html
Cheers
CTK
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-19-2002 08:21 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-19-2002 08:36 PM
тАО06-19-2002 08:36 PM
Re: oracle 8.1.6 ioctl error and MLOCK
On checking my system I have:
initSID.ora set to disk_asynch_io = TRUE
and /dev/async and /dev/asyncdsk created and the correct drivers installed in the kernel.
However MLOCK privs are not set and the system has multiple ora_dbwN processes.
TG: The doco implies that multiple dbwr processes should be used on filesystems not raw devices - is this correct?
Thanks All
Steph
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-19-2002 09:44 PM
тАО06-19-2002 09:44 PM
Re: oracle 8.1.6 ioctl error and MLOCK
It is not that Multiple DBWR's cannot be used on raw devices,but oracle does not recommend the use of both multiple DBWr's and aio on raw devices.
As aio cannot be used on a file system, the use of multiple DBWR's is on the file system.
You have to set the MLOCK privilege so that that user ID can use the async driver.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-19-2002 10:03 PM
тАО06-19-2002 10:03 PM
Re: oracle 8.1.6 ioctl error and MLOCK
You are right!
When the async i/o is used,
eventhough you set
db_writer_processes to multiple value,only one
DBWR process is started.
async I/O is always preferred over the use of multiple DBWRs.
On older version of Oracle you cannot set multiple DBWR processes when you are using aio.
Recent version start only one DBWR eventhough the parameter is set and you are using aio.
Thanks