OPatch failed with error code 73 | Prerequisite check “CheckActiveFilesAndExecutables” failed During Opatch apply 30698487

Hi,

I got OPatch failed with error code 73 | Prerequisite check “CheckActiveFilesAndExecutables” failed During Opatch apply 30698487.

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 $

 

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 $ 

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.

 

 

 818 views last month,  10 views today

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience. I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource. I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks. I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients. If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress mehmetsalih.deveci@outlook.com. -                                                                                                                                                                                                                                                 - Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  mehmetsalih.deveci@outlook.com a mail atabilirsiniz.

Check Also

blank

ORA-01438: value larger than specified precision allowed for this column

Hi, I got ” ORA-01438: value larger than specified precision allowed for this column” error …

Leave a Reply