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

ORA-27061 waiting for async I/Os failed

Bill Thorsteinson
Honored Contributor

ORA-27061 waiting for async I/Os failed

We have a small batch job which fails frequently
with the following error.

Error = 'ORA-27061: skgfospo: waiting for async I/Os failed
HP-UX Error: 4233360: Unknown system error
Additional information: 16885271
Additional information: 4091776
Additional information: 895648
' with Vendor Error Code '27061'

Database access is with JDBC from another
system. These failures occur while reading
code tables about 20 seconds after the process
starts. If the process is restarted, the
run will complete.

The database is an Oracle 9i cluster with raw
datafiles on a SAN.

I can't find any documentation on the HP-UX
error.
3 REPLIES
Yogeeraj_1
Honored Contributor

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

hi Bill,

is disk_async_io set to true or false?

You can check it by:
SYS@mydb.mu>show parameter disk_asynch_io

NAME TYPE VALUE
____________________________________ ___________ _________
disk_asynch_io boolean FALSE
SYS@mydb.mu>


this could be a problem related to this.

revert
kind regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Bill Thorsteinson
Honored Contributor

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

Database async is set to false. This makes the
error even more confusing.

Problem seems to occur when the database has
been relatively inactive and we access a
number of small tables in quick succession.
Bill Thorsteinson
Honored Contributor

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

Problem appears to be in our SAN fabric.