OPatch報錯 Prerequisite check "CheckActiveFilesAndExecutables" failed，opatch

OPatch報錯 Prerequisite check "CheckActiveFilesAndExecutables" failed，opatch

Prerequisite check "CheckActiveFilesAndExecutables" failed

問題背景:
    我們在進行資料庫打補丁Optatch的時候，突然報錯CheckActiveFilesAndExecutables,導致補丁無法進行應用下去。

問題現象：

[oracle@db01 18522509]$ /home/oracle/OPatch/opatch applyOracle Interim Patch Installer version 11.2.0.3.6Copyright (c) 2013, Oracle Corporation.  All rights reserved.Oracle Home       : /DBSoft/Product/11.2.4/db_1Central Inventory : /DBSoft/oraInventory   from           : /DBSoft/Product/11.2.4/db_1/oraInst.locOPatch version    : 11.2.0.3.6OUI version       : 11.2.0.4.0Log file location : /DBSoft/Product/11.2.4/db_1/cfgtoollogs/opatch/opatch2014-10-09_05-06-13AM_1.logVerifying environment and performing prerequisite checks...Prerequisite check "CheckActiveFilesAndExecutables" failed.The details are:Following executables are active :/DBSoft/Product/11.2.4/db_1/bin/oracle/DBSoft/Product/11.2.4/db_1/lib/libclntsh.so.11.1UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.Log file location: /DBSoft/Product/11.2.4/db_1/cfgtoollogs/opatch/opatch2014-10-09_05-06-13AM_1.logOPatch failed with error code 73

查看OPatch日誌 :

[oracle@db01 OPatch]$ cat /DBSoft/Product/11.2.4/db_1/cfgtoollogs/opatch/opatch2014-10-09_05-06-13AM_1.log[Oct 9, 2014 5:06:13 AM]     OPatch invoked as follows: 'apply -invPtrLoc /DBSoft/Product/11.2.4/db_1/oraInst.loc '[Oct 9, 2014 5:06:13 AM]     OUI-67077:                             Oracle Home       : /DBSoft/Product/11.2.4/db_1                             Central Inventory : /DBSoft/oraInventory                                from           : /DBSoft/Product/11.2.4/db_1/oraInst.loc                             OPatch version    : 11.2.0.3.6                             OUI version       : 11.2.0.4.0                             OUI location      : /DBSoft/Product/11.2.4/db_1/oui                             Log file location : /DBSoft/Product/11.2.4/db_1/cfgtoollogs/opatch/opatch2014-10-09_05-06-13AM_1.log[Oct 9, 2014 5:06:13 AM]     Patch history file: /DBSoft/Product/11.2.4/db_1/cfgtoollogs/opatch/opatch_history.txt[Oct 9, 2014 5:06:16 AM]     Verifying environment and performing prerequisite checks...[Oct 9, 2014 5:06:16 AM]     Ignoring file "/home/oracle/18522509/README.html" in the patch directory.[Oct 9, 2014 5:06:16 AM]     Ignoring file "/home/oracle/18522509/README.txt" in the patch directory.[Oct 9, 2014 5:06:16 AM]     Ignoring file "/home/oracle/18522509/patchmd.xml" in the patch directory.[Oct 9, 2014 5:06:17 AM]     Checking conflict among patches...[Oct 9, 2014 5:06:17 AM]     Patch ID  18522509[Oct 9, 2014 5:06:17 AM]     Patches that conflict: [  ][Oct 9, 2014 5:06:17 AM]     Checking conflicts for patch : 18522509[Oct 9, 2014 5:06:17 AM]     Checking if Oracle Home has components required by patches...[Oct 9, 2014 5:06:17 AM]     Check if patch "17478514"  is a no-op patch.[Oct 9, 2014 5:06:18 AM]     Check if patch "18031668"  is a no-op patch.[Oct 9, 2014 5:06:18 AM]     Check if patch "18522509"  is a no-op patch.[Oct 9, 2014 5:06:18 AM]     Running prerequisite checks...[Oct 9, 2014 5:06:18 AM]     Patch "17478514" is ignored as it is not a "Fusion Applications patch".[Oct 9, 2014 5:06:18 AM]     Patch "18031668" is ignored as it is not a "Fusion Applications patch".[Oct 9, 2014 5:06:18 AM]     Patch "18522509" is ignored as it is not a "Fusion Applications patch".[Oct 9, 2014 5:06:18 AM]     Check if patch "17478514"  is a no-op patch.[Oct 9, 2014 5:06:18 AM]     Check if patch "18031668"  is a no-op patch.[Oct 9, 2014 5:06:18 AM]     Check if patch "18522509"  is a no-op patch.[Oct 9, 2014 5:06:18 AM]     None of the selected patches are no-op. patches..[Oct 9, 2014 5:06:19 AM]     Space Needed : 328.875MB[Oct 9, 2014 5:06:19 AM]     Prereq checkPatchApplicableOnCurrentPlatform Passed for patch : 17478514[Oct 9, 2014 5:06:19 AM]     Prereq checkPatchApplicableOnCurrentPlatform Passed for patch : 18031668[Oct 9, 2014 5:06:19 AM]     Prereq checkPatchApplicableOnCurrentPlatform Passed for patch : 18522509[Oct 9, 2014 5:06:19 AM]     Start fuser command /sbin/fuser /DBSoft/Product/11.2.4/db_1/bin/oracle at Thu Oct 09 05:06:19 CST 2014[Oct 9, 2014 5:06:20 AM]     Finish fuser command /sbin/fuser /DBSoft/Product/11.2.4/db_1/bin/oracle at Thu Oct 09 05:06:20 CST 2014[Oct 9, 2014 5:06:20 AM]     Start fuser command /sbin/fuser /DBSoft/Product/11.2.4/db_1/bin/amdu at Thu Oct 09 05:06:20 CST 2014[Oct 9, 2014 5:06:20 AM]     Finish fuser command /sbin/fuser /DBSoft/Product/11.2.4/db_1/bin/amdu at Thu Oct 09 05:06:20 CST 2014[Oct 9, 2014 5:06:20 AM]     Start fuser command /sbin/fuser /DBSoft/Product/11.2.4/db_1/bin/kfed at Thu Oct 09 05:06:20 CST 2014[Oct 9, 2014 5:06:20 AM]     Finish fuser command /sbin/fuser /DBSoft/Product/11.2.4/db_1/bin/kfed at Thu Oct 09 05:06:20 CST 2014[Oct 9, 2014 5:06:20 AM]     Start fuser command /sbin/fuser /DBSoft/Product/11.2.4/db_1/bin/kfod at Thu Oct 09 05:06:20 CST 2014[Oct 9, 2014 5:06:20 AM]     Finish fuser command /sbin/fuser /DBSoft/Product/11.2.4/db_1/bin/kfod at Thu Oct 09 05:06:20 CST 2014[Oct 9, 2014 5:06:20 AM]     Start fuser command /sbin/fuser /DBSoft/Product/11.2.4/db_1/bin/renamedg at Thu Oct 09 05:06:20 CST 2014[Oct 9, 2014 5:06:20 AM]     Finish fuser command /sbin/fuser /DBSoft/Product/11.2.4/db_1/bin/renamedg at Thu Oct 09 05:06:20 CST 2014[Oct 9, 2014 5:06:20 AM]     Start fuser command /sbin/fuser /DBSoft/Product/11.2.4/db_1/bin/orion at Thu Oct 09 05:06:20 CST 2014[Oct 9, 2014 5:06:20 AM]     Finish fuser command /sbin/fuser /DBSoft/Product/11.2.4/db_1/bin/orion at Thu Oct 09 05:06:20 CST 2014[Oct 9, 2014 5:06:20 AM]     Start fuser command /sbin/fuser /DBSoft/Product/11.2.4/db_1/bin/rman at Thu Oct 09 05:06:20 CST 2014[Oct 9, 2014 5:06:20 AM]     Finish fuser command /sbin/fuser /DBSoft/Product/11.2.4/db_1/bin/rman at Thu Oct 09 05:06:20 CST 2014[Oct 9, 2014 5:06:20 AM]     Start fuser command /sbin/fuser /DBSoft/Product/11.2.4/db_1/lib/libclntsh.so.11.1 at Thu Oct 09 05:06:20 CST 2014[Oct 9, 2014 5:06:20 AM]     Finish fuser command /sbin/fuser /DBSoft/Product/11.2.4/db_1/lib/libclntsh.so.11.1 at Thu Oct 09 05:06:20 CST 2014[Oct 9, 2014 5:06:20 AM]     Start fuser command /sbin/fuser /DBSoft/Product/11.2.4/db_1/lib/liborasdk.so.11.1 at Thu Oct 09 05:06:20 CST 2014[Oct 9, 2014 5:06:20 AM]     Finish fuser command /sbin/fuser /DBSoft/Product/11.2.4/db_1/lib/liborasdk.so.11.1 at Thu Oct 09 05:06:20 CST 2014[Oct 9, 2014 5:06:20 AM]     Following executables are active :                             /DBSoft/Product/11.2.4/db_1/bin/oracle                             /DBSoft/Product/11.2.4/db_1/lib/libclntsh.so.11.1[Oct 9, 2014 5:06:20 AM]     Prerequisite check "CheckActiveFilesAndExecutables" failed.                             The details are:                                                                                     Following executables are active :                             /DBSoft/Product/11.2.4/db_1/bin/oracle                             /DBSoft/Product/11.2.4/db_1/lib/libclntsh.so.11.1[Oct 9, 2014 5:06:20 AM]     Start fuser command /sbin/fuser /DBSoft/Product/11.2.4/db_1/bin/proc at Thu Oct 09 05:06:20 CST 2014[Oct 9, 2014 5:06:20 AM]     Finish fuser command /sbin/fuser /DBSoft/Product/11.2.4/db_1/bin/proc at Thu Oct 09 05:06:20 CST 2014[Oct 9, 2014 5:06:20 AM]     OUI-67073:UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.[Oct 9, 2014 5:06:20 AM]     Finishing UtilSession at Thu Oct 09 05:06:20 CST 2014[Oct 9, 2014 5:06:20 AM]     Log file location: /DBSoft/Product/11.2.4/db_1/cfgtoollogs/opatch/opatch2014-10-09_05-06-13AM_1.log[Oct 9, 2014 5:06:20 AM]     Stack Description: java.lang.RuntimeException: Prerequisite check "CheckActiveFilesAndExecutables" failed.[Oct 9, 2014 5:06:20 AM]     StackTrace: oracle.opatch.OPatchSessionHelper.runApplyPrereqs(OPatchSessionHelper.java:6420)[Oct 9, 2014 5:06:20 AM]     StackTrace: oracle.opatch.opatchutil.NApply.process(NApply.java:1614)[Oct 9, 2014 5:06:20 AM]     StackTrace: oracle.opatch.opatchutil.OUSession.napply(OUSession.java:1136)[Oct 9, 2014 5:06:20 AM]     StackTrace: sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)[Oct 9, 2014 5:06:20 AM]     StackTrace: sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)[Oct 9, 2014 5:06:20 AM]     StackTrace: sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)[Oct 9, 2014 5:06:20 AM]     StackTrace: java.lang.reflect.Method.invoke(Method.java:592)[Oct 9, 2014 5:06:20 AM]     StackTrace: oracle.opatch.UtilSession.process(UtilSession.java:322)[Oct 9, 2014 5:06:20 AM]     StackTrace: oracle.opatch.OPatchSession.main(OPatchSession.java:2343)[Oct 9, 2014 5:06:20 AM]     StackTrace: oracle.opatch.OPatch.main(OPatch.java:614)

問題分析：

我們通過上面的日誌資訊可以看到，是報有檔案是處於執行狀態，具體參考Metalink:148501.1;

 

問題解決辦法:

1、     檢查Oracle進程:

[oracle@db01 18522509]$ ps -ef|grep oraoracle 2643 1 0 Oct08 ? 00:00:06 /DBSoft/Product/11.2.4/db_1/bin/tnslsnr LISTENER -inheritoracle 2673 1 0 Oct08 ? 00:00:00 ora_pmon_woooracle 2675 1 0 Oct08 ? 00:00:00 ora_psp0_woooracle 2677 1 0 Oct08 ? 00:00:00 ora_vktm_woooracle 2681 1 0 Oct08 ? 00:00:32 ora_gen0_woooracle 2683 1 0 Oct08 ? 00:00:00 ora_diag_woooracle 2685 1 0 Oct08 ? 00:00:00 ora_dbrm_woooracle 2687 1 0 Oct08 ? 00:00:07 ora_dia0_woooracle 2689 1 0 Oct08 ? 00:00:00 ora_mman_woooracle 2691 1 0 Oct08 ? 00:00:00 ora_dbw0_woooracle 2693 1 0 Oct08 ? 00:00:01 ora_lgwr_woooracle 2695 1 0 Oct08 ? 00:00:02 ora_ckpt_woooracle 2697 1 0 Oct08 ? 00:00:01 ora_smon_woooracle 2699 1 0 Oct08 ? 00:00:00 ora_reco_woooracle 2701 1 0 Oct08 ? 00:00:00 ora_mmon_woooracle 2703 1 0 Oct08 ? 00:00:03 ora_mmnl_woooracle 2705 1 0 Oct08 ? 00:00:00 ora_d000_woooracle 2707 1 0 Oct08 ? 00:00:00 ora_s000_woooracle 2714 1 0 Oct08 ? 00:00:05 ora_rvwr_woooracle 2721 1 7 Oct08 ? 01:01:16 ora_arc0_woooracle 2723 1 7 Oct08 ? 01:01:11 ora_arc1_woooracle 2725 1 0 Oct08 ? 00:00:00 ora_arc2_woooracle 2727 1 7 Oct08 ? 01:00:57 ora_arc3_woooracle 2733 1 0 Oct08 ? 00:00:00 ora_qmnc_woooracle 2749 1 0 Oct08 ? 00:00:01 ora_cjq0_woooracle 2777 1 0 Oct08 ? 00:00:00 ora_q000_woooracle 2779 1 0 Oct08 ? 00:00:00 ora_q001_woo

2、      停止資料庫再檢查進程

[oracle@db01 18522509]$ /home/oracle/shut.shOracle Enterprise Manager 11g Database Control Release 11.2.0.4.0Copyright (c) 1996, 2013 Oracle Corporation. All rights reserved.https://db01:5500/em/console/aboutApplicationStopping Oracle Enterprise Manager 11g Database Control ... ... Stopped. SQL*Plus: Release 11.2.0.4.0 Production on Thu Oct 9 07:50:30 2014 Copyright (c) 1982, 2013, Oracle. All rights reserved.  Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options  LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 09-OCT-2014 07:50:30 Copyright (c) 1991, 2013, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))The command completed successfully Database closed.Database dismounted.ORACLE instance shut down.Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options

### 檢查進程

[oracle@db01 18522509]$ ps -ef|grep oraroot 16511 11497 0 04:24 pts/2 00:00:00 su - oracleoracle 16512 16511 0 04:24 pts/2 00:00:00 -bashroot 24869 24844 0 06:00 pts/3 00:00:00 su - oracleoracle 24870 24869 0 06:00 pts/3 00:00:00 -bashoracle 28884 24870 0 06:47 pts/3 00:00:00 tail -f alert_woo.logoracle 32291 16512 0 07:52 pts/2 00:00:00 ps -eforacle 32292 16512 0 07:52 pts/2 00:00:00 grep ora

3、     再次執行正常，問題已排除 :

[oracle@db01 18522509]$ /DBSoft/Product/11.2.4/db_1/OPatch/opatch applyOracle Interim Patch Installer version 11.2.0.3.4Copyright (c) 2012, Oracle Corporation.  All rights reserved. Oracle Home       : /DBSoft/Product/11.2.4/db_1Central Inventory : /DBSoft/oraInventory   from           : /DBSoft/Product/11.2.4/db_1/oraInst.locOPatch version    : 11.2.0.3.4OUI version       : 11.2.0.4.0Log file location : /DBSoft/Product/11.2.4/db_1/cfgtoollogs/opatch/opatch2014-10-09_07-53-05AM_1.log Verifying environment and performing prerequisite checks...Prerequisite check "CheckMinimumOPatchVersion" failed.The details are:  The OPatch being used has version 11.2.0.3.4 while the following patch(es) require higher versions:Patch 17478514 requires OPatch version 11.2.0.3.5.Patch 18031668 requires OPatch version 11.2.0.3.5.Patch 18522509 requires OPatch version 11.2.0.3.5.Please download latest OPatch from My Oracle Support. UtilSession failed: Prerequisite check "CheckMinimumOPatchVersion" failed.Log file location: /DBSoft/Product/11.2.4/db_1/cfgtoollogs/opatch/opatch2014-10-09_07-53-05AM_1.log OPatch failed with error code 73[oracle@db01 18522509]$ /home/oracle/OPatch/op applyopatch          opatch.bat      opatchdiag      opatchdiag.bat  opatch.ini      opatch.pl       opatchprereqs/  oplan/         [oracle@db01 18522509]$ /home/oracle/OPatch/opatch applyOracle Interim Patch Installer version 11.2.0.3.6Copyright (c) 2013, Oracle Corporation.  All rights reserved.  Oracle Home       : /DBSoft/Product/11.2.4/db_1Central Inventory : /DBSoft/oraInventory   from           : /DBSoft/Product/11.2.4/db_1/oraInst.locOPatch version    : 11.2.0.3.6OUI version       : 11.2.0.4.0Log file location : /DBSoft/Product/11.2.4/db_1/cfgtoollogs/opatch/opatch2014-10-09_07-53-39AM_1.log Verifying environment and performing prerequisite checks...OPatch continues with these patches:   17478514  18031668  18522509  Do you want to proceed? [y|n]yUser Responded with: YAll checks passed.