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

oracle 7.3.4 with HPUX 11.00

aliasgar
Valued Contributor

oracle 7.3.4 with HPUX 11.00

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.
aliasgar
4 REPLIES
T G Manikandan
Honored Contributor

Re: oracle 7.3.4 with HPUX 11.00

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

Re: oracle 7.3.4 with HPUX 11.00

Carlos Fernandez Riera
Honored Contributor

Re: oracle 7.3.4 with HPUX 11.00

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.
unsupported
Brian Crabtree
Honored Contributor

Re: oracle 7.3.4 with HPUX 11.00

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