Chinaunix首页 | 论坛 | 博客
  • 博客访问: 1123243
  • 博文数量: 251
  • 博客积分: 8431
  • 博客等级: 中将
  • 技术积分: 2699
  • 用 户 组: 普通用户
  • 注册时间: 2007-07-22 16:24
文章分类

全部博文(251)

文章存档

2016年(2)

2015年(5)

2014年(4)

2013年(10)

2012年(8)

2011年(14)

2010年(20)

2009年(33)

2008年(51)

2007年(104)

分类: Oracle

2007-11-15 09:45:05

最近运行Oracle的服务器只要工作任务非常大IO占用达到100%时间过长后,实例就会出现down的情况。查看alert.log后系统报:
Errors in file /home/oracle/admin/****/bdump/****_ckpt_1085840.trc:
ORA-00206: error in writing (block 3, # blocks 1) of control file
ORA-00202: control file: '/****/control03.ctl'
ORA-27072: File I/O error
IBM AIX RISC System/6000 Error: 22: Invalid argument
Additional information: 8
下面是Oracle给出的解决方案:(竟然是Oracle与AIX 5300-05的一个IO协调BUG,鄙视他们一下)
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. 
Please follow these steps:
For the IBM AIX fix :

After installing AIX 5.3 Technology Level 5, IBM recommends installing the fix for AIX APAR IY89080. The fix is available as 5300-05-01 as well as 5300-06 is available which is cumulative (IY89080 is included).

To obtain the interim fix,
1. Navigate to
2. Select the primary ifix location
3. Select the ifix for iy89080

To obtain the Service Pack (when available)
1. Navigate to
2. Select AIX 5.3 under Fix Bundles
3. Select Service Pack 5300-05-01
For systems running ML06 and above, you only need to install Oracle patch.
For the Oracle fix :

1. Navigate to and sign into MetaLink
2. Select the "Patches & Updates" tab
3. Select the "Simple Search" link and enter Patch Number 5496862, select Platform AIX5L Based Systems (64-bit) and desired Oracle version
4. Proceed to download the desired patch.
If the patch is unavailable for your database version, please contact Oracle Support for assistance.
Refer to  for a list of platform that are affected by this issue.
阅读(997) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~