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

刚刚IMP了大约60多万的数据库到Oracle中,突然就出现了错误.
数据库异常的关闭,再次打开的时候,报了ORA-27061错误．

# su - oracle
$ export ORACLE_SID=oracle9i
$ sqlplus /nolog

SQL*Plus: Release 9.2.0.7.0 - Production on Sat Jan 5 17:01:50 2008

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

SQL> conn / as sysdba;
Connected to an idle instance.
SQL> startup
ORACLE instance started.

Total System Global Area 1377274120 bytes
Fixed Size                   743688 bytes
Variable Size             738197504 bytes
Database Buffers          637534208 bytes
Redo Buffers                 798720 bytes
Database mounted.
ORA-27061: skgfospo: waiting for async I/Os failed
IBM AIX RISC System/6000 Error: 22: Invalid argument
ORA-27061: skgfospo: waiting for async I/Os failed
IBM AIX RISC System/6000 Error: 22: Invalid argument

我当前的aio设置
                                                   [Entry Fields]
MINIMUM number of servers                          [20]                     #
MAXIMUM number of servers per cpu                  [60]                     #
Maximum number of REQUESTS                         [4096]                   #
Server PRIORITY                                    [39]                     #
STATE to be configured at system restart            available              +
State of fast path                                  enable                 +

将AIX的aio进行优化
maxreqs    12280     Maximum number of REQUESTS               True

maxservers 160       MAXIMUM number of servers per cpu        True

minservers 40        MINIMUM number of servers                True

再次IMP，到1.4M的时候又报了ora-27061的错误

搜索IBM的官方网站:
http://www-1.ibm.com/support/docview.wss?uid=isg1IZ03260

得知这是AIX5306的一个bug

# oslevel -r
5300-06

此补定是：
IZ03260: LIO_LISTIO FAILS TO UPDATE AIO CONTROL BLOCKS ON ERROR APPLIES TO AIX 5300-06

对应的是 5300-06 Service Pack 4

打完补定后,问题消失:)