oracle RAC CRS和DB从PSU 10.2.0.4.2 升级到 10.2.0.4.11的步骤

shunzi

现在数据库版本为10.2.0.4.2的rac，想要升级到4.11，应该有几个步骤呢？1，crs  4.2 --- crs 4.4
2，db   4.2 --- db  4.4
3，db   4.4 --- db  4.11

这种方法对不？ 如果不对，还请告知下升级所需的psu号，非常感谢。


==================================================================================================

comment

CT 的需求是 RAC 10.2.0.4.2 升级到 10.2.0.4.11 包括 CRS 和 DB 都需要打 PSU补丁， 打补丁的步骤是如何的？

shunzi

谢谢！知道了。

Maclean Liu(刘相兵

ODM FINDING:

10.2.0.4 Current Recommended Patches
Oracle has introduced Patch Set Updates (PSU) for 10.2.0.4 which include recommended fixes for generic , RAC and DataGuard issues.
The PSU should be treated as the recommended patch for these areas - additional recommendations may be listed below under relevant areas.
Please read Note:854428.1 for an introduction to Patch Set Updates.

Patch Set Updates

    Document         Description         Rolling RAC         Patch Download
    Note:12879933.8         10.2.0.4.12 Patch Set Update (PSU) Overlay         Yes         Patch:12879933
    Note:9352164.8         10.2.0.4.4 Patch Set Update (PSU)         Yes         Patch:9352164

Generic

    Document         Description         Rolling RAC         Patch Download
    Note:9572766.8         Recommended merge fix for bug 6994194 and bug 8830147         Yes         Patch:9572766

RAC

    Document         Description         Rolling RAC         Patch Download
    Note:6367097.8         Recommended on HP Itanium: RAC diagnostics can abort the instance (LMS ORA-484)         Yes         Patch:6367097
    Note:6079224.8         Recommended on Linux: RAC ORA-27506 / IPC Send timeout         Yes         Patch:6079224

CRS

    Document         Description         Rolling RAC         Patch Download
    Note:9294403.8         10.2.0.4.4 CRS Patch Set Update (CRS PSU)         Yes         Patch:9294403

Patch 12879929: DATABASE PATCH SET UPDATE 10.2.0.4.11 (PRE-REQ 10.2.0.4.4|INCLUDES CPUJAN2012)

Patch Set Update PSU 10.2.0.4.11 is an overlay PSU whose base PSU is 10.2.0.4.4. This patch can only be applied in an Oracle home for which PSU 10.2.0.4.4 has already been installed.

PSU 10.2.0.4.11 is cumulative from PSU 10.2.0.4.5. Thus, there is no need to install PSU 10.2.0.4.5 or higher PSU before installing PSU 10.2.0.4.11.


Patch 9294403: TRACKING BUG FOR THE 10.2.0.4.4 CRS PSU




step :

下载 10.2 最新的Opatch工具  ， Patch 9294403 10.2.0.4.4 CRS PSU 、  Patch 9352164: DATABASE PSU 10.2.0.4.4 (INCLUDES CPUAPR2010)、Patch 12879929: DATABASE PATCH SET UPDATE 10.2.0.4.11

1. 替换就的Opatch工具 为下载的最新版本， 这包括CRS_HOME和 ORACLE_HOME
2. 滚动升级 CRS到 PSU 10.2.0.4.4
3. 升级DB 到 PSU 10.2.0.4.4 并运行catbundle.sql psu 具体参考 PSU readme
4. 升级DB 到 PSU 10.2.0.4.11并运行catbundle.sql opsu  view_recompile_jan2008cpu.sql 和  utlrp.sql 具体参考 PSU readme