Friday, August 9, 2013

Reason: Cannot apply patch due to fatal error & CheckActiveFilesAndExecutables failed

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

No comments:

Post a Comment