Prerequisite check “CheckActiveFilesAndExecutables” failed

Today i was trying to remove the Oracle Patch (21352646) from 11.2.0.4 HOME and Database which was recently applied by me on one of our test instance, however i faced the problem while doing that.

=============================================================

[oracle@testdb 21352646]$ $ORACLE_HOME/OPatch/opatch nrollback -idFile $ORACLE_HOME/cpu/CPUOct2015/rollback_all.lst
Oracle Interim Patch Installer version 11.2.0.3.12
Copyright (c) 2015, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0/dbhome_2
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/dbhome_2/oraInst.loc
OPatch version : 11.2.0.3.12
OUI version : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/dbhome_2/cfgtoollogs/opatch/opatch2015-11-24_04-27-28AM_1.log
Patches will be rolled back in the following order:
17811429 17811438 17811447 18203835 18203837 18203838 19463893 19544839 19584068 19972564 19972566 19972568 19972569 20142975 20506699 20506715 20631274 21051833 21051840 21051852 21051858 21051862 21179898 21352646 21538485 21538558 21538567
Prerequisite check “CheckActiveFilesAndExecutables” failed.
The details are:
Following executables are active :
/u01/app/oracle/product/11.2.0/dbhome_2/lib/libclntsh.so.11.1
UtilSession failed: Prerequisite check “CheckActiveFilesAndExecutables” failed.
Log file location: /u01/app/oracle/product/11.2.0/dbhome_2/cfgtoollogs/opatch/opatch2015-11-24_04-27-28AM_1.log

OPatch failed with error code 73
[oracle@testdb 21352646]$

=============================================================

After a bit troubleshooting, i understood that some application is there which is trying to access library from the ORACLE HOME because of that this is happening, however i shutdown all the instances from the ORACLE HOME.

So to find out i executed the below command to find out which application/program is using it:

=============================================================

[oracle@testdb 21352646]$ /sbin/fuser /u01/app/oracle/product/11.2.0/dbhome_2/lib/libclntsh.so.11.1
/u01/app/oracle/product/11.2.0/dbhome_2/lib/libclntsh.so.11.1: 20860m
[oracle@testdb 21352646]$

=============================================================

This way i came to know which Process ID is being assigned.

=============================================================

[oracle@testdb 21352646]$ ps -eaf|grep 20860
oracle 20860 12838 0 04:08 pts/0 00:00:00 sqlplus as sysdba
oracle 22913 21168 0 04:31 pts/1 00:00:00 grep 20860
[oracle@testdb 21352646]$

=============================================================

So SQLPLUS is using it, however everything was down, and then i saw there is 1 Putty Session which got inactive but made this library is in active mode somehow.

So i killed the process related to sqlplus and again executed the command to find out.

=============================================================

[oracle@testdb 21352646]$ kill -9 20860
[oracle@testdb 21352646]$ /sbin/fuser /u01/app/oracle/product/11.2.0/dbhome_2/lib/libclntsh.so.11.1
[oracle@testdb 21352646]$

=============================================================

So its gone, now when i again executed the previous command to remove the patch, it went well.

Let me know if it does not for anyone.

Thanks!

Hope it helps….

 

 

 

 

Advertisements

2 thoughts on “Prerequisite check “CheckActiveFilesAndExecutables” failed

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s