Oracle安裝升級(jí)：升級(jí)到11.2.0.3后一系列錯(cuò)誤及修復(fù)補(bǔ)丁

following two bugs:
Document:13004894.8Wrong results with SQL_TRACE / 10046
Document:13370330.8Bug 13370330 - ORA-600 [qkeIsExprReferenced1] From Query With Virtual Column
Patch:13831007MERGE REQUEST ON TOP OF 11.2.0.3.0 FOR BUGS 12797420 13588248
This merge includes 3 fixes in the area of Mutex Contention plus addresses a regression created by one of them.   This merge can be used on either 11.2.0.3.0 or 11.2.0.3.1.   We are hoping to have them included in the 11.2.0.3.2 PSU.

在linux上安裝上述補(bǔ)丁，沒(méi)什么問(wèn)題；不過(guò)在AIX上安裝下面的patch就出現(xiàn)了一些異常。

Patches specific to IBM AIX
Patch:12412983AIX: "asynch descriptor resize" wait not necessary on AIX
Patch:12596494GENERALLY HIGHER CPU USAGE IN 11.2.0.2 THAN 10.2.0.4
Patch:13443029MEMORY LEAK FIX FOR ONLINE PATCHING / HOT PATCHING
This reduces memory usage associated with the online patching feature.
AIX 6.1 TL7 or above (such as AIX 7.1) must be installed before either installing the patch or relinking the Oracle binary for it to be effective.  If you are on an earlier version of AIX, then you may wish to consider installingPatch:10190759instead, but keep in mind that doing so will disable online patching.
在測(cè)試環(huán)境aix6106中，安裝Patch:10190759后，數(shù)據(jù)庫(kù)啟動(dòng)會(huì)產(chǎn)生ORA-07445: exception encountered: core dump [PC:0x0] [SIGILL] [ADDR:0x0] [PC:0x0] [Illegal opcode] []，后來(lái)安裝Patch:13443029就沒(méi)問(wèn)題了，可能與我的系統(tǒng)環(huán)境有關(guān)吧......
Please seethis notefrom IBM for more information.
13343438這個(gè)補(bǔ)丁：如果在安裝PSU到11.2.0.3.1時(shí)，會(huì)和PSU沖突，如果升級(jí)到11.2.0.3.0后需安裝PSU，建議先不要安裝這個(gè)patch。
如下所示：
[Oracle@p520 p13348650]$ /oracle/app/oracle/product/11.2.0.3/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir ./13348650/custom/server/13348650 -oh /oracle/app/oracle/product/11.2.0.3
Oracle Interim Patch Installer version 11.2.0.3.0
Copyright (c) 2012, Oracle Corporation.  All rights reserved.
PREREQ session
Oracle Home       : /oracle/app/oracle/product/11.2.0.3
Central Inventory : /Oracle/app/oraInventory
   from           : /Oracle/app/oracle/product/11.2.0.3/oraInst.loc
OPatch version    : 11.2.0.3.0
OUI version       : 11.2.0.3.0
Log file location : /Oracle/app/oracle/product/11.2.0.3/cfgtoollogs/opatch/opatch2012-04-01_14-50-11PM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
ZOP-40: The patch(es) has conflicts with other patches installed in the Oracle Home (or) among themselves.
Prereq "checkConflictAgainstOHWithDetail" failed.
Summary of Conflict Analysis:
There are no patches that can be applied now.
Following patches have conflicts. Please contact Oracle Support and get the merged patch of the patches :
12412983, 13343438
Following patches will be rolled back from Oracle Home on application of the patches in the given list :
12412983
Conflicts/Supersets for each patch are:
Patch : 13343438
        Conflict with 12412983
        Conflict details:
        /Oracle/app/oracle/product/11.2.0.3/lib/libserver11.a:/ksfd.o
OPatch succeeded.

如果已安裝了原補(bǔ)丁，建議回滾沖突的補(bǔ)丁，再繼續(xù)安裝PSU
/Oracle/app/oracle/product/11.2.0.3/OPatch/opatch rollback -local -oh /oracle/app/oracle/product/11.2.0.3 -id 12412983

服務(wù)器租用/服務(wù)器托管中國(guó)五強(qiáng)！虛擬主機(jī)域名注冊(cè)頂級(jí)提供商！15年品質(zhì)保障！--億恩科技[ENKJ.COM]