Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

asynchdsk driver on HP-UX 11i for database using filesystems

SOLVED
Go to solution
Ninad_1
Honored Contributor

asynchdsk driver on HP-UX 11i for database using filesystems

Hi,

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
4 REPLIES
Steven E. Protter
Exalted Contributor
Solution

Re: asynchdsk driver on HP-UX 11i for database using filesystems

Shalom Ninad

1) 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
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Steve Lewis
Honored Contributor

Re: asynchdsk driver on HP-UX 11i for database using filesystems

As long as perms of /dev/async are 660 (-rw-rw---) you should be able to keep the owner of the file as ControlM user, but change the file group to be dba and oracle should be able to open the device as well, provided user Oracle is in dba group.

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.




Ninad_1
Honored Contributor

Re: asynchdsk driver on HP-UX 11i for database using filesystems

SEP,

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
Ninad_1
Honored Contributor

Re: asynchdsk driver on HP-UX 11i for database using filesystems

Yes the database is up now. Thanks for the solution.

Nad