IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial
I got OPatch failed with error code 73 | Prerequisite check “CheckActiveFilesAndExecutables” failed During Opatch apply 30698487.
OPatch failed with error code 73 | Prerequisite check
Details of error are as follows.
[MSD1]/home/oracle/patch/30698487 $ opatch apply Oracle Interim Patch Installer version 12.2.0.1.17 Copyright (c) 2020, Oracle Corporation. All rights reserved. Oracle Home : /u01/app18c Central Inventory : /u01/app/oraInventory from : /u01/app18c/oraInst.loc OPatch version : 12.2.0.1.17 OUI version : 12.2.0.4.0 Log file location : /u01/app18c/cfgtoollogs/opatch/opatch2020-03-25_21-54-35PM_1.log Verifying environment and performing prerequisite checks... Prerequisite check "CheckActiveFilesAndExecutables" failed. The details are: Following active executables are not used by opatch process : /u01/app18c/lib/libclntsh.so.18.1 Following active executables are used by opatch process : UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed. Log file location: /u01/app18c/cfgtoollogs/opatch/opatch2020-03-25_21-54-35PM_1.log OPatch failed with error code 73 [MSD1]/home/oracle/patch/30698487 $
Prerequisite check “CheckActiveFilesAndExecutables” failed
Check if database is closed or not.
[MSD1]/home/oracle/patch/30698487 $ [MSD1]/home/oracle/patch/30698487 $ srvctl stop database -d MSD PRCC-1016 : MSD was already stopped
Find the /u01/app18c/lib/libclntsh.so.18.1 process.
[MSD1]/home/oracle/patch/30698487 $ /sbin/fuser /u01/app18c/lib/libclntsh.so.18.1
/u01/app18c/lib/libclntsh.so.18.1: 142115m
You have new mail in /var/spool/mail/oracle
[MSD1]/home/oracle/patch/30698487 $
Find the related active process and kill it.
[MSD1]/home/oracle/patch/30698487 $ ps -ef | grep 142115 oracle 142115 141723 0 21:21 pts/15 00:00:00 sqlplus as sysdba oracle 351369 154903 0 21:58 pts/17 00:00:00 grep 142115 [MSD1]/home/oracle/patch/30698487 $ [MSD1]/home/oracle/patch/30698487 $ [MSD1]/home/oracle/patch/30698487 $ kill -9 142115 [MSD1]/home/oracle/patch/30698487 $ [MSD1]/home/oracle/patch/30698487 $ [MSD1]/home/oracle/patch/30698487 $ ps -ef | grep 142115 oracle 352237 154903 0 21:58 pts/17 00:00:00 grep 142115 [MSD1]/home/oracle/patch/30698487 $
Try Opatch apply again.
[MSD1]/home/oracle/patch/30698487 $ opatch apply Oracle Interim Patch Installer version 12.2.0.1.17 Copyright (c) 2020, Oracle Corporation. All rights reserved. Oracle Home : /u01/app18c Central Inventory : /u01/app/oraInventory from : /u01/app18c/oraInst.loc OPatch version : 12.2.0.1.17 OUI version : 12.2.0.4.0 Log file location : /u01/app18c/cfgtoollogs/opatch/opatch2020-03-25_21-58-48PM_1.log Verifying environment and performing prerequisite checks... Prerequisite check "CheckActiveFilesAndExecutables" failed. The details are: Following active executables are not used by opatch process : /u01/app18c/lib/libclntsh.so.18.1 Following active executables are used by opatch process : UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed. Log file location: /u01/app18c/cfgtoollogs/opatch/opatch2020-03-25_21-58-48PM_1.log OPatch failed with error code 73 You have new mail in /var/spool/mail/oracle [MSD1]/home/oracle/patch/30698487 $
Now find the active process again and kill it.
[MSD1]/home/oracle/patch/30698487 $ [MSD1]/home/oracle/patch/30698487 $ /sbin/fuser /u01/app18c/lib/libclntsh.so.18.1 /u01/app18c/lib/libclntsh.so.18.1: 353881m 354034m 355428m 355948m You have new mail in /var/spool/mail/oracle [MSD1]/home/oracle/patch/30698487 $ [MSD1]/home/oracle/patch/30698487 $ [MSD1]/home/oracle/patch/30698487 $ ps -ef | grep 354034 oracle 354034 354030 0 21:59 ? 00:00:00 /u01/app18c/bin/sqlplus -s oracle 356300 154903 0 22:00 pts/17 00:00:00 grep 354034 [MSD1]/home/oracle/patch/30698487 $ [MSD1]/home/oracle/patch/30698487 $ kill -9 354034 [MSD1]/home/oracle/patch/30698487 $
Opatch apply
Now run Opatch apply again.
[MSD1]/home/oracle/patch/30698487 $ [MSD1]/home/oracle/patch/30698487 $ opatch apply Oracle Interim Patch Installer version 12.2.0.1.17 Copyright (c) 2020, Oracle Corporation. All rights reserved. Oracle Home : /u01/app18c Central Inventory : /u01/app/oraInventory from : /u01/app18c/oraInst.loc OPatch version : 12.2.0.1.17 OUI version : 12.2.0.4.0 Log file location : /u01/app18c/cfgtoollogs/opatch/opatch2020-03-25_22-01-25PM_1.log Verifying environment and performing prerequisite checks... -------------------------------------------------------------------------------- Start OOP by Prereq process. Launch OOP... Oracle Interim Patch Installer version 12.2.0.1.17 Copyright (c) 2020, Oracle Corporation. All rights reserved. Oracle Home : /u01/app18c Central Inventory : /u01/app/oraInventory from : /u01/app18c/oraInst.loc OPatch version : 12.2.0.1.17 OUI version : 12.2.0.4.0 Log file location : /u01/app18c/cfgtoollogs/opatch/opatch2020-03-25_22-01-44PM_1.log Verifying environment and performing prerequisite checks... OPatch continues with these patches: 30698487 Do you want to proceed? [y|n] Y (auto-answered by -silent) User Responded with: Y All checks passed. Please shutdown Oracle instances running out of this ORACLE_HOME on the local system. (Oracle Home = '/u01/app18c') Is the local system ready for patching? [y|n] Y (auto-answered by -silent) User Responded with: Y Backing up files... Applying interim patch '30698487' to OH '/u01/app18c' Patching component oracle.rdbms.rman, 18.0.0.0.0... Patching component oracle.rdbms, 18.0.0.0.0... Patching component oracle.rdbms.dbscripts, 18.0.0.0.0... Patching component oracle.rdbms.rsf, 18.0.0.0.0... Patching component oracle.rdbms.util, 18.0.0.0.0... Patch 30698487 successfully applied. Log file location: /u01/app18c/cfgtoollogs/opatch/opatch2020-03-25_22-01-44PM_1.log OPatch succeeded. You have new mail in /var/spool/mail/oracle [MSD1]/home/oracle/patch/30698487 $
Patch is applied successfully.
Check it as follows.
[MSD1]/home/oracle/patch/30698487 $ opatch lsinventory | grep 30698487 Patch 30698487 : applied on Wed Mar 25 22:02:04 EET 2020 [MSD1]/home/oracle/patch/30698487 $
Everything is OK now.
If you want to Upgrade OPatch utility, you can read the following useful post.
If you want to learn more details about Patching Oracle database, read the following post.
Do you want to learn Oracle Database for Beginners, then Click and read the following articles.
Oracle Database Tutorials for Beginners ( Junior Oracle DBA )
