Prerequisite check “CheckActiveFilesAndExecutables” failed while applying JAN RU 2019 on 12.2 database

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

[Apr 13, 2019 4:11:41 AM] [INFO]    Following executables are active :

                                    /app/oracle/product/12.2.0.1/dbhome1/lib/libclntsh.so.12.1

[Apr 13, 2019 4:11:41 AM] [INFO]    Prerequisite check "CheckActiveFilesAndExecutables" failed.

                                    The details are:

                                    Following executables are active :

                                    /app/oracle/product/12.2.0.1/dbhome1/lib/libclntsh.so.12.1

[Apr 13, 2019 4:11:41 AM] [SEVERE]  OUI-67073:UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.

[Apr 13, 2019 4:11:41 AM] [INFO]    Finishing UtilSession at Sat Apr 13 04:11:41 EDT 2019

[Apr 13, 2019 4:11:41 AM] [INFO]    Log file location: /app/oracle/product/12.2.0.1/dbhome1/cfgtoollogs/opatchauto/core/opatch/opatch2019-04-13_04-11-13AM_1.log

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@host05](+ASM)$ /sbin/fuser /usr/oracle/product/12.2.0.1/dbhome1/lib/libclntsh.so.12.1

/usr/oracle/product/12.2.0.1/dbhome1/lib/libclntsh.so.12.1:  6161m

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

[oracle@host05](+ASM)$ ps -ef|grep 6161

oracle    6161 25365  0 Mar10 pts/1    00:00:07 sqlplus   as sysdba

oracle    9150 28789  0 04:15 pts/2    00:00:00 grep --color=auto 6161

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@host05](+ASM)$ kill -9 6161

/home/oracle

[oracle@host05](+ASM)$ /sbin/fuser /app/oracle/product/12.2.0.1/dbhome1/lib/libclntsh.so.12.1

/home/oracle

[oracle@ora05](+ASM)$ 

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….