Oracle 11g R2單機升級步驟

如果Oracle 11g R2單機採用檔案系統：
步驟：
直接升級DB SOFT、資料字典、安裝PSU、安裝one-off patch等。
如果單機採用GRID+ASM：
步驟：
升級前安裝patch、升級GI、升級DB SOFT、資料字典、安裝PSU、安裝one-off patch等。
 
升級前安裝的patch：
對於基礎版本為11.2.0.1,安裝的patch為：PATCH 9413827 Or PATCH 9706490 if on AIX, Solaris or HP
對於基礎版本為11.2.0.2,安裝的patch為：PATCH 12539000
 
需安裝的one-off patch：
 
Patches relevant for all platforms：
Patch:13656236
 Merge patch fixing the following two bugs:
Document:13004894.8 Wrong results with SQL_TRACE / 10046
?Document:13370330.8 ORA-600 [qkeIsExprReferenced1] From Query With Virtual Column
Patch:13705338
Wrong results on iot secondary index through join
 
Patch:13831007
Merge patch fixing the following bugs:
?Unpublished Bug 12797420: MUTEX X WAITS WITH TWO JVMS
?Document:13588248.8 Library cache mutex contention for objects with very many library cache locks
NB: This merge can be used on either11.2.0.3.0 or 11.2.0.3.1.   We are hoping to have the fixes included in the 11.2.0.3.2 PSU.
Patches specific to IBM AIX：
Patch:12412983
 AIX: "asynch descriptor resize" wait not necessary on AIX
 
Patch:12596494
GENERALLY HIGHER CPU USAGE IN11.2.0.2 THAN 10.2.0.4
 
Patch:13443029
MEMORY 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.
Please see Document:1260095.1 for more information.

更多Oracle相關資訊見Oracle 專題頁面 http://www.bkjia.com/topicnews.aspx?tid=12