1. 首页
  2. IT资讯

ORA-01115 ORA-01110 ORA-27091 ORA-27072 on AIX 5L

今天遇到错误
ORA-01115: IO error reading block from file 11 (block # 1024771)
ORA-01110: data file 11: ‘/oradata/ufida/NNC_DATA03_02.dbf’
ORA-27091: unable to queue I/O
ORA-27072: File I/O error
IBM AIX RISC System/6000 Error: 5: I/O error
Additional information: 3
 
然后查看日志并没有错误记录,同时找出这个块的所在的表,进行了全表扫描,为发现错误,同时进行了DBV也未发现损坏的块。
然后进入METALINK找到如下文章:
 
 
ORA-01115 ORA-01110 ORA-27091 ORA-27072 Error: 5: I/O error [ID 559697.1]修改时间:2011-11-18类型:PROBLEM状态:PUBLISHED优先级:2
注释 (0)
 
In this Document
  Symptoms
  Changes
  Cause
  Solution
  References
Applies to:Oracle Server – Enterprise Edition – Version: 9.2.0.8and later   [Release: 9.2 and later ]
IBM AIX on POWER Systems (64-bit)
***Checked for relevance on 16-Feb-2011***
IBM AIX Based Systems (64-bit)SymptomsAfter patching the OS with Patch IBM Technology Level 6 (5300-06) or Level 7 (5300-07), the application log started reporting the following errors:
ORA-01115: IO error reading block from file (block # )
ORA-01110: data file :
ORA-27091: skgfqio: unable to queue I/O
ORA-27072: skgfdisp: I/O error
IBM AIX RISC System/6000 Error: 5: I/O error
– The errors are not reported in the alert log file.
– Running dbv against datafiles from the error messages shows no errors.
– All the mandatory OS patches are applied.
– Oracle patch for Bug 5496862- IO READING PROBLEMS AFTER INSTALLING IBM TECHNOLOGY LEVEL 5 (5300-05) was installed before patching the OS.
ChangesPatch IBM Technology Level 6 (5300-06) or higher was applied to the OS.CauseThe value of maxreqs (4096) was too low. This asynchronous I/O parameter specifies the maximum number of asynchronous I/O requests that can be outstanding at any one time and has as default value 4096.SolutionIncrease maxreqs to a value greater than or equal to 8192.Steps:
1. run aioo -a command to double check current setting for aio0 device
2. run aioo -o maxreqs= to set maxreqs dynamically
3. chdev -l aio0 -a maxreqs= -P to set the value of maxreqs permanently for next reboot
4. run aioo -a to confirm change
5. restart oracle
NOTE: Values that fixed the errors: 8192, 16384 or 32768.
应该就是这个BUG引起的然后查看了Bug 5496862,这个BUG在10.2.0.3中已经修复,而我们的数据库是10.2.0.4,所以不存在这个问题。

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

主题测试文章,只做测试使用。发布者:深沉的少年,转转请注明出处:http://www.cxybcw.com/183282.html

联系我们

13687733322

在线咨询:点击这里给我发消息

邮件:1877088071@qq.com

工作时间:周一至周五,9:30-18:30,节假日休息

QR code