ORA-00604,ORA-01115,ORA-01110,ORA-27091,ORA-27072,IBM AIX RISC System/6000 Error
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: 5496862problem 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博客 ” ，链接：https://blog.itpub.net/67/viewspace-1003216/ ，如需转载，请注明出处，否则将追究法律责任。
最新文章
- 11gR1 optimizer key changes
- SQL PERFORMANCE ANALYZER, a great tool for upgrade testing tuning and benchmark check
- ASCII in oracle, masking power on
- On Dynamic Sampling
- tnsping: NL-00605: national language initialization failed sqlplus Error 5
- push_pred, a powerful hint to speed up you inline view query 10X times
- A taste of SQL Performance Analyzer in oracle 11g
- steps to do real time apply in oracle 11g
- A more detailed threshold we should monitor on UNIX side
- V$sort_usage, where is the definition?
