Monday, June 11, 2007

Missing oraInventory

When running the http patch, I received some errors...It seemed the oraInventory was not valid, at least the http entry was missing.
The oraInventory that was incomplete was the global oraInventory. I noticed that the local oraInventory in the $IAS_HOME was complete, but running the patch with this oraInventory did not work. Something about the oraInventory...
In the file oraInst.loc (usually in the /var/opt/oracle directory), the location of the global oraInventory is shown. In the global oraInventory you find the installed ORACLE_HOMES and in the ORACLE_HOME you find the local oraInventory for that ORACLE_HOME.
I find out n Metalink that the global oraInventory can be restored if the local oraInventory is valid.
The perl script OUIsetup.pl in the $ORACLE_HOME/appsoui/setup (IAS_HOME) directory can be used to recreate the global oraInventory.
After recreating the global oraInventory the http patch was successfully applied.

3 comments:

naqi mirza said...

Have you ever patched your rdbms home? I assume you must have - there were apparently some bugs related to opatch running against a 9i rdbms that would result in inventory corruption - this was related to the oui that was shipped with the release. Perhaps this is what might have casued your corruption. There are a few notes on metalink that discuss this and show how to check if your inventory is corrupted - these are not apps articles (but 9i does ship with apps unless you've upgraded to 10g or are on r12) - but perhaps the same applies in this case.......naqi

Bas Klaassen said...

It seems someone deleted the oraInventory over here...

Eric Simmons said...

Great and Useful Article.

Online Java Training | Online Java Training