Oracle 升級10.2.0.5.4 OPatch 報錯Patch 12419392 Optional component(s) missing 解決方案

 

新搭建的環境，計劃使用10g的最新版本10.2.0.5.4，之前測試過程參考如下：

 Linux 平台 Oracle 單一實例 從10.2.0.1升級到10.2.0.5.4步驟

http://blog.csdn.net/tianlesoftware/article/details/6858397

 

前面都比較順利，但是在apply10.2.0.5.4 的Patch 報錯了。

 

qs-xe-dzora-pd:/u01/software/12419392>$ORACLE_HOME/OPatch/opatch apply

Invoking OPatch 10.2.0.5.1

 

Oracle Interim Patch Installer version10.2.0.5.1

Copyright (c) 2010, OracleCorporation.  All rights reserved.

 

 

Oracle Home       :/u01/app/oracle/product/10.2.0.5.4/db_1

Central Inventory :/home/oracle/oraInventory

   from          : /etc/oraInst.loc

OPatch version    : 10.2.0.5.1

OUI version       : 10.2.0.5.0

OUI location      :/u01/app/oracle/product/10.2.0.5.4/db_1/oui

Log file location :/u01/app/oracle/product/10.2.0.5.4/db_1/cfgtoollogs/opatch/opatch2011-10-19_21-03-26PM.log

 

Patch history file:/u01/app/oracle/product/10.2.0.5.4/db_1/cfgtoollogs/opatch/opatch_history.txt

 

ApplySession applying interim patch'12419392' to OH '/u01/app/oracle/product/10.2.0.5.4/db_1'

 

Running prerequisite checks...

Patch 12419392: Optionalcomponent(s) missing : [ oracle.rdbms, 10.2.0.5.0 ] , [oracle.rdbms.rsf, 10.2.0.5.0 ] , [ oracle.rdbms.dbscripts, 10.2.0.5.0 ] , [oracle.rdbms.dv, 10.2.0.5.0 ] , [ oracle.network.rsf, 10.2.0.5.0 ] , [oracle.rdbms.dv.oc4j, 10.2.0.5.0 ] , [ oracle.sysman.bsln, 10.2.0.5.0 ] , [oracle.sysman.repository.core, 10.2.0.5.0a ] , [ oracle.sysman.console.db,10.2.0.5.0 ] , [ oracle.xdk.rsf, 10.2.0.5.0 ] , [ oracle.precomp.common,10.2.0.5.0 ] , [ oracle.rdbms.rman, 10.2.0.5.0 ]

Prerequisite check "CheckApplicable"failed.

The details are:

Patch"12419392" is a no-op patch.

ApplySession failed during prerequisitechecks: Prerequisite check "CheckApplicable" failed.

System intact, OPatch will not attempt torestore the system

 

OPatch failed with error code 74

qs-xe-dzora-pd:/u01/software/12419392>

 

因為是新搭建的生產環境，用OUI 把之前的安裝的Oracle 全部卸載，然後重裝了一下，在打到10.2.0.5.0. 因為沒有建立執行個體，所以整個過程也就20來分鐘。

 

之後在打這個patch 就順利通過了。但是還是有提示可選組件丟失：

qs-xe-dzora-pd:/u01/software/12419392>$ORACLE_HOME/OPatch/opatch apply

Invoking OPatch 10.2.0.5.1

 

Oracle Interim Patch Installer version10.2.0.5.1

Copyright (c) 2010, OracleCorporation.  All rights reserved.

 

 

Oracle Home       :/u01/app/oracle/product/10.2.0.5.4/db_1

Central Inventory :/home/oracle/oraInventory

  from           : /etc/oraInst.loc

OPatch version    : 10.2.0.5.1

OUI version       : 10.2.0.5.0

OUI location      : /u01/app/oracle/product/10.2.0.5.4/db_1/oui

Log file location :/u01/app/oracle/product/10.2.0.5.4/db_1/cfgtoollogs/opatch/opatch2011-10-20_09-23-52AM.log

 

Patch history file:/u01/app/oracle/product/10.2.0.5.4/db_1/cfgtoollogs/opatch/opatch_history.txt

 

ApplySession applying interim patch'12419392' to OH '/u01/app/oracle/product/10.2.0.5.4/db_1'

 

Running prerequisite checks...

Patch 12419392: Optionalcomponent(s) missing : [ oracle.rdbms.dv, 10.2.0.5.0 ] , [oracle.rdbms.dv.oc4j, 10.2.0.5.0 ]

Provide your email address to be informedof security issues, install and

initiate Oracle Configuration Manager.Easier for you if you use your My

Oracle Support Email address/User Name.

Visithttp://www.oracle.com/support/policies.html for details.

……

 

 

驗證Patch：

qs-xe-dzora-pd:/u01/software/12419392>  $ORACLE_HOME/OPatch/opatch lsinv-bugs_fixed|grep PSU

9952230   12419392  Thu Oct 20 09:34:38 CST2011   DATABASE PSU 10.2.0.5.1 (INCLUDESCPUOCT2010)

10248542  12419392  Thu Oct 20 09:34:38 CST2011   DATABASE PSU 10.2.0.5.2 (INCLUDESCPUJAN2011)

11724962  12419392  Thu Oct 20 09:34:38 CST2011   DATABASE PSU 10.2.0.5.3 (INCLUDESCPUAPR2011)

12419392  12419392  Thu Oct 20 09:34:38 CST2011   DATABASE PSU 10.2.0.5.4 (INCLUDESCPUJUL2011)

 

 

 

 

 

-------------------------------------------------------------------------------------------------------

著作權. 文章允許轉載,但必須以連結方式註明源地址,否則追究法律責任.

Blog： http://blog.csdn.net/tianlesoftware

Weibo: http://weibo.com/tianlesoftware

Email: tianlesoftware@gmail.com

DBA1 群：62697716(滿);   DBA2 群：62697977(滿)  DBA3 群：62697850(滿)  

DBA 超級群：63306533(滿);  DBA4 群：83829929(滿) DBA5群： 142216823(滿) 

DBA6 群：158654907(滿)   DBA7 群：69087192(滿)  DBA8 群：172855474

DBA 超級群2：151508914  DBA9群：102954821     聊天 群：40132017(滿)

--加群需要在備忘說明Oracle資料表空間和資料檔案的關係，否則拒絕申請