Thursday, September 6, 2018

Oracle patch failed with “CheckActiveFilesAndExecutables” failed error

We are applying patch on Oracle 12c and we got Prerequisite check “CheckActiveFilesAndExecutables” failed error. By looking the error we can see that files are active and used by some active processes.


$opatch apply
.....
[Sep 6, 2018 6:56:10 PM] [INFO] Finish fuser command /sbin/fuser /oracle/product/12.1.0.2/dbhome_1/lib/libsrvm12.so at Thu Sep 06 18:56:10 PDT 2018
[Sep 6, 2018 6:56:10 PM] [SEVERE] OUI-67073:UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.
[Sep 6, 2018 6:56:10 PM] [INFO] Finishing UtilSession at Thu Sep 06 18:56:10 PDT 2018
[Sep 6, 2018 6:56:10 PM] [INFO] Log file location: /oracle/product/12.1.0.2/dbhome_1/cfgtoollogs/opatch/opatch2018-09-06_18-55-32PM_1.log
[Sep 6, 2018 6:56:10 PM] [INFO] Stack Description: java.lang.RuntimeException: Prerequisite check "CheckActiveFilesAndExecutables" failed.
at oracle.opatch.OPatchSessionHelper.runApplyPrereqs(OPatchSessionHelper.java:6670)
at oracle.opatch.opatchutil.NApply.legacy_process(NApply.java:988)
at oracle.opatch.opatchutil.NApply.legacy_process(NApply.java:363)
at oracle.opatch.opatchutil.NApply.process(NApply.java:343)
at oracle.opatch.opatchutil.OUSession.napply(OUSession.java:1105)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at oracle.opatch.UtilSession.process(UtilSession.java:359)
at oracle.opatch.OPatchSession.process(OPatchSession.java:2670)
at oracle.opatch.OPatch.process(OPatch.java:811)
at oracle.opatch.OPatch.main(OPatch.java:861)
Caused by: java.lang.RuntimeException: Prerequisite check "CheckActiveFilesAndExecutables" failed.
... 13 more
Caused by: oracle.opatch.PrereqFailedException: Prerequisite check "CheckActiveFilesAndExecutables" failed.
... 13 more

In the log file I see that below lib is active and used by some processes

[Sep 6, 2018 6:55:49 PM] [INFO] Following executables are active :
/oracle/product/12.1.0.2/dbhome_1/lib/libclntsh.so.12.1
[Sep 6, 2018 6:55:49 PM] [INFO] Prerequisite check "CheckActiveFilesAndExecutables" failed.
The details are:
Following executables are active :
/oracle/product/12.1.0.2/dbhome_1/lib/libclntsh.so.12.1
[Sep 6, 2018 6:55:49 PM] [INFO] Start fuser command /sbin/fuser /oracle/product/12.1.0.2/dbhome_1/bin/adrci at Thu Sep 06 18:55:49 PDT 2018

To find which process using below lib run below command and you will get the process id

$ /sbin/fuser /oracle/product/12.1.0.2/dbhome_1/lib/libclntsh.so.12.1
/oracle/product/12.1.0.2/dbhome_1/lib/libclntsh.so.12.1: 8631m

Find out the process that is active using below command

$ps –ef |grep 8631     
oracle     8631      1  0 Aug23 ?        00:02:22 /oracle/product/12.1.0.2/dbhome_1/bin/tnslsnr LISTENER_ORCL-inherit

Either you stop the processes or kill the process. Once the processes is stopped you can proceed with opatch again and it should be successful.

Note that after patch is successful check for “SEVERE” errors if any in the log file.

Thanks
Satishbabu Gunukula
http://www.oracleracexpert.com


45 comments:


  1. Awesome blog. It was very informative. I would like to appreciate you. Keep updated like this best selenium training institute in hyderabad

    ReplyDelete
  2. Click Here Best RPA Online Training to go to RPA Online Training Institute Details .

    ReplyDelete
  3. The actual time and effort took to create this wonderful article were really great and would like to read this blog regularly to get more updates...
    DevOps Training in Chennai | Oracle Online Training

    ReplyDelete
  4. I always enjoy reading quality articles by an individual who is obviously knowledgeable on their chosen subject. Ill be watching this post with much interest. Keep up the great work, I will be back

    Best Software Training Institute In Chennai | Best Software Online Training Institute In Chennai

    ReplyDelete

  5. I read this post. This post containing such a good post. Thanks for sharing. We are offering the services of Buddhist circuit train. You can visit the website for more information.
    Holy Buddha Tourism

    ReplyDelete
  6. Today I was riding in a bus and heard how the boys talked about this site. secure online casino sites Speak as if it’s cool for a couple of hours so much money decided to take a risk and really thank you guys

    ReplyDelete
  7. Thank you for sharing such a nice and interesting blog post. If anyone is going to travel from Chandigarh to Shimla or need a
    Chandigarh to Shimla Taxi Service then contact 1313 taxi chandigarh.

    ReplyDelete
  8. If your looking for Online Illinois license plate sticker renewals then you have need to come to the right place.We offer the fastest Illinois license plate sticker renewals in the state.
    Best Institutes For Digital Marketing in Hyderabad

    ReplyDelete
  9. Informative blog, thanks for posting.
    Digital Marketing Training in KPHB with 100% Internships & Job Assistance

    ReplyDelete
  10. Awesome dispatch! I am indeed getting apt to over this info, is truly neighborly my buddy. Likewise fantastic blog here among many of the costly info you acquire. Reserve up the beneficial process you are doing here. website

    ReplyDelete
  11. I read that Post and got it fine and informative. visit

    ReplyDelete
  12. What a fantabulous post this has been. Never seen this kind of useful post. I am grateful to you and expect more number of posts like these. Thank you very much. visit this site

    ReplyDelete
  13. This is very significant, and yet necessary towards just click this unique backlink: visit this site

    ReplyDelete
  14. Took me time to read all the comments, but I really enjoyed the article. It proved to be Very helpful to me and I am sure to all the commenters here! It’s always nice when you can not only be informed, but also entertained! Satta Disawar

    ReplyDelete
  15. I can recommend primarily decent and even responsible tips, as a result view it: read here

    ReplyDelete
  16. There you can download for free, see the first of these data. custom embroidered key tags

    ReplyDelete
  17. Its a great pleasure reading your post.Its full of information I am looking for and I love to post a comment that "The content of your post is awesome" Great work. visit this site

    ReplyDelete
  18. I exploit solely premium quality products -- you will observe these individuals on: houston patches

    ReplyDelete
  19. Karnataka PUC Question Paper 2023 According to Karnataka Secondary Education Examination Board KSEEB announcement of the 2nd PUC Model Question Paper for class 12th, Karnataka Board 2nd PUC examinations will be held from March,HP Board 12th Question Paper 2023 at its various center in all over the Karnataka state. The 2nd PUC Model Paper 2023 are expected to be declared by the board in the month of May.

    ReplyDelete
  20. اذا كنت من عشاق العاب الجريمة و المغامرات يمكنك تجربة تحميل لعبة جاتا 7 و الاستمتاع بي اللعبة و الدخول في جو المغامرات من خلال موقعنا تحميل العاب الكمبيوتر   يمكنك أيضا تحميل لعبة جاتا جميع الإصدارات .

    ReplyDelete
  21. Instant Cash Canada is a proud car title loans provider that offers hassle-free loans to people with instant approval, no credit checks, and the lowest interest rates. Customer satisfaction is most important to us which is why we offer you the to Pay off your loan at any time without Penalty. Get in touch now.

    ReplyDelete
  22. Beer Equipment’ renowned high-tech Draught Foam Control device such as Beer FOBs, the DFC 9500, and pacific beer stop beer flow immediately after a keg empties, both at the key and the tap. For more information visit our website.

    ReplyDelete
  23. GASTRO CARE AT CRITICARE HOSPITAL
    When you pick us, you get the most suitable hospital for gastrointestinal surgery. Our section of professionals is the Gastrointestinal specialists in Lucknow! who secure your health and well-being throughout the restorative procedure. Liver failure is a complaint that needs holistic consideration, which is why you bear the hefty hospital bill for the treatment of a hepatologist.

    ReplyDelete
  24. Do you require immediate money? Car title loans Kamloops might assist you in quickly obtaining the funds you require. You can obtain your funds within 24 hours through our quick and safe application process. Apply for our car title loans Kamloops today to get the financial assistance you require! Dial 1-866-840-7395 right away.

    ReplyDelete
  25. If you need money from Car Title Loans Victoria since your unexpected debts are making things difficult for you. You can get financial aid through Canadian Cash Solutions. You can take out a loan for up to $100,000 at the most affordable and low-interest rate possible. Visit our website or contact us right away at +(855) 622-8564 to learn more.

    ReplyDelete
  26. Nova is the Best Private Hospital in Lucknow among those few Top 5 Private Hospitals in Lucknow when it comes to providing services in reasonable figures and affordable by every class in society. The Nova best private hospital is committed to providing comprehensive, seamless facilities and services to its patients.

    ReplyDelete