ORA-27061 waiting for async I/Os failed

[Bill Thorsteinson]

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.

[Yogeeraj_1]

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

[Bill Thorsteinson]

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]

Problem appears to be in our SAN fabric.