- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle async_config errno=11
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
тАО05-07-2004 03:35 AM
тАО05-07-2004 03:35 AM
We are running Oracle 9.2.0.4 on an Itanium box with HP-UX 11.23. The database appears to be running OK but I am getting lots of trace files generated each day which state:
Ioctl ASYNC_CONFIG error, errno = 11
Does anyone have any idea what is causing this?
Ronnie
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-07-2004 04:34 AM
тАО05-07-2004 04:34 AM
Re: Oracle async_config errno=11
Do you have /etc/privgroup file? IT should have following entry.
dba MLOCK
Where dba is group which runs oracle. If not do setprivgrp dba MLOCK.
Also you should have /dev/async device file with appropriate rights.
And lock_sga' set to true in the Oracle init file
Anil
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-07-2004 05:10 AM
тАО05-07-2004 05:10 AM
Re: Oracle async_config errno=11
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-07-2004 06:18 AM
тАО05-07-2004 06:18 AM
SolutionAs Anil wrote, lack of MLOCK priv could be one reason for failure.
You are using RAW devices right?
If you are using regular filesystems for their Oracle database, they'll get this error due to a bug in Oracle. It does not have any performance impact, but if they want to get rid of the messages, they should just rename /dev/async, so that Oracle does not find that device at all. (you do have a /dec/async no?)
If you're out of lockable_mem, that's another reason.
Check metalink for more input on async and this error.
Hein
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-07-2004 06:37 AM
тАО05-07-2004 06:37 AM
Re: Oracle async_config errno=11
And thanks for the responses. I already have the dba mlock set and checked. The asynch_disk_io = false in the init.ora since we are using filesystems. There are no other errors in the trace files. I will try setting lock_sga and see if that helps.
Ronnie
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-07-2004 07:54 AM
тАО05-07-2004 07:54 AM
Re: Oracle async_config errno=11
Does any other app in your systems need /dev/async?
Hein.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-09-2004 12:39 PM
тАО05-09-2004 12:39 PM
Re: Oracle async_config errno=11
To fix error the problem,
- setprivgrp dba MLOCK
- setprivgrp oracle MLOCK
- setprivgrp oinstMLOCK
Where oinst is the install user and dba and oracle are the groups for the connecting processes. Need all entries.
I noticed the IO profile changed straight away (vxstat).
I do have a question. Does the error mean that oracle has switch off async-io ? I did see the io profile change but I did not see any performance gain.
Viktor
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-09-2004 12:58 PM
тАО05-09-2004 12:58 PM
Re: Oracle async_config errno=11
Just rambling...
The benefits of Async IO are marginal for your average Oracle solution. Improvements are in the order of 1 - 3% cpu time (system) for systems that do 100% Oracle work and are relatively heavy on the IO (think TPC). Toss some real applicition code in the mix and make Oracle do a little more parsing and computing and the benefit becomes really small.
You will need a very reproducable test to prove a benefit expressed in % cpu or response time. Next best are observations like Viktor's where an IO pattern change is seen. For example you might notice that the File-system pre-reads for REDOLOG io dissappears, leaving only writes. An other alternative is to normalize (system) cpu usage with business transactions. How much cpu per 1000 transactions? Did that change before/after Async was activated? And finally, you could run an application test before adn after. But typically a reproducable tests is not terribly repersentative of real life.
In my mind the biggest benefits of RAW devices and Async IO are knowing that as a DBA you did everthing you could possibly do to optimize the system.
Hein.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-12-2004 07:53 AM
тАО05-12-2004 07:53 AM
Re: Oracle async_config errno=11
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-12-2004 09:39 PM
тАО05-12-2004 09:39 PM
Re: Oracle async_config errno=11
I have the same problem, but although I try to set MLOCK with
#setprivgrp dba MLOCK
it does not give the MLOCK privilige.
When I check this by
#getprivgrp dba
it gives:
dba:
What can cause not giving the MLOCK privilige?
Thanks..
Evren