ITPub博客

首页 > 数据库 > Oracle > ORA-00604,ORA-01115,ORA-01110,ORA-27091,ORA-27072,IBM AIX RISC System/6000 Error

ORA-00604,ORA-01115,ORA-01110,ORA-27091,ORA-27072,IBM AIX RISC System/6000 Error

原创 Oracle 作者:netbanker 时间:2008-05-02 07:06:27 0 删除 编辑
ORA-00604: error occurred at recursive SQL level 1
ORA-01115: IO error reading block from file 1 (block # 81)
ORA-01110: data file 1: '/u03/oradata/rmspprd/system01.dbf'
ORA-27091: skgfqio: unable to queue I/O
ORA-27072: skgfdisp: I/O error
IBM AIX RISC System/6000 Error: 5: I/O error[@more@]

but when checked filesystem and datafile, it is healthy and no single block of errors.

DBVERIFY - Verification complete

Total Pages Examined : 4096000

Total Pages Processed (Data) : 1691912

Total Pages Failing (Data) : 0

Total Pages Processed (Index): 2365756

Total Pages Failing (Index): 0

Total Pages Processed (Other): 19296

Total Pages Processed (Seg) : 0

Total Pages Failing (Seg) : 0

Total Pages Empty : 19036

Total Pages Marked Corrupt : 0

Total Pages Influx : 0

Highest block SCN : 3276801276104 (762.4036196552)

check:

IO Interoperability Issue between IBM ML05 and Oracle Databases ( Note:390656.1)

All Oracle 9i, 10gR1 and 10gR2 Database Customers 
running on AIX 5L V5.3 Technology Level 5 (TL 5300-05) 
must install an IBM AIX fix and an Oracle Database patch
to bring the OS and Database environments to the correct levels. 
install patch: 5496862
problem solved, has hit at least 10 bugs for the past 2 months using AIX 
is it IBM on purpose to compete with it's DB2? :-)

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/67/viewspace-1003216/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2008-06-12

  • 博文量
    20
  • 访问量
    90554