我们先看看这个补丁的描述
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.
评论 (7)


