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:
Post a Comment