Pages

Sunday, May 25, 2025

Unable to obtain current patch information, Latest xml inventory is not loaded into table, RawInventory gets null OracleHomeInfo

==================
Error
==================
Unable to obtain current patch information due to error: 20001, ORA-20001: Latest xml inventory is not loaded into table
ORA-06512: at "SYS.DBMS_QOPATCH", line 2327
ORA-06512: at "SYS.DBMS_QOPATCH", line 854
ORA-06512: at "SYS.DBMS_QOPATCH", line 937
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "SYS.DBMS_QOPATCH", line 932
ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-29400: data cartridge error
KUP-04095: preprocessor command /software/oracle/19c/QOpatch/qopiprep.bat encountered error "LsInventorySession failed: RawInventory gets null OracleHomeInfo
"
ORA-06512: at "SYS.DBMS_QOPATCH", line 919
ORA-06512: at "SYS.DBMS_QOPATCH", line 2286
ORA-06512: at "SYS.DBMS_QOPATCH", line 817
ORA-06512: at "SYS.DBMS_QOPATCH", line 2309


==================
Debug
==================
oracle@hostname:/software/oracle/19c/OPatch>%./opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.41
Copyright (c) 2025, Oracle Corporation.  All rights reserved.


Oracle Home       : /software/oracle/19c
Central Inventory : /software/oracle/oraInventory
   from           : /software/oracle/19c/oraInst.loc
OPatch version    : 12.2.0.1.41
OUI version       : 12.2.0.7.0
Log file location : /software/oracle/19c/cfgtoollogs/opatch/opatch2025-05-25_08-12-01AM_1.log

List of Homes on this system:

  Home name= OraDB19Home1, Location= "/software/oracle/1910"
LsInventorySession failed: RawInventory gets null OracleHomeInfo

OPatch failed with error code 73
oracle@hostname:/software/oracle/19c/OPatch>%

==================
Fix
==================
Edit OraDB19Home1 to correct value /software/oracle/19c

vi /software/oracle/oraInventory/ContentsXML/inventory.xml
<HOME_LIST>
<HOME NAME="OraDB19Home1" LOC="/software/oracle/1910" TYPE="O" IDX="1"/>
</HOME_LIST>

<HOME_LIST>
<HOME NAME="OraDB19Home1" LOC="/software/oracle/19c" TYPE="O" IDX="1"/>
</HOME_LIST>

No comments:

Post a Comment