Monday, 3 November 2014

Opatch Failed error code 73: OUI-67073: UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables"



Upgrade error from 11.2.0.2 to 11.2.0.4


Error Description:
Oracle SPU / CPU patch deployment using Opatch filed with following error message.
Following executables are active :
/u01/app/oracle/product/11.2.0.2/home/lib/libclntsh.so.11.1
 UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.
Log file location: /u01/app/oracle/product/11.2.0.2/home/cfgtoollogs/opatch/opatch2014-9-14_12-10-00PM.log

OPatch failed with error code 73

Cause: there are some files which are locked or some processes still running while applying patch . those should be avoided
--------------------------------------------------------------------------------------------------------------------------


Full Error in log:

[Nov 22, 2014 2:10:20 PM]    Finish fuser command /sbin/fuser /u01/app/oracle/product/11.2.0.2/home/lib/libclntsh.so.11.1 at Fri Nov 22 14:10:20 CET 2014
[Nov 22, 2014 2:10:20 PM]    Following executables are active:
                             /u01/app/oracle/product/11.2.0.2/home/lib/libclntsh.so.11.1
[Nov 22, 2014 2:10:20 PM]    Prerequisite check "CheckActiveFilesAndExecutables" failed.
                             The details are:
                             Following executables are active:
                            /u01/app/oracle/product/11.2.0.2/home/lib/libclntsh.so.11.1
[Nov 22, 2014 2:10:20 PM]    OUI-67073:UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.
[Nov 22, 2014 2:10:20 PM]    Finishing UtilSession at Fri Nov 22 14:10:20 CET 2014
 --------------------------------------------------------------------------------------------------------------------------
Solution Description

This error is simple. Firstly make sure DB and listener are down . 

Solution 1:
some processes are still in running .to find out them try
ps -ef|grep db_name
then kill each process by  using   kill -9 1196 command
Solution 2:
check which process is locking this library file using below command and kill it
$ /sbin/fuser /u01/app/oracle/product/11.2.0.2/home/lib/libclntsh.so.11.1
/u01/app/oracle/product/11.2.0.2/home/lib/libclntsh.so.11.1:  1196m 2215m
 $ kill -9 1196



now run opatch apply


Cheers.....!!!!

No comments:

ORA-600 [kwqitnmphe:ltbagi], [1], [0] reported in the alert log file.

ORA-00600 [kwqitnmphe:ltbagi] Cause: This issue arises in 12.1.0.2. The error occurs because there are still Historical Messages without...