OPatch reports Prerequisite check & quot; CheckActiveFilesAndExecutables & quot; failed, opatch

OPatch reports Prerequisite check "CheckActiveFilesAndExecutables" failed, opatch
Symptom:

When patching with Opatch, the following error is reported:

[root@customer bin]# <span style="color:#ff0000;">/u01/app/ora11g/product/11.2.0/db_1/OPatch/opatch auto /soft/psu/20299013/ -oh /u01/app/ora11g/product/11.2.0/db_1 -ocmrf /u01/app/ora11g/product/11.2.0/db_1/OPatch/ocm/bin/ocm.rsp</span>Executing /u01/app/ora11g/product/11.2.0/grid/perl/bin/perl /u01/app/ora11g/product/11.2.0/db_1/OPatch/crs/patch11203.pl -patchdir /soft/psu -patchn 20299013 -oh /u01/app/ora11g/product/11.2.0/db_1 -ocmrf /u01/app/ora11g/product/11.2.0/db_1/OPatch/ocm/bin/ocm.rsp -paramfile /u01/app/ora11g/product/11.2.0/grid/crs/install/crsconfig_paramsThis is the main log file: /u01/app/ora11g/product/11.2.0/db_1/cfgtoollogs/opatchauto2015-06-15_15-50-31.logThis file will show your detected configuration and all the steps that opatchauto attempted to do on your system:/u01/app/ora11g/product/11.2.0/db_1/cfgtoollogs/opatchauto2015-06-15_15-50-31.report.log2015-06-15 15:50:31: Starting Oracle Restart Patch SetupUsing configuration parameter file: /u01/app/ora11g/product/11.2.0/grid/crs/install/crsconfig_paramsEnter 'yes' if you have unzipped this patch to an empty directory to proceed  (yes/no):yesEnter 'yes' if you have unzipped this patch to an empty directory to proceed  (yes/no):yesThe opatch minimum version  check for patch /soft/psu/20299013/17478514 failed  for /u01/app/ora11g/product/11.2.0/db_1The opatch minimum version  check for patch /soft/psu/20299013/18031668 failed  for /u01/app/ora11g/product/11.2.0/db_1The opatch minimum version  check for patch /soft/psu/20299013/18522509 failed  for /u01/app/ora11g/product/11.2.0/db_1The opatch minimum version  check for patch /soft/psu/20299013/19121551 failed  for /u01/app/ora11g/product/11.2.0/db_1The opatch minimum version  check for patch /soft/psu/20299013/19769489 failed  for /u01/app/ora11g/product/11.2.0/db_1The opatch minimum version  check for patch /soft/psu/20299013/20299013 failed  for /u01/app/ora11g/product/11.2.0/db_1Opatch version check failed for oracle home  /u01/app/ora11g/product/11.2.0/db_1Opatch version  check failedERROR: update the opatch version for the failed homes and retryopatch auto failed.

On the surface, it seems that the OPatch version is too low. In fact, my OPatch version is already the highest! This error is misleading on the surface. I will go on to read the log further!

View OPatch logs:

[16:26:29] Following executables are active:/u01/app/ora11g/product/11.2.0/db_1/lib/libclntsh. so.11.1 [16:26:29] Prerequisite check "CheckActiveFilesAndExecutables" failed. the details are: Following executables are active:/u01/app/ora11g/product/11.2.0/db_1/lib/libclntsh. so.11.1 [16:26:29] Start fuser command/sbin/fuser/u01/app/ora11g/product/11.2.0/db_1/bin/proc at Mon Jun 15 16:26:29 CST 2015 [16:26:29] Finish fuser command/sbin/fuser/u01/app/ora11g/product/11.2.0/db_1/bin/proc at Mon Jun 15 16:26:29 CST 2015 [16:26:29] Start fuser command/sbin/fuser /u01/app/ora11g/product/11.2.0/db_1/lib/liborasdkbase. so.11.1 at Mon Jun 15 16:26:29 CST 2015 [16:26:29] Finish fuser command/sbin/fuser/u01/app/ora11g/product/11.2.0/db_1/lib/liborasdkbase. so.11.1 at Mon Jun 15 16:26:29 CST 2015 [16:26:29] Start fuser command/sbin/fuser/u01/app/ora11g/product/11.2.0/db_1/bin/wrap at Mon Jun 15 16:26:29 CST 2015 [16:26:29] Finish fuser command/sbin/fuser/u01/app/ora11g/product/11.2.0/db_1/bin/wrap at Mon Jun 15 16:26:29 CST 2015 [16:26:29] start fuser command/sbin/fuser/u01/app/ora11g/product/11.2.0/db_1/bin/e2eme at Mon Jun 15 16:26:29 CST 2015 [16:26:29] Finish fuser command/sbin/ fuser/u01/app/ora11g/product/11.2.0/db_1/bin/e2eme at Mon Jun 15 16:26:29 CST 2015 [16:26:29] OUI-67073: utilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed. [16:26:29] Finishing UtilSession at Mon Jun 15 16:26:29 CST 2015 [16:26:29] Log file location: /u01/app/ora11g/product/11.2.0/db_1/export toollogs/opatch/opatch2015-06-15_16-26-24 in the afternoon _ 1.log[ 16:26:29] stack Description: java. lang. runtimeException: Prerequisite check "CheckActiveFilesAndExecutables" failed. [16:26:29] stack tracking: oracle. opatch. OPatchSessionHelper. runApplyPrereqs (OPatchSessionHelper. java: 5717) [16:26:29] stack tracking: oracle. opatch. opatchutil. NApply. process (NApply. java: 697) [16:26:29] stack tracking: oracle. opatch. opatchutil. OUSession. napply (OUSession. java: 1082) [16:26:29] stack trace: sun. reflect. nativeMethodAccessorImpl. invoke0 (Native Method) [16:26:29] stack trace: sun. reflect. nativeMethodAccessorImpl. invoke (NativeMethodAccessorImpl. java: 39) [16:26:29] stack trace: sun. reflect. delegatingMethodAccessorImpl. invoke (DelegatingMethodAccessorImpl. java: 25) [16:26:29] stack tracing: java. lang. reflect. method. invoke (Method. java: 592) [16:26:29] stack tracking: oracle. opatch. utilSession. process (UtilSession. java: 317) [16:26:29] stack tracking: oracle. opatch. OPatchSession. main (OPatchSession. java: 2575) [16:26:29] stack tracking: oracle. opatch. OPatch. main (OPatch. java: 626)

We can see that the main problem is "OUI-67073: UtilSession failed: Prerequisite check" CheckActiveFilesAndExecutables "failed ."
It seems that an active file process causes the patch to fail.

For details, refer to Metalink: 148501.1

Solution:

1. Stop the database and listen
2. kill all oracle-related processes

[Oracle @ customer OPatch] $ ps-ef | grep smonoracle 31593 20962 0 00:00:00 pts/2 grep smon [oracle @ customer OPatch] $ ps-ef | grep oraroot 8418 8393 0 pts/1 00:00:00 su-oracleoracle 8419 8418 0 00:00:00 pts/1 00:00:00-bashroot 20961 28684 20962 0 00:00:00 pts/2 su-oracleoracle 20961 21978 0 pts/2-bashoracle 1 0 00:00:01 pts/1/u01/app/ora11g/product/11.2.0/db_1/p Erl/bin/perl/u01/app/ora11g/product/11.2.0/db_1/bin/emwd. pl dbconsole/u01/app/ora11g/product/11.2.0/db_1/customer_custdb/sysman/log/emdb. nohuporacle 22059 21978 0 00:00:23 pts/1/u01/app/ora11g/product/11.2.0/db_1/bin/emagentoracle 25437 1 0? 00:00:17/u01/app/ora11g/product/11.2.0/grid/bin/ohasd. bin rebootoracle 26757 21978 0 00:00:56 pts/1/u01/app/ora11g/product/11.2.0/db_1/jdk/bin/java-server-Xmx384M-XX: maxPermSize = 400 M-XX: MinHeapFreeRatio = 20-XX: MaxHeapFreeRatio = 40-DORACLE_HOME =/u01/app/ora11g/product/11.2.0/db_1-Doracle. home =/u01/app/ora11g/product/11.2.0/db_1/Solaris-Doracle. for more information, see <G id = "1"> overview </G>. localhome =/u01/app/ora11g/product/11.2. 0/db_1/customer_custdb/sysman-DEMSTATE =/u01/app/ora11g/product/11.2.0/db_1/customer_custdb-Doracle. j2ee. dont. use. memory. archive = true-Djava. protocol. handler. pkgs = HTTPClient-Doracle. security. jazn. config =/u01/app/ora11g/product/11.2.0/db_1/Solaris/j2ee/OC4J_DBConsole_customer_custdb/config/jazn. xml-Djava. security. policy =/u01/app/ora11g/product/11.2.0/db_1/Solaris/j2ee/OC4J_DBConsole_customer_custdb/co Nfig/java2.policy -Djavax.net. ssl. keyStore =/u01/app/ora11g/product/11.2.0/db_1/sysman/config/OCMTrustedCerts.txt-Djava. security. properties =/u01/app/ora11g/product/11.2.0/db_1/Solaris/j2ee/home/config/jazn. security. props-DEMDROOT =/u01/app/ora11g/product/11.2.0/db_1/customer_custdb-Dsysman. md5password = true-Drepapi. oracle. home =/u01/app/ora11g/product/11.2.0/db_1-Ddisable. checkForUpdate = true-Doracle. Sysman. cr. ocmSDK. websvc. keystore =/u01/app/ora11g/product/11.2.0/db_1/jlib/emocmclnt. ks -Dice.pilots.html 4. ignoreNonGenericFonts = true-Djava. awt. headless = true-jar/u01/app/ora11g/product/11.2.0/db_1/Solaris/j2ee/home/Solaris. jar-config/u01/app/ora11g/product/11.2.0/db_1/Solaris/j2ee/OC4J_DBConsole_customer_custdb/config/server. xmlroot 30019 27092 0 00:00:00 pts/0 su-oracleoracle 30020 30019 0 1 00:00:00 pts/0 00:00:00-bashoracle 31594 20962 1 00:00:00 pts/2 ps-eforacle 31595 20962 0 pts/2 grep ora -- kill process [oracle @ customer OPatch] $ kill- 9 21978 [oracle @ customer OPatch] $ kill-9 26757 [oracle @ customer OPatch] $ kill-9 22059 [oracle @ customer OPatch] $ kill-9 25437 [oracle @ customer OPatch] $ ps-ef | grep oraroot 8418 8393 0 00:00:00 pts/1 su-oracleoracle 8419 8418 0 7 pts/1 00:00:00-bashroot 20961 28684 0 00:00:00 pts/2 00:00:00 su-oracleoracle 20962 20961 30019 0 00:00:00 pts/2-bashroot 27092 30020 0 pts/0 su-oracleoracle 30019 0 00:00:00 pts/0-bashoracle 32038 1 1? 00:00:00/u01/app/ora11g/product/11.2.0/grid/bin/ohasd. bin restartoracle 32132 20962 1 00:00:00 pts/2 00:00:00 ps-eforacle 32133 20962 0 pts/2 grep ora

The OPatch command again is normal!