Few days back, I was applying OPatch on one of the database residing on windows server. I tried it multiple times without any luck as everytime when I tried applying patch, I was getting below error:
OUI-67073:UtilSession failed: Prerequisite check “CheckActiveFilesAndExecutables” failed.
This was due to some of the DLL files related to oracle on server were used by some of the active processes even after I had stopped all oracle related services. Even i tried rebooting whole server, but it didn’t help.
I did check related logfile so as to get more details about the error:
[Oct 6, 2016 6:20:18 PM] Prereq checkPatchApplicableOnCurrentPlatform Passed for patch : 23530402 [Oct 6, 2016 6:20:18 PM] Following files are active : G:\OPENPA~1\REPOSI~1\SERVER~2\software\database\bin\oracell11.dll G:\OPENPA~1\REPOSI~1\SERVER~2\software\database\bin\oraasmclnt11.dll G:\OPENPA~1\REPOSI~1\SERVER~2\software\database\bin\orapls11.dll G:\OPENPA~1\REPOSI~1\SERVER~2\software\database\bin\orageneric11.dll G:\OPENPA~1\REPOSI~1\SERVER~2\software\database\bin\oraclient11.dll G:\OPENPA~1\REPOSI~1\SERVER~2\software\database\bin\oracommon11.dll G:\OPENPA~1\REPOSI~1\SERVER~2\software\database\bin\oraplp11.dll G:\OPENPA~1\REPOSI~1\SERVER~2\software\database\bin\oraxml11.dll G:\OPENPA~1\REPOSI~1\SERVER~2\software\database\bin\orannzsbb11.dll G:\OPENPA~1\REPOSI~1\SERVER~2\software\database\bin\orazt11.dll G:\OPENPA~1\REPOSI~1\SERVER~2\software\database\bin\oraztkg11.dll G:\OPENPA~1\REPOSI~1\SERVER~2\software\database\bin\oran11.dll G:\OPENPA~1\REPOSI~1\SERVER~2\software\database\bin\orantcp11.dll G:\OPENPA~1\REPOSI~1\SERVER~2\software\database\bin\oranl11.dll G:\OPENPA~1\REPOSI~1\SERVER~2\software\database\bin\orancrypt11.dll G:\OPENPA~1\REPOSI~1\SERVER~2\software\database\bin\orahasgen11.dll G:\OPENPA~1\REPOSI~1\SERVER~2\software\database\bin\oraocr11.dll G:\OPENPA~1\REPOSI~1\SERVER~2\software\database\bin\oraocrb11.dll G:\OPENPA~1\REPOSI~1\SERVER~2\software\database\bin\oraocrutl11.dll [Oct 6, 2016 6:20:18 PM] Prerequisite check "CheckActiveFilesAndExecutables" failed. The details are: Following files are active : G:\OPENPA~1\REPOSI~1\SERVER~2\software\database\bin\oracell11.dll G:\OPENPA~1\REPOSI~1\SERVER~2\software\database\bin\oraasmclnt11.dll G:\OPENPA~1\REPOSI~1\SERVER~2\software\database\bin\orapls11.dll G:\OPENPA~1\REPOSI~1\SERVER~2\software\database\bin\orageneric11.dll G:\OPENPA~1\REPOSI~1\SERVER~2\software\database\bin\oraclient11.dll G:\OPENPA~1\REPOSI~1\SERVER~2\software\database\bin\oracommon11.dll G:\OPENPA~1\REPOSI~1\SERVER~2\software\database\bin\oraplp11.dll G:\OPENPA~1\REPOSI~1\SERVER~2\software\database\bin\oraxml11.dll G:\OPENPA~1\REPOSI~1\SERVER~2\software\database\bin\orannzsbb11.dll G:\OPENPA~1\REPOSI~1\SERVER~2\software\database\bin\orazt11.dll G:\OPENPA~1\REPOSI~1\SERVER~2\software\database\bin\oraztkg11.dll G:\OPENPA~1\REPOSI~1\SERVER~2\software\database\bin\oran11.dll G:\OPENPA~1\REPOSI~1\SERVER~2\software\database\bin\orantcp11.dll G:\OPENPA~1\REPOSI~1\SERVER~2\software\database\bin\oranl11.dll G:\OPENPA~1\REPOSI~1\SERVER~2\software\database\bin\orancrypt11.dll G:\OPENPA~1\REPOSI~1\SERVER~2\software\database\bin\orahasgen11.dll G:\OPENPA~1\REPOSI~1\SERVER~2\software\database\bin\oraocr11.dll G:\OPENPA~1\REPOSI~1\SERVER~2\software\database\bin\oraocrb11.dll G:\OPENPA~1\REPOSI~1\SERVER~2\software\database\bin\oraocrutl11.dll [Oct 6, 2016 6:20:18 PM] OUI-67073:UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed. [Oct 6, 2016 6:20:18 PM] Finishing UtilSession at Thu Oct 06 18:20:18 CAT 2016 [Oct 6, 2016 6:20:18 PM] Log file location: G:\OPENPA~1\REPOSI~1\SERVER~2\software\database\cfgtoollogs\opatch\opatch2016-10-06_18-20-12PM_1.log [Oct 6, 2016 6:20:18 PM] Stack Description: java.lang.RuntimeException: Prerequisite check "CheckActiveFilesAndExecutables" failed. [Oct 6, 2016 6:20:18 PM] StackTrace: oracle.opatch.OPatchSessionHelper.runApplyPrereqs(OPatchSessionHelper.java:5765) [Oct 6, 2016 6:20:18 PM] StackTrace: oracle.opatch.opatchutil.NApply.legacy_process(NApply.java:905) [Oct 6, 2016 6:20:18 PM] StackTrace: oracle.opatch.opatchutil.NApply.legacy_process(NApply.java:367) [Oct 6, 2016 6:20:18 PM] StackTrace: oracle.opatch.opatchutil.NApply.process(NApply.java:362) [Oct 6, 2016 6:20:18 PM] StackTrace: oracle.opatch.opatchutil.OUSession.napply(OUSession.java:1084) [Oct 6, 2016 6:20:18 PM] StackTrace: sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [Oct 6, 2016 6:20:18 PM] StackTrace: sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [Oct 6, 2016 6:20:18 PM] StackTrace: sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [Oct 6, 2016 6:20:18 PM] StackTrace: java.lang.reflect.Method.invoke(Method.java:597) [Oct 6, 2016 6:20:18 PM] StackTrace: oracle.opatch.UtilSession.process(UtilSession.java:358) [Oct 6, 2016 6:20:18 PM] StackTrace: oracle.opatch.OPatchSession.process(OPatchSession.java:2515) [Oct 6, 2016 6:20:18 PM] StackTrace: oracle.opatch.OPatch.process(OPatch.java:796) [Oct 6, 2016 6:20:18 PM] StackTrace: oracle.opatch.OPatch.main(OPatch.java:846)
Such errors are very easy to fix on UNIX platform wherein we do have commands like ps, fuser or lsof to get details about the process accessing particular file. But what we can do for Windows platform.
I did check with widows admins to help me out here for identifying active processes. He told me about very intersting command “tasklist”.
Syntax: tasklist.exe /m <filename>
This command will give you details such as process name, PID & filename used by process as shown below:
So here I got the culprit. Now how to get rid of these processes. You can go to resource monitor under task manager to identify the process and then kill it as shown below:
Now you can apply patch without any issues.
As per my past experience, killing windows process manually can cause some serious issues after some time. So after killing any process manually on windows server, will recommend you to cleanly restart your server.
Hope so u will find this post very useful:-)
Cheers
Regards,
Adityanath
Categories: Administration, ORA errors
Adityanath's Oracle Blog 
What’s up to evｅry one, it’ѕ genuinely a fastidious for me
to go tо see tһis web page, it includes valuable Іnformation.
Everytһing is very open wіth a cleaг explanation of the issues.
It was Ԁefinitely informative. Үօur site іs uѕeful.
Many thаnks for sharing!
Pretty! This has been a really wonderful article.
Thanks for supplying this information.
Great site. Plenty of useful information here. I抦 sending it to a few friends ans also sharing in delicious. And of course, thanks for your effort!
Magnificent website. A lot of useful info here. I am sending it to some friends ans also sharing in delicious. And naturally, thanks for your effort!
Excellent pieces. Keep writing such kind of information on your
blog. Im really impressed by your site.
Hello there, You’ve done a great job. I’ll certainly digg it and
in my opinion suggest to my friends. I am confident they’ll be
benefited from this website.
Fantastic article.Thanks Again. Great.
This is my first time pay a visit at here and i am genuinely impressed
to read all at one place.
Very good article. I’m facing some of these issues as well..
Hey there, You’ve done an excellent job. I’ll definitely digg it and
personally suggest to my friends. I’m sure they will be benefited from this site.