Por alguma razão quando o $ORACLE_HOME é removido do inventário, o DBA irá encontrar o erro “Inventory load failed… OPatch cannot load inventory for the given Oracle Home” quando se tentar executar o utilitário do opatch (localizado em $ORACLE_HOME/OPatch/opatch) para verificar os patches aplicados no ambiente de banco de dados Oracle.
Com isso, neste post estarei exemplificando como resolver este problema.
Causa raíz: Por alguma razão o $ORACLE_HOME foi removido do inventário.
Solucao: Simplesmente adicione novamente o ORACLE_HOME ao inventário do banco de dados Oracle.
(Exemplo para 3 ORACLE_HOME de 3 versoes diferentes 11.2.0.3, 11.2.0.4 e 12.1.02:
$ORACLE_HOME/oui/bin/runInstaller -silent -attachHome ORACLE_HOME=/opt/oracle/product/11203 ORACLE_HOME_NAME=dbhome11203 -invPtrLoc /etc/oraInst.loc $ORACLE_HOME/oui/bin/runInstaller -silent -attachHome ORACLE_HOME=/opt/oracle/product/11204 ORACLE_HOME_NAME=dbhome11204 -invPtrLoc /etc/oraInst.loc $ORACLE_HOME/oui/bin/runInstaller -silent -attachHome ORACLE_HOME=/opt/oracle/product/12102 ORACLE_HOME_NAME=dbhome12102 -invPtrLoc /etc/oraInst.loc
Exemplo / DEMO:
PROBLEM:
techdatabasketserver brunodb/opt/oracle $ /opt/oracle/product/12102/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 12.1.0.1.5
Copyright (c) 2017, Oracle Corporation. All rights reserved.
Oracle Home : /opt/oracle/product/12102
Central Inventory : /opt/oracle/oraInventory12102
from : /opt/oracle/product/12102/oraInst.loc
OPatch version : 12.1.0.1.5
OUI version : 12.1.0.2.0
Log file location : /opt/oracle/product/12102/cfgtoollogs/opatch/opatch2017-09-22_20-05-08PM_1.log
OPatch failed to locate Central Inventory.
Possible causes are:
The Central Inventory is corrupted
The oraInst.loc file specified is not valid.
LsInventorySession failed: OPatch failed to locate Central Inventory.
Possible causes are:
The Central Inventory is corrupted
The oraInst.loc file specified is not valid.
OPatch failed with error code 73
Plano de Ação:
techdatabasketserver brunodb/opt/oracle $ $ORACLE_HOME/oui/bin/runInstaller -silent -attachHome ORACLE_HOME=/opt/oracle/product/12102 ORACLE_HOME_NAME=dbhome12102 -invPtrLoc /etc/oraInst.loc Starting Oracle Universal Installer... Checking swap space: must be greater than 500 MB. Actual 24575 MB Passed The inventory pointer is located at /etc/oraInst.loc 'AttachHome' was successful.
Check:
techdatabasketserver brunodb/opt/oracle $ /opt/oracle/product/12102/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 12.1.0.1.5
Copyright (c) 2017, Oracle Corporation. All rights reserved.
Oracle Home : /opt/oracle/product/12102
Central Inventory : /opt/oracle/oraInventory
from : /opt/oracle/product/12102/oraInst.loc
OPatch version : 12.1.0.1.5
OUI version : 12.1.0.2.0
Log file location : /opt/oracle/product/12102/cfgtoollogs/opatch/opatch2017-09-22_20-06-23PM_1.log
Lsinventory Output file location : /opt/oracle/product/12102/cfgtoollogs/opatch/lsinv/lsinventory2017-09-22_20-06-23PM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Database 12c 12.1.0.2.0
There are 1 products installed in this Oracle Home.
Interim patches (1) :
Patch 19769480 : applied on Thu Jun 25 16:46:04 CEST 2015
Unique Patch ID: 18350083
Patch description: "Database Patch Set Update : 12.1.0.2.2 (19769480)"
Created on 15 Dec 2014, 06:54:52 hrs PST8PDT
Bugs fixed:
20284155, 19157754, 18885870, 19303936, 19708632, 19371175, 18618122
19329654, 19075256, 19074147, 19044962, 19289642, 19068610, 18988834
19028800, 19561643, 19058490, 19390567, 18967382, 19174942, 19174521
19176223, 19501299, 19178851, 18948177, 18674047, 19723336, 19189525
19001390, 19176326, 19280225, 19143550, 18250893, 19180770, 19155797
19016730, 19185876, 18354830, 19067244, 18845653, 18849537, 18964978
19065556, 19440586, 19439759, 19024808, 18952989, 18990693, 19052488
19189317, 19409212, 19124589, 19154375, 19279273, 19468347, 19054077
19048007, 19248799, 19018206, 18921743, 14643995, 18456643, 16870214
19434529, 19706965, 17835294, 20074391, 18791688, 19197175, 19134173
19174430, 19050649, 19769480, 19077215, 19577410, 18288842, 18436647
19520602, 19149990, 19076343, 19195895, 18610915, 19068970, 19518079
19304354, 19001359, 19676905, 19309466, 19382851, 18964939, 16359751
19022470, 19532017, 19597439, 18674024, 19430401
--------------------------------------------------------------------------------
OPatch succeeded.
For some reason when $ORACLE_HOME was removed from the inventory,the DBA will encounter the “Inventory load failed … OPatch can not load inventory for Oracle Home” error when attempting to run the opatch utility (located in $ ORACLE_HOME / OPatch / opatch) to check the patches applied in the Oracle database environment.
With this, in this post I will explain how to solve this problem.
Solution: Simply re-add the $ORACLE_HOME to the inventory.
(An example of adding 3 ORACLE_HOME):
$ORACLE_HOME/oui/bin/runInstaller -silent -attachHome ORACLE_HOME=/opt/oracle/product/11203 ORACLE_HOME_NAME=dbhome11203 -invPtrLoc /etc/oraInst.loc $ORACLE_HOME/oui/bin/runInstaller -silent -attachHome ORACLE_HOME=/opt/oracle/product/11204 ORACLE_HOME_NAME=dbhome11204 -invPtrLoc /etc/oraInst.loc $ORACLE_HOME/oui/bin/runInstaller -silent -attachHome ORACLE_HOME=/opt/oracle/product/12102 ORACLE_HOME_NAME=dbhome12102 -invPtrLoc /etc/oraInst.loc
Root cause: For some reason the $ORACLE_HOME were removed from inventory.
Here an example / DEMO:
PROBLEM:
techdatabasketserver brunodb/opt/oracle $ /opt/oracle/product/12102/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 12.1.0.1.5
Copyright (c) 2017, Oracle Corporation. All rights reserved.
Oracle Home : /opt/oracle/product/12102
Central Inventory : /opt/oracle/oraInventory12102
from : /opt/oracle/product/12102/oraInst.loc
OPatch version : 12.1.0.1.5
OUI version : 12.1.0.2.0
Log file location : /opt/oracle/product/12102/cfgtoollogs/opatch/opatch2017-09-22_20-05-08PM_1.log
OPatch failed to locate Central Inventory.
Possible causes are:
The Central Inventory is corrupted
The oraInst.loc file specified is not valid.
LsInventorySession failed: OPatch failed to locate Central Inventory.
Possible causes are:
The Central Inventory is corrupted
The oraInst.loc file specified is not valid.
OPatch failed with error code 73
ACTION PLAN:
techdatabasketserver brunodb/opt/oracle $ $ORACLE_HOME/oui/bin/runInstaller -silent -attachHome ORACLE_HOME=/opt/oracle/product/12102 ORACLE_HOME_NAME=dbhome12102 -invPtrLoc /etc/oraInst.loc Starting Oracle Universal Installer... Checking swap space: must be greater than 500 MB. Actual 24575 MB Passed The inventory pointer is located at /etc/oraInst.loc 'AttachHome' was successful.
CHECK:
techdatabasketserver brunodb/opt/oracle $ /opt/oracle/product/12102/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 12.1.0.1.5
Copyright (c) 2017, Oracle Corporation. All rights reserved.
Oracle Home : /opt/oracle/product/12102
Central Inventory : /opt/oracle/oraInventory
from : /opt/oracle/product/12102/oraInst.loc
OPatch version : 12.1.0.1.5
OUI version : 12.1.0.2.0
Log file location : /opt/oracle/product/12102/cfgtoollogs/opatch/opatch2017-09-22_20-06-23PM_1.log
Lsinventory Output file location : /opt/oracle/product/12102/cfgtoollogs/opatch/lsinv/lsinventory2017-09-22_20-06-23PM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Database 12c 12.1.0.2.0
There are 1 products installed in this Oracle Home.
Interim patches (1) :
Patch 19769480 : applied on Thu Jun 25 16:46:04 CEST 2015
Unique Patch ID: 18350083
Patch description: "Database Patch Set Update : 12.1.0.2.2 (19769480)"
Created on 15 Dec 2014, 06:54:52 hrs PST8PDT
Bugs fixed:
20284155, 19157754, 18885870, 19303936, 19708632, 19371175, 18618122
19329654, 19075256, 19074147, 19044962, 19289642, 19068610, 18988834
19028800, 19561643, 19058490, 19390567, 18967382, 19174942, 19174521
19176223, 19501299, 19178851, 18948177, 18674047, 19723336, 19189525
19001390, 19176326, 19280225, 19143550, 18250893, 19180770, 19155797
19016730, 19185876, 18354830, 19067244, 18845653, 18849537, 18964978
19065556, 19440586, 19439759, 19024808, 18952989, 18990693, 19052488
19189317, 19409212, 19124589, 19154375, 19279273, 19468347, 19054077
19048007, 19248799, 19018206, 18921743, 14643995, 18456643, 16870214
19434529, 19706965, 17835294, 20074391, 18791688, 19197175, 19134173
19174430, 19050649, 19769480, 19077215, 19577410, 18288842, 18436647
19520602, 19149990, 19076343, 19195895, 18610915, 19068970, 19518079
19304354, 19001359, 19676905, 19309466, 19382851, 18964939, 16359751
19022470, 19532017, 19597439, 18674024, 19430401
--------------------------------------------------------------------------------
OPatch succeeded.
Hi! I am Bruno, a Brazilian born and bred. Former Oracle ACE, Computer Scientist, MSc in Data Science, over ten years of experience in companies such as IBM, Epico Tech, and Playtech based in three different countries (Brazil, Hungary, and Sweden) and joined projects remotely in many others. I am super excited to show you my interest in Databases, Cloud, Data Science, Data Engineering, Bigdata, AI, Programming, Software Engineering, and data in general.
(Continue reading)