oracle 11g升级步骤,Oracle11gR2单机升级步骤

如果Oracle 11g R2单机采用文件系统：步骤：直接升级DB SOFT、数据字典、安装PSU、安装one-off patch等。如果单机采用GRID+ASM：

如果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 专题页面 ?tid=12

， 本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉 本文系统来源：php中文网