Subject: How to Recreate the Global oraInventory Doc ID: Note:295185.1 Type: HOWTO Last Revision Status: 26-APR-2006 PUBLISHED Date: PURPOSE This document explains the steps to recreate the Global Inventory and reregister 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, HPUX 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 ReInstall 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 51) 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 recreate 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 (<APPL_TOP>/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 (/<sid>_.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)