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
Tremendous issues here. I’m very glad to peer your post.
Thank you a lot and I’m having a look forward to contact you.
Will you please drop me a e-mail?
Hello There,
Thanks for visiting and appreciate your feedback.:-)
Regards,
Adi
An impressive share! I have just forwarded this onto a
colleague who was doing a little research on this. And he in fact bought me lunch due to the fact that I discovered it for him…
lol. So allow me to reword this…. Thank YOU for the meal!!
But yeah, thanx for spending time to talk about this matter here on your web
site.
Hello There,
Thanks for visiting and appreciate your feedback.:-)
Regards,
Adi
I have been surfing on-line more than 3 hours as of late, but I by no means discovered any interesting article like yours. It’s pretty value sufficient for me. Personally, if all webmasters and bloggers made good content material as you did, the internet will be a lot more helpful than ever before.
Hello There,
Thanks for visiting and appreciate your feedback.:-)
Regards,
Adi
Thanks for finally talking about >OUI-67073:UtilSession failed: Prerequisite check
“CheckActiveFilesAndExecutables” failed on Windows server | Adityanath’s
Oracle Blog <Loved it!
Hello There,
Thanks for visiting and appreciate your feedback.:-)
Regards,
Adi
I think this is one of the most important info for me. And
i am glad reading your article. But want to remark
on few general things, The web site style is perfect, the articles is really excellent
: D. Good job, cheers
Hello There,
Thanks for visiting and appreciate your feedback.:-)
Regards,
Adi
If you would like to increase your knowledge simply keep visiting this
web page and be updated with the hottest
information posted here.
I know this site gives quality based articles or reviews and other stuff, is there any other site
which presents such information in quality?
Hello, the whole thing is going fine here and ofcourse every one is sharing facts,
that’s in fact good, keep up writing.
I’m extremely impressed with your writing skills as well as
with the layout on your weblog. Is this a
paid theme or did you customize it yourself? Anyway keep up the nice quality writing, it is rare to see a great blog like this one nowadays.
Hey there just wanted to give you a quick heads up and let you know a few of the
images aren’t loading properly. I’m not sure why but
I think its a linking issue. I’ve tried it in two different browsers and both show the same results.
Its like you read my mind! You seem to grasp a
lot approximately this, such as you wrote the e-book in it or something.
I feel that you can do with a few percent to pressure the message house
a little bit, but other than that, this is fantastic blog.
An excellent read. I will definitely be back.
Hi there! This post couldn’t be written any better!
Reading through this post reminds me of my previous roommate!
He continually kept preaching about this. I’ll forward this post to him.
Pretty sure he will have a great read. Thanks for sharing!
Hello my friend! I want to say that this article is amazing, great written and include almost all vital infos.
I would like to see extra posts like this .
I’d like to thank you for the efforts you have put in penning this website.
I’m hoping to view the same high-grade blog posts from you
later on as well. In fact, your creative writing abilities
has inspired me to get my very own website now 😉
It’s really a nice and useful piece of info. I am glad that you just shared this useful information with us.
Please stay us informed like this. Thank you for sharing.
Appreciating the dedication you put into your website and detailed information you offer.
It’s nice to come across a blog every once in a while that isn’t the
same unwanted rehashed information. Wonderful read! I’ve bookmarked your site and I’m adding your RSS feeds to
my Google account.
Hi to every , as I am genuinely eager of reading this website’s post to be updated regularly.
It consists of pleasant stuff.
I was suggested this website by my cousin. I’m not sure whether this post is written by him as nobody else know
such detailed about my difficulty. You are wonderful!
Thanks!
Useful info. Fortunate me I discovered your site by accident, and I’m surprised why this accident did
not happened in advance! I bookmarked it.
This is my first time go to see at here and i am in fact pleassant to read all at one place.
You are so awesome! I do not suppose I’ve truly read something
like this before. So good to find somebody with some original thoughts on this issue.
Really.. thank you for starting this up. This website is one thing that is
needed on the internet, someone with some originality!
I really like it when folks get together and share views.
Great site, keep it up!
Excellent post. I was checking continuously this weblog and I am impressed!
Extremely helpful info specifically the closing part 🙂 I take care of such info a lot.
I was looking for this certain info for a long time.
Thanks and good luck.
After checking out a few of the blog posts on your site, I honestly appreciate your technique of writing a blog.
I saved as a favorite it to my bookmark website list and will be checking back in the near future.
Please check out my web site too and let me know your opinion.
I delight in, cause I found exactly what I used to be
looking for. You’ve ended my four day lengthy hunt! God Bless you man. Have a great day.
Bye
Hi there! Do you use Twitter? I’d like to follow you if that would be
ok. I’m definitely enjoying your blog and look forward to
new updates.
Usually I don’t read article on blogs, however I would like
to say that this write-up very forced me to take a look at and do so!
Your writing style has been amazed me. Thank you, very nice
post.
Excellent site you’ve got here.. It’s hard to
find excellent writing like yours nowadays. I truly appreciate individuals like you!
Take care!!
I just like the valuable info you provide in your articles.
I will bookmark your weblog and test again right here regularly.
I am quite certain I will learn plenty of new stuff
proper right here! Best of luck for the next!
Wow that was odd. I just wrote an incredibly long comment but after I clicked submit my comment didn’t appear. Grrrr… well I’m not writing all that over again. Anyways, just wanted to say fantastic blog!
Hello There,
Thanks for visiting and appreciate your feedback.:-)
Regards,
Adi
Amazing! This blog looks just like my old one! It’s on a totally different topic but it has pretty much the same layout and design. Superb choice of colors!
Hi there! I’m at work surfing around your blog from my new iphone! Just wanted to say I love reading your blog and look forward to all your posts! Keep up the excellent work!
I抦 not that much of a online reader to be honest but your blogs really nice, keep it up! I’ll go ahead and bookmark your website to come back down the road. Many thanks
Hey! Do you use Twitter? I’d like to follow you if that would be ok. I’m absolutely enjoying your blog and look forward to new posts.
Thanks for ones marvelous posting! I seriously enjoyed reading it, you can be a great author.I will be sure to bookmark your blog and will eventually come back later in life. I want to encourage you continue your great work, have a nice evening!
This is my first time go to see at here and i
am actually pleassant to read everthing at one place.
These are truly fantastic ideas in about blogging.
You have touched some good things here. Any way keep up wrinting.
Great post. I was checking continuously this blog and I’m impressed!
Extremely helpful information particularly the last part 🙂 I care
for such info a lot. I was seeking this particular
information for a very long time. Thank you and best of luck.
It’s remarkable in favor of me to have a web site, which is good in favor of my knowledge.
thanks admin
Good info. Lucky me I discovered your website by accident (stumbleupon).
I have bookmarked it for later!
Pretty! This has been an extremely wonderful article. Thank you for supplying this information.
Thanks for sharing your info. I really appreciate your efforts and I will be waiting for your further write ups thanks once again.
Hope you’ll write more such awesome content in future too.
Having read this I thought it was extremely enlightening.
I appreciate you taking the time and energy to put this information together.
I once again find myself spending a significant amount of time both reading and posting comments.
But so what, it was still worth it!
I’m still learning from you, but I’m trying to achieve my goals. I certainly liked reading everything that is written on your website.Keep the posts coming. I enjoyed it!
Hello to every , since I am really eager
of reading this web site’s post to be updated on a regular basis.
It consists of good data.
Like!! I blog frequently and I really thank you for your content. The article has truly peaked my interest.
Major thanks for the blog article.Much thanks again. Really Cool.
Awesome 🙂