We have seen below error when user applying latest SBP patch on Oracle 11.2.0.3 Database .
$ env ORACLE_HOME=$IHRDBMS $IHRDBMS/MOPatch/mopatch.sh -v -s SAP_112036_201306_LINX8664.zip
Running prerequisite check "CheckMultipleTranslationPatches" ... UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.Prerequisite check "CheckActiveFilesAndExecutables" failed.
Log file location: /oracle/RACP/112_64/cfgtoollogs/opatch/opatch2013-07-24_17-44-07PM_1.log
OPatch failed with error code 73
Processing patch "SAP_112036_201306_LINX8664.zip!16056266!16056266"...failed.
Reason: Cannot apply patch due to fatal error.
In mopatch or opatch log file, user will not find enough information except “Reason: Cannot apply patch due to fatal error”. The log file mention in the mopatch log will have reason for failure.
Contents from log file /oracle/RACP/112_64/cfgtoollogs/opatch/opatch2013-07-24_17-44-07PM_1.log
[Jul 24, 2013 5:37:13 PM] Following executables are active :
/oracle/RACP/112_64/lib/libclntsh.so.11.1
[Jul 24, 2013 5:37:13 PM] Prerequisite check "CheckActiveFilesAndExecutables" failed.
…………………
[Jul 24, 2013 5:37:13 PM] OUI-67073:UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.Prerequisite check "CheckActiveFilesAndExecutables" failed.
Opatch or Mopatch needs to modify some files which are still being used by some process. As you see one of the Oracle library is still active.
Find out the process which is still actively using the library /oracle/RACP/112_64/lib/libclntsh.so.11.1 and kill or stop the process.
$ /sbin/fuser /oracle/RACP/112_64/lib/libclntsh.so.11.1
/oracle/RACP/112_64/lib/libclntsh.so.11.1: 9785m
$ ps –ef |grep 9785
oraracp 9785 1 0 Jul24 ? 00:02:39 /oracle/RACP/112_64/bin/tnslsnr LISTENER_RACP -inherit
oraracp 19813 7919 0 17:25 pts/2 00:00:00 grep 9785
$ lsnrctl stop LISTENER_RACP
Or
$ kill -9 9785
The listener process is still running and causing the issue. We have stopped the listener process and reapplied the patch successfully.
Regards,
Satisbabu Gunukula, Oracle ACE
http://www.oracleracexpert.com
Subscribe to:
Post Comments (Atom)
Great and Useful Article.
ReplyDeleteJava Online Training
Java Course Online
Java EE course
Java Course in Chennai
Java Training in Chennai
Java Training Institutes in Chennai
Java Interview Questions
Java Interview Questions
شركة نقل عفش بالرياض وجدة والدمام والخبر والجبيل اولقطيف والاحساء والرياض وجدة ومكة المدينة المنورة والخرج والطائف وخميس مشيط وبجدة افضل شركة نقل عفش بجدة نعرضها مجموعة الفا لنقل العفش بمكة والخرج والقصيم والطائف وتبوك وخميس مشيط ونجران وجيزان وبريدة والمدينة المنورة وينبع افضل شركات نقل الاثاث بالجبيل والطائف وخميس مشيط وبريدة وعنيزو وابها ونجران المدينة وينبع تبوك والقصيم الخرج حفر الباطن والظهران
ReplyDeleteشركة نقل عفش بجدة
شركة نقل عفش بالمدينة المنورة
شركة نقل اثاث بالرياض