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

ORA-27061 : waiting for async I/Os failed

SOLVED
Go to solution
Gerrit_1
Advisor

ORA-27061 : waiting for async I/Os failed

Hi,

We have a small batch cycle that sometimes fails ( a rerun mostly finishes ok ) with an error : " ORA-27061 : waiting for async I/Os failed "

Cycle runs on a itanium / HPUX 11.23 :

root/svuxpc11#model
ia64 hp server rx4640
root/svuxpc11#uname -a
HP-UX svuxpc11 B.11.23 U ia64 1465226551 unlimited-user license

Any suggestestions ?

Tx ...
I have a vision...... a television
4 REPLIES
Steven E. Protter
Exalted Contributor

Re: ORA-27061 : waiting for async I/Os failed

Shalom,

We get to guess the version of Oracle here I suppose.

Since it works some of the time and not others, I would say that it falls into one of the following categories:

OS problem with async I/O needs to be resolved with an OS patch

I/O is overloaded and the process is not getting an answer fast enough.

Oracle problem needs to be resolved by installing an oracle patch.

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
Gerrit_1
Advisor

Re: ORA-27061 : waiting for async I/Os failed

Hi ,
9.2.0.7.0 is the oracle_version.

I have a vision...... a television
Hein van den Heuvel
Honored Contributor
Solution

Re: ORA-27061 : waiting for async I/Os failed

Why run that old Oracle on a new box? Oh well.

I suspect it is running into a maximum number of async IOs and either OS or DB not handling that correctly.

Seems Oracle failed to recognize that an issues of an IO async failed. Then later when it tries to wait for the IO to be done, that fails because it was never started.

Slightly different DB loads an IO response times could make it run into this, or stay clear.
Did you recently increase the SGA? That might allow for more IOs to be queued.


It would be best if you could throttle the DB, but I suspect that the easiest workaround is to increase the maximum number of async IOs the OS can handle.
See man mage for aio_max_ops.

http://docs.hp.com/en/B2355-60105/aio_max_ops.5.html


hth,
Hein.


Oviwan
Honored Contributor

Re: ORA-27061 : waiting for async I/Os failed

hey

as an interim solution you could disable async I/O. set DISK_ASYNC_IO to false

regards