Problem phenomenon:
When using Opatch to make a patch, report the following error:
[[email protected] 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 would show your detected Configuration and all the steps, Opatchauto attempted to does on your System:/u01/app/ora11g/product/11.2.0/db_1/cfgtool Logs/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 had unzipped this patch to an empty dir Ectory to proceed (yes/no): Yesenter ' yes ' if you had unzipped this patch to a empty directory to proceed (yes/no): YesT He 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 OPA TCH 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 mi Nimum version Check for patch/soft/psu/20299013/19769489 failed for/u01/app/ora11g/product/11.2.0/db_1the opatch minim Um version check for patch/soft/psu/20299013/20299013 failed For/u01/app/ora11g/product/11.2.0/db_1opatch version Chec K 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 looks like the Opatch version is too low problem, actually my opatch already is the highest version! This error surface is very misleading, I went on a further look at the log!
To view the Opatch log:
[2015-6-15 16:26:29] Following executables is active:/u01/app/ora11g/product/11.2.0/db_1/lib/libclntsh.so.11.1[2 015-6-15 16:26:29] Prerequisite Check "Checkactivefilesandexecutables" failed. The details are:following executabl ES is active:/u01/app/ora11g/product/11.2.0/db_1/lib/libclntsh.so.11.1[2015-6-15 16:26:29] Start fuser Command/sbin/fuser/u01/app/ora11g/product/11.2.0/db_1/bin/proc at Mon June 16:26:29 CST 2015[2015- 6-15 16:26:29] Finish fuser Command/sbin/fuser/u01/app/ora11g/product/11.2.0/db_1/bin/proc at Mon June 15 16:26:2 9 CST 2015[2015-6-15 16:26:29] Start fuser COMMAND/SBIN/FUSER/U01/APP/ORA11G/PRODUCT/11.2.0/DB_1/LIB/LIBORASDKBA se.so.11.1 at Mon June 16:26:29 CST 2015[2015-6-15 16:26:29] Finish fuser COMMAND/SBIN/FUSER/U01/APP/ORA11G/PR Oduct/11.2.0/db_1/lib/liborasdkbase.so.11.1 at Mon June 16:26:29 CST 2015[2015-6-15 16:26:29] Start fuser command /sbin/fuser/u01/app/ora11g/product/11.2.0/db_1/bin/wrap at Mon June 16:26:29 CST 2015[2015-6-15 16:26:29] Finis H fuser command/sbin/fuser/u01/app/ora11g/product/11.2.0/db_1/bin/wrap at Mon June 16:26:29 CST 2015[2015-6-15 16:26:2 9] Start fuser command/sbin/fuser/u01/app/ora11g/product/11.2.0/db_1/bin/e2eme at Mon June 16:26:29 CST 2015[2 015-6-15 16:26:29] Finish fuser command/sbin/fuser/u01/app/ora11g/product/11.2.0/db_1/bin/e2eme at Mon June 15 16 : 26:29 CST 2015[2015-6-15 16:26:29] oui-67073:utilsession failed: Prerequisite Check "Checkactivefilesandexecutables" Failed. [2015-6-15 16:26:29] Finishing utilsession at Mon June 16:26:29 CST 2015[2015-6-15 16:26:29] Log file location:/u01/app/ora11g/produ ct/11.2.0/db_1/cfgtoollogs/opatch/opatch2015-06-15_16-26-24 pm _1.log[2015-6-15 16:26:29] Stack Description: Java.lanG.runtimeexception:prerequisite check "Checkactivefilesandexecutables" failed. [2015-6-15 16:26:29] Stack trace: oracle.opatch.OPatchSessionHelper.runApplyPrereqs (opatchsessionhelper.java:5717) [2015- 6-15 16:26:29] Stack trace: oracle.opatch.opatchutil.NApply.process (napply.java:697) [2015-6-15 16:26:29] stack trace: or Acle.opatch.opatchutil.OUSession.napply (ousession.java:1082) [2015-6-15 16:26:29] stack trace: sun.reflect.NativeMethodAc CESSORIMPL.INVOKE0 (Native Method) [2015-6-15 16:26:29] Stack trace: Sun.reflect.NativeMethodAccessorImpl.invoke (nativemeth odaccessorimpl.java:39) [2015-6-15 16:26:29] Stack trace: Sun.reflect.DelegatingMethodAccessorImpl.invoke (delegatingmetho DACCESSORIMPL.JAVA:25) [2015-6-15 16:26:29] Stack trace: Java.lang.reflect.Method.invoke (method.java:592) [2015-6-15 16:26: 29] Stack trace: oracle.opatch.UtilSession.process (utilsession.java:317) [2015-6-15 16:26:29] stack trace: Oracle.opatch. Opatchsession.main (opatchsession.java:2575) [2015-6-15 16:26:29] Stack trace: Oracle.opatch.OPatch.main (opatch.java:626)
You can see that the main problem is "Oui-67073:utilsession failure: Prerequisite Check" Checkactivefilesandexecutables "failed."
It should look like the active file process is causing the patch to fail.
Specific reference metalink:148501.1
Workaround:
1. Stop the database and listen
2.kill off all Oracle-related processes
[[email protected] opatch]$ ps-ef|grep smonoracle 31593 20962 0 16:32 pts/2 00:00:00 grep smon[[email pro tected] OPatch]$ ps -ef|grep oraroot 8418 8393 0 10:57 pts/1 00:00:00 su - oracleoracle 8419 8418 0 10:57 p TS/1 00:00:00-bashroot 20961 28684 0 15:52 pts/2 00:00:00 su-oracleoracle 20962 20961 0 15:52 pts/2 00 : 00:00-bashoracle 21978 1 0 13:52 pts/1 00:00:01/u01/app/ora11g/product/11.2.0/db_1/perl/bin/perl/u01/app/ora 11g/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 13:52 pts/1 00:00:23/u01/app/ora11g/product/11.2.0/db_1/bin/emagentoracle 25437 1 0 14:43? 00:00:17/u01/app/ora11g/product/11.2.0/grid/bin/ohasd.bin rebootoracle 26757 21978 0 14:50 pts/1 00:00:56/u01/app/ ORA11G/PRODUCT/11.2.0/DB_1/JDK/BIN/JAVA-SERVER-XMX384M-XX:MAXPERMSIZE=400M-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/OC4J- doracle.oc4j.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/oc4j/j2ee/oc4j_dbconsole_customer_ Custdb/config/jazn.xml-djava.security.policy=/u01/app/ora11g/product/11.2.0/db_1/oc4j/j2ee/oc4j_dbconsole_ customer_custdb/config/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/oc4j/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.ccr.ocmsdk.websvc.keystore=/u01/app/ora11g/prOduct/11.2.0/db_1/jlib/emocmclnt.ks-dice.pilots.html4.ignorenongenericfonts=true-djava.awt.headless=true-jar/ U01/app/ora11g/product/11.2.0/db_1/oc4j/j2ee/home/oc4j.jar-config/u01/app/ora11g/product/11.2.0/db_1/oc4j/j2ee /oc4j_dbconsole_customer_custdb/config/server.xmlroot 30019 27092 0 16:20 pts/0 00:00:00 su-oracleoracle 30020 30019 0 16:20 pts/0 00:00:00-bashoracle 31594 20962 1 16:32 pts/2 00:00:00 ps-eforacle 31595 20962 0 16:32 PTS/2 00:00:00 grep ora--kill process [[email protected] opatch]$ kill-9 21978[[email protected] OPatch]$ kill-9 26757[[email protected] opatch]$ kill-9 22059[[email protected] opatch]$ kill-9 25437[[email Protected] opatch]$ ps-ef|grep oraroot 8418 8393 0 10:57 pts/1 00:00:00 su-oracleoracle 8419 8418 0 10:5 7 pts/1 00:00:00-bashroot 20961 28684 0 15:52 pts/2 00:00:00 su-oracleoracle 20962 20961 0 15:52 PTS/2 00:00:00-bashroot 30019 27092 0 16:20 pts/0 00:00:00 su-oracleoracle 30020 30019 0 16:20 pts/0 00:00:00-bashoracle 32038 1 1 16:34? 00:00:00/u01/app/ora11g/product/11.2.0/grid/bin/ohasd.bin restartoracle 32132 20962 1 16:35 pts/2 00:00:00 ps-efor Acle 32133 20962 0 16:35 pts/2 00:00:00 grep ora
The Opatch command is OK again!
Opatch Error Prerequisite Check "Checkactivefilesandexecutables" failed