async I/O

[Sid Bytheway]

My /dev/async is missing on HPUX 11, we cannot start oracle 8.0.4. What is the procedure for creating this device, it must be more than running mknod, because I ran that and we are still having problems.

[James A. Donovan · Accepted solution]

Is the value of the fs_async kernel parameter 0 or 1? If 0, set it to 1 and re-compile the kernel.

[Sid Bytheway]

fs_async is already set to 1. I believe this device used to exist, we have run oracle 8.0.4 prior to this without a problem. Now when we try to start it, it says, there is no /dev/async. I ran mknod to recreate it, but oracle won't start. Oracle 8.0.5 is running, however.

[James A. Donovan]

Ok, since you have fs_async set, then try the following to re-create the device:

#mknod /dev/async c 101 0x000000
#chown oracle:dba /dev/async
#chmod o-rw /dev/async

If that fails, try checking for OS patches involving asynch i/o.

Is there a specific error message given in the databases alert_log? What are the init.ora parameters for your database?

[Rammig Claus]

Hi Cliff,

fs_async is only for HFS-Filesystem.

If you want to enable async io, you need:
- /dev/async device
- async-io driver in the kernel
- MLOCK-Privileg

Regards
Claus