opatch performance

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Sun, 20 Oct 2024 21:57:08 -0400
Message-ID: <fa03c48a-25f8-40e6-aef5-e8ec96eec826_at_gmail.com>



  

    
  
  
    

I have upgraded my databases today. I know I am lazy and that the DBRU came out on Tuesday, 10/15/2024, but that's OK. Laziness is a virtue in the IT world. However, this list is not about my mom's mistakes in my upbringing or my psychological traits, it's about Oracle. My databases are running on VirtualBox VMs, several of them. I noticed that on Oracle 19c, opatch took more than 1:30 hours just to check the requirements. After the requirements were checked, the rest went fine, but one hour thirty minutes just to check the requirements? Here is a sample:

bash-4.2$ time $ORACLE_HOME/OPatch/opatch apply
Oracle Interim Patch Installer version 12.2.0.1.44
Copyright (c) 2024, Oracle Corporation.  All rights reserved.


Oracle Home       : /opt/oracle/product/19c/dbhome_1
Central Inventory : /opt/oracle/oraInventory
   from           : /opt/oracle/product/19c/dbhome_1/oraInst.loc
OPatch version    : 12.2.0.1.44
OUI version       : 12.2.0.7.0
Log file location : /opt/oracle/product/19c/dbhome_1/cfgtoollogs/opatch/opatch2024-10-20_21-18-07PM_1.log

Verifying environment and performing prerequisite checks...
^C
OPatch failed with error code 130

real    35m58.373s
user    36m58.117s
sys    0m6.585s

This is not the whole thing, I broke it after 35 min with '^C". Does anyone have any explanation or will I have to spend an evening doing "strace"?

--
Mladen Gogala
Database Consultant
https://dbwhisperer.wordpress.com
-- http://www.freelists.org/webpage/oracle-l Received on Mon Oct 21 2024 - 03:57:08 CEST

Original text of this message