Corrupted inventory file

[benoit-schmid]

Hello,

On a machine, I have dual instances (SAP+Oracle).

Yes we are a low ressource company

Therefore we have DEV and TST (=QAS) instances installed on the same machine.

They have been working fine for several months.

But I noticedd this morning that opatch had a problem for DEV.

oradev 12% ./opatch lsinventory

========================================================

GENERIC OPATCH VERSION - FOR USE IN SAP ENVIRONMENT ONLY

========================================================

Invoking OPatch 11.2.0.1.3

Oracle Interim Patch Installer version 11.2.0.1.3

Copyright (c) 2010, Oracle Corporation. All rights reserved.

Oracle Home : /oracle/DEV/112_64

Central Inventory : /oracle/oraInventory

from : /var/opt/oracle/oraInst.loc

OPatch version : 11.2.0.1.3

OUI version : 11.2.0.2.0

OUI location : /oracle/DEV/112_64/oui

Log file location : /oracle/DEV/112_64/cfgtoollogs/opatch/opatch2011-11-03_08-56-36AM.log

Patch history file: /oracle/DEV/112_64/cfgtoollogs/opatch/opatch_history.txt

List of Homes on this system:

Home name= TST_102_64, Location= "/oracle/TST/102_64"

Home name= OraDb11g_home1, Location= "/oracle/TST/112_64"

Inventory load failed... OPatch cannot load inventory for the given Oracle Home.

Possible causes are:

Oracle Home dir. path does not exist in Central Inventory

Oracle Home is a symbolic link

Oracle Home inventory is corrupted

LsInventorySession failed: OracleHomeInventory gets null oracleHomeInfo

OPatch failed with error code 73

From what I see in Sap install the inventory is shared and stored in /oracle/oraInventory.

I have modified /oracle/oraInventory/ContentsXML/inventory.xml

opatch lsinventory works.

oratst 57% diff inventory.xml inventory.xml.20111103

10,11c10,11

< <HOME NAME="OraDb11g_home1" LOC="/oracle/TST/112_64" TYPE="O" IDX="1"/>

< <HOME NAME="OraDb11g_home2" LOC="/oracle/DEV/112_64" TYPE="O" IDX="2"/>

---

> <HOME NAME="TST_102_64" LOC="/oracle/TST/102_64" TYPE="O" IDX="1"/>

> <HOME NAME="OraDb11g_home1" LOC="/oracle/TST/112_64" TYPE="O" IDX="2"/>

Now opatch works fine.

As I am not used to doing doing this often, I have the following question.

Do I have to change other config/inventory files in order to avoid side effects that I have not thought of?

Thanks in advance for your answer.

[sunny_pahuja2 · Accepted solution]

Hi,

You can recreate your Oracle inventory. Please check below links:

http://download.oracle.com/docs/cd/B28359_01/em.111/b31207/a_oui_appendix.htm

Thanks

Sunny

[benoit-schmid · Accepted solution]

Hi,
> 
> You can recreate your Oracle inventory. Please check below links:
> 
> 
> http://download.oracle.com/docs/cd/B28359_01/em.111/b31207/a_oui_appendix.htm
> 
> Thanks
> Sunny

Hello,

That is good news because your notes only speak about rebuilding inventory.

DEV and TST opatch lsinventory now works although it worked only for TST.

Regards,