Error Description

Database Tier patch 24911308 failed to get applied

Oracle Interim Patch Installer version 12.1.0.1.10 Copyright (c) 2017, Oracle Corporation. All rights reserved. 

Oracle Home : /u01/oracle/VIS/12.1.0 

Central Inventory : /u01/oraInventory from : /u01/oracle/VIS/12.1.0/oraInst.loc 

OPatch version : 12.1.0.1.10 

OUI version : 12.1.0.2.0 

Log file location : /u01/oracle/VIS/12.1.0/cfgtoollogs/opatch/24911308_Jun_02_2017_10_52_41/apply2017-06-02_10-52-41AM_1.log Verifying environment and performing prerequisite checks... 

Conflicts/Supersets for each patch are: 

Patch : 24911308 Bug Superset of 21443504 Super set bugs are: 20825533, 20413820, 20245930, 20936905, 18964939, 19487147, 19536415, 20588502, 21091431, 18674024 

Patches [ 21443504 ] will be rolled back. 

Prerequisite check "CheckActiveFilesAndExecutables" failed. 

The details are: 

Following executables are active : /u01/oracle/VIS/12.1.0/lib/libclntsh.so.12.1 UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed. Log file location: /u01/oracle/VIS/12.1.0/cfgtoollogs/opatch/24911308_Jun_02_2017_10_52_41/apply2017-06-02_10-52-41AM_1.log OPatch failed with error code 73

Solution

Step 1. Find out which process is using the library libclntsh.so.12.1 

[root@ebs1225 12.1.0.2]# /sbin/fuser /u01/oracle/VIS/12.1.0/lib/libclntsh.so.12.1 

/u01/oracle/VIS/12.1.0/lib/libclntsh.so.12.1: 8428m 

[root@ebs1225 12.1.0.2]# ps -eaf|grep 8428 

oravis 8428 1 0 10:06 ? 00:00:00 /u01/oracle/VIS/12.1.0/bin/tnslsnr LISTENER -inherit 

root 12651 8531 0 11:00 pts/2 00:00:00 grep 8428 

Step 2. So it is the TNS Listner using the library 

Step 3. Kill the above process [root@ebs1225 12.1.0.2]# kill -9 8428 [root@ebs1225 12.1.0.2]# /sbin/fuser /u01/oracle/VIS/12.1.0/lib/libclntsh.so.12.1 

Step 4. Reapply the patch using opatch apply and it will go through

Environment

1. Oracle E-Business Suite Release 12.2.0 - DB Tier Patch

2. Oracle Linux x86-64 Operating System