这个补丁影响的范围还是比较大的

我们先看看这个补丁的描述

   Bug 5496862  AIX: Mandatory patch to use Oracle with IBM Technology Level 5 (5300-5)
   Bug 5496862  IO READING PROBLEMS AFTER INSTALLING IBM TECHNOLOGY LEVEL 5 (5300-05)

影响的版本，基本上是跑在5305上所有的9i以及10g的版本都需要打这个补丁，而且是强制要求打这个补丁：

   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.

以下是详细描述信息

   This is a mandatory patch needed to use Oracle with
   IBM Technology Level 5 (5300-05). Without it various
   IO errors can be reported such as:

     ORA-1115: IO error reading block from file ? (block # ?)
     ORA-1110: data file #: name
     ORA-27091: skgfqio: unable to queue I/O
     ORA-27072: skgfdisp: I/O error

     Bad header found during preparing block for write

     Fractured block found during preparing block for write

     DBW1: terminating instance due to error ORA-600: [kcbzpb_1]

以下是解决方法，需要aix的补丁以及Oracle的补丁，在新的5305版本中，aix补丁已经默认打进去了，如果还没有打进去，可能需要手工打一下。

   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 now as an interim fix and will be included
   in the TL5 Service Pack 1
   which is scheduled for release later this month.

   To obtain the interim fix,
   1. Navigate to http://www14.software.ibm.com/webapp/set2/sas/f/aix.efixmgmt/fixes.html
   2. Select the primary ifix location
   3. Select the ifix for iy89080

   To obtain the Service Pack (when available)
   1. Navigate to http://www.ibm.com/servers/eserver/support/unixservers/aixfixes.html
   2. Select AIX 5.3 under Fix Bundles
   3. Select Service Pack 5300-05-01

   For the Oracle fix :
   1. Navigate to http://metalink.oracle.com/ 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. 

   Please, note that the patch is not available for all Oracle 9i, 10gR1 and 10gR2
   releases yet.
   If the patch is unavailable for your database version, please contact Oracle Support
   for assistance.

发表于 2007-06-08 14:45:02 目录：操作系统|Os, 数据库|Oracle, Oracle 日常管理, AIX操作系统, 所有|All Blogs [RSS 2.0] 你可以发表评论, 或者从您的网站 trackback