Oracle Inventory corrupted

[#1]

We installed several QA systems (BI, GRS, Portal, ECC) with their ORACLE_HOME's within the same UNIX box but when SAP ask for each ORACLE_HOME's name and path's to install we mistakenly don't change the name and just the path so the only recognized installation in the inventory is the last one.

Because of the above the oracle opatch utility is getting the following error with all but with the last one. So we cannot do patching to this instances. Can any one suggest a solution to re-inventory all oracle home's with the proper names?

$ $ORACLE_HOME/OPatch/opatch lsinventory

Invoking OPatch 10.2.0.2.0

Oracle interim Patch Installer version 10.2.0.2.0

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

Oracle Home : /oracle/QR1/102_64

Central Inventory : /oracle/oraInventory

from : /etc/oraInst.loc

OPatch version : 10.2.0.2.0

OUI version : 10.2.0.2.0

OUI location : /oracle/QR1/102_64/oui

Log file location : /oracle/QR1/102_64/cfgtoollogs/opatch/opatch-2008_May_07_11-27-00-EDT_Wed.log

List of Homes on this system:

Home name= OUIHome1, Location= "/oracle/QG1/102_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

LsInventory Session failed: OracleHomeInventory::load() gets null oracleHomeInfo

OPatch failed with error code 72

[Former Member]

Thanks for your help, very useful. Before I try to implement this solution I have an other question.

Since the corrupted inventory seems to be the central and since they all have locally the same Oracle Home Name, do I need first to change the Local Oracle Home Name before I try to recreate the central?, I mean, do the local inventory have a name like OraDBb10g_home1 that needs to be adjusted as well or is just for the central configuration?

Regards.

Eduardo.

[stefan_koehler]

Hello Eduardo,

that's the way i do:

• Local inventory: /oracle/<SID>/102_xx/inventory

• Central inventory: /oracle/<SID>/oraInventory

In this case the central inventory is independent from any other oracle installation.

> Do I need first to change the Local Oracle Home Name before I try to recreate the central?

Sorry, i don't understand this question.

> I mean, do the local inventory have a name like OraDBb10g_home1 that needs to be adjusted as well or is just for the central configuration?

No, the name that is used in the example of metalinknote #556834.1 is the "<ORACLE_HOME_NAME>".

http://download.oracle.com/docs/cd/B19306_01/em.102/b16227/c_oui_appendix.htm#sthref529

<ORACLE_HOME_NAME> - This is used to specify the ORACLE HOME name in the target machine.

Regards

Stefan