Recreating Oracle Inventory

Recreating OraInventory in Oracle

Problem: oraInventory got corrupted or deleted

OS: Linux

Goal: Recreating oraInventory for RDBMS home.

Solution:

Find the central inventory which is in /etc/oraInst.loc. if you don’t find one create one. In this file it should contain inventory_loc and inst_group

Eg:

[oracle@bajra]$ ls -lrt /etc/oraInst.loc
-rw-r--r-- 1 root root 54 Feb 27 18:05 /etc/oraInst.loc

inventory_loc=/u01/oracle/oraInventory
inst_group=dba

Now,

[oracle@bajra pr00gos]$ cd $ORACLE_HOME/oui/bin

./runInstaller -silent -ignoreSysPrereqs -attachHome ORACLE_HOME=”” ORACLE_HOME_NAME=””

Eg:

[oracle@bajra bin]$ ./runInstaller -silent -ignoreSysPrereqs -attachHome ORACLE_HOME="/u01/oracle/product/db/10.2.0/pr00gos" ORACLE_HOME_NAME="OUI_db_10gR2_1"

Starting Oracle Universal Installer...

No pre-requisite checks found in oraparam.ini, no system pre-requisite checks will be executed.

>>> Ignoring required pre-requisite failures. Continuing...

'AttachHome' was successful.

If the server have more than one oracle home, Run the following command with the respective oracle home and oracle home name.

Run : ./runInstaller -silent -ignoreSysPrereqs -attachHome ORACLE_HOME=”” ORACLE_HOME_NAME=””