oracle 7.3.4 with HPUX 11.00

[aliasgar]

Hello,

i am facing some problem in oracle 7.3.4 ,the ora trace file says
All I/O operations being done synchronously.errno=16.
although the asyncdsk driver is there in kernel and the device file has been created in /dev/async and also the privgroup file is there with dba and MLOCK entries ,
can anybody suggest some solutions for running in async mode.

Thanks/regards
Aliasgar.

[T G Manikandan]

I think it is hitting the value of MAX_ASYNC_PORTS on the kernel.

Any requests after this limit with take the synchronous way of I/O.

Increase the value to 150 or more and check the trace files.

The formula for calculating the max_async_ports as suggested by oracle is

'processes' from init.ora + number of background processes

[T G Manikandan]

kernel parameter

http://docs.hp.com/hpux/onlinedocs/939/KCParms/KCparam.MaxAsyncPorts.html

[Carlos Fernandez Riera]

If you find that message when you start the database ( alert$ORACLE_SID file) could be a missconfiguration. I use this secuence.

if [ ! -c /dev/async ] ; then
mksf -d asyncdsk -m 0 /dev/async

chown oracle7:dba /dev/async
chmod 600 /dev/async
echo dba MLOCK >> /etc/privgroup
setprivgrp -f /etc/privgroup


Also include in init$ORACLE_SID.ora the line:
use_async_io = TRUE

But you must configure kernel too, as sugested by T G.

[Brian Crabtree]

Also, it should be noted that Oracle cannot run in async mode unless you are using raw devices. I wouldn't worry about the error, as it will not cause any problems.

Brian