OUI-67073:UtilSession failed: Prerequisite check “CheckActiveFilesAndExecutables” failed on Windows server

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:

blog-1
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:

blog-2
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

65 replies

  1. What’s up to every one, it’ѕ genuinely a fastidious for me
    to go tо see tһis web page, it includes valuable Іnformation.

  2. 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!

  3. 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!

  4. 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!

  5. 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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s