OPatch failed with error code 74 的解決方法

秋風(fēng)No.1

問題描述:
客戶的數(shù)據(jù)庫是hp安騰平臺，數(shù)據(jù)庫是10G，要求升級數(shù)據(jù)庫到10.2.0.4.8

操作步驟如下：
1.升級到10.2.0.4后，進(jìn)行了crs的bundle 升級，patch是 9294403
2.然后打了patch 9352164 將數(shù)據(jù)庫升級到10.2.0.4.4
3.開始打patch 11724977 將數(shù)據(jù)庫升級到10.2.0.4.8 報下面的錯誤

/orabak/11724977
$ opatch apply
Invoking OPatch 10.2.0.5.1

Oracle Interim Patch Installer version 10.2.0.5.1
Copyright (c) 2010, Oracle Corporation.  All rights reserved.


Oracle Home       : /oracle/product/10.2.0/db
Central Inventory : /oracle/oraInventory
   from           : /var/opt/oracle/oraInst.loc
OPatch version    : 10.2.0.5.1
OUI version       : 10.2.0.4.0
OUI location      : /oracle/product/10.2.0/db/oui
Log file location : /oracle/product/10.2.0/db/cfgtoollogs/opatch/opatch2011-08-24_09-40-05AM.log

Patch history file: /oracle/product/10.2.0/db/cfgtoollogs/opatch/opatch_history.txt

ApplySession applying interim patch '11724977' to OH '/oracle/product/10.2.0/db'
Execution of 'sh /orabak/11724977/custom/scripts/init -apply 11724977 ':


Return Code = 0

Running prerequisite checks...
Patch 11724977: Optional component(s) missing : [ oracle.rdbms.dv, 10.2.0.4.0 ] , [ oracle.rdbms.dv.oc4j, 10.2.0.4.0 ]
Prerequisite check "CheckApplicable" failed.
The details are:

Patch 11724977:
Copy Action: Desctination File "/oracle/product/10.2.0/db/lib32/libnnz10.so" is not writeable.
'oracle.network.rsf.ic, 10.2.0.4.0': Cannot copy file from 'libnnz10.so' to '/oracle/product/10.2.0/db/lib32/libnnz10.so'

ApplySession failed during prerequisite checks: Prerequisite check "CheckApplicable" failed.
System intact, OPatch will not attempt to restore the system

OPatch failed with error code 74

解決方法：
使用操作系統(tǒng)命令fuser /oracle/product/10.2.0/db/lib32/libnnz10.so 檢查這個庫文件是被那個進(jìn)程使用中

結(jié)果發(fā)現(xiàn)是被emagent使用，也就是這個實例配置了OEM，真是傷不起啊。。。

kill掉這個進(jìn)程，patch順利安裝成功