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

netbanker發表於2008-05-02
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/,如需轉載,請註明出處,否則將追究法律責任。

相關文章