How to Recreate the Global oraInventory (Doc ID 295185.1)

Checked for relevance on 14-Dec-2012
PURPOSE
-------

This document explains the steps to re-create the Global Inventory and 
re-register all the ORACLE_HOMEs (8i or 9i and iAS) in case it is missing or 
corrupted.
This Note, applies only for Oracle Applications 11i environments created 
with the Rapid Installer (RapidWiz) with RDBMS Versions 8i or 9i.


 
SCOPE & APPLICATION
-------------------

System Administrators, Applications DBAs, Oracle Support



How to Recreate the Global oraInventory
=======================================

The file oraInst.loc, defines the location of the Global Inventory.
This file is located under /etc for Linux and AIX and /var/opt/oracle on Solaris,
HP-UX and Tru64.

Every $ORACLE_HOME must be registered on the Global Inventory.
The Global Inventory is pointer to each Local Inventory located under 
$ORACLE_HOME/inventory for every ORACLE_HOME (8i or 9i and iAS).
The Local Inventories contain the local versions installed on that $ORACLE_HOME.

This procedure will only work if the Local Inventory for each ORACLE_HOME is 
present and is not corrupted.
Make sure the directory $ORACLE_HOME/inventory under each RDBMS (8i or 9i) or 
iAS $ORACLE_HOME exists and it is not empty.

Note:
=====
If the Local Inventory is missing or corrupted, then a valid workaround is to
Re-Install the Techstack by using 'rapidwiz -techstack'.
That procedure will create a a New $ORACLE_HOME (9i or iAS) containing a valid
Local Inventory.

For detailed steps on that procedure, refer to the following Metalink notes:
Note: 289786.1 : 11.5.10 Oracle applications Installation Manual' (Chapter 5, Page 5-1) and
Note: 146468.1 : Installing Oracle9i Application Server 1.0.2.2.2 with Oracle Applications




1. Verify the oraInst.loc file.

   Be sure the inventory where oraInst.loc points to, is the oraInventory for 
   the environment that you need to re-create the Global Inventory.

   For Example :
   inventory_loc=/oraInventory

   Note:
   If the oraInst.loc does not exist, create the text file with the above entry.
   This file must exist to be able to register the ORACLE_HOMEs correctly.

2. Rename the corrupted Global oraInventory with a different Name

   Go to the directory where the oraInst.loc is pointing to. 
   Rename the directory with a different name.
   
   For Example :
   cd /
   mv oraInventory oraInventory.ori

   
3. Download Patch 5035661 (OUI 2.2) (Or Later) from Metalink.
   
   Note:
   Do not follow the readme.txt file for this patch. 
   Just follow the instructions on this Note.

4. Recreate the Global oraInventory on ALL the ORACLE_HOMEs as follows :

  4.1) iAS ORACLE_HOME :

  a.  Unzip the patch into the  directory
      ie: unzip -od  p5035661_11i_LINUX.zip

  b.  Source the Apps environment file (/APPSORA.env).
      If the environment file is not available, please make sure
      the environment variable 'APPL_TOP' is set.

  c.  Change directory to the /appsoui/setup

  d.  Execute the perl script OUIsetup.pl:
      perl OUIsetup.pl

      This command, will create a new oraInventory (on the location where 
      the oraInst.loc is pointing to) and will add one entry on the file
      oraInventory/ContentsXML/inventory.xml for the iAS ORACLE_HOME 
      just registered.

  e.  Give all the Permissions to the new oraInventory create in order to 
      prevent permission problems that might occur during the registration 
      of the the next ORACLE_HOME (ie: 8i or 9i).

      For Example :
      cd /
      chmod -R 777 oraInventory

  4.2) RDBMS ORACLE_HOME (8i or 9i)

  a.  Unzip the patch into the  directory
      ie: unzip -od  p5035661_11i_LINUX.zip

  b.  Source the DB environment file (/_.env)
      If the environment file is not available, please make sure
      the environment variable 'ORACLE_SID' is set.

  c.  Change directory to the /appsoui/setup

  d.  Execute the perl script OUIsetup.pl:
      perl OUIsetup.pl

      This command, will use the same oraInventory created on Step 4.1, and 
      will add another entry on the file oraInventory/ContentsXML/inventory.xml 
      for the RDBMS (8i or 9i) ORACLE_HOME just registered.


5. Verify oraInventory registration :

    - Set the DISPLAY correctly

    - Go to the directory $ORACLE_HOME/appsoui/oui/install

    - Execute the command : runInstaller.sh

    - Click on the button 'Installed Products'

    - If you are able to see all the ORACLE_HOMEs and the products installed 
      on each one, then the Registration was succesfull.




REFERENCES
----------

Note: 216664.1 : FAQ: Cloning Oracle Applications Release 11i (Questions 24 to 31)