- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: asynchdsk driver on HP-UX 11i for database usi...
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
тАО12-13-2005 11:24 PM
тАО12-13-2005 11:24 PM
We have Oracle 9.2.0.5 installed on HP-UX 11i.
We are cloning a database on this box. After the database is brought up and we are trying to create a controlfile to trace we are getting following error
"Ioctl ASYNC_CONFIG error, errno = 1"
After going through some docs on the metalink and searching through some other posts on this forum here is my understanding and the questions I have.
My understanding :
1. asyncdsk driver can be configured on HP-UX to allow async io, MLOCK has to be allowed for dba group (can be done using setprivgrp)and ownership of /dev/async needs to be oracle:dba
2. Oracle can use async io by setting init parameter to enable the same.
Now in metalink doc id - Note:139272.1 (HP-UX: Asynchronous i/o) two things are mentioned -
a) on HP-UX aio is *only* possible on a raw device
b) Oracle server processes (background and foreground) will attempt to open /dev/async if the async driver is enabled in the HP-UX kernel, regardless of init.ora settings.
Now my problem and questions are that
If I have a HP-UX server on which
a)asyncdsk driver has been configured as it is required by some other software (ControlM)
b)I have a database not using raw volumes but using filesystems
1) How do I resolve the error I mentioned "Ioctl ASYNC_CONFIG error, errno = 1" and bring up the database ?
2) In database I have set the init param disk_asynch_io=FALSE , still why does Oracle try to use the async driver ?
3) Do I need to still allow MLOCK for dba group
4) Do I need to change ownership of /dev/async to oracle:dba - Wont it affect the other software (ControlM)
PLEASE help me.
Thanks,
Ninad
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-14-2005 12:04 AM
тАО12-14-2005 12:04 AM
Solution1) Set the async driver up. setprivgroup file I think.
2) Oracle needs async change that back.
3) Yes
4) No change should be required.
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
тАО12-14-2005 12:22 AM
тАО12-14-2005 12:22 AM
Re: asynchdsk driver on HP-UX 11i for database using filesystems
Try that. If it doesn't work, then you could also try adding the ControlM user to group dba (less secure) or even chmod 666 /dev/async (very insecure).
Yes you still need to allow MLOCK for dba group.
If user oracle cannot be in dba group, then create a new group (e.g called async), put put oracle and ControlM user into it by adding the usernames to the new line in /etc/group, then chgrp /dev/async to that new group and re-try.
You must regression test this first, for both oracle and ControlM.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-14-2005 12:31 AM
тАО12-14-2005 12:31 AM
Re: asynchdsk driver on HP-UX 11i for database using filesystems
Thanks for the quick reply, but I wish I could have more explained answer. Anyway I will try granting MLOCK to dba group , asyncdsk is already configured - which is why all the problem started for me , I wont be changing the ownership of /dev/async - it currently is bin:bin .
I am not quite satisfied with the answer for point 2)In database I have set the init param disk_asynch_io=FALSE , still why does Oracle try to use the async driver ?
for which you have replied - " Oracle needs async change that back." Because we are using database using filesystems and not raw volumes - do I still need to set disk_async_io to TRUE ? What is the logic behind it ?
Will assign you points after I try the solution , bcos if it works then .. ofcourse I will give u 10 :) In the mean time can you pls throw more light on the above.
Thanks.
Ninad
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-14-2005 08:35 PM
тАО12-14-2005 08:35 PM
Re: asynchdsk driver on HP-UX 11i for database using filesystems
Nad