Create Global oraInventory for Oracle Applications 11i

Some time I am not able to apply database patch (using opatch) to RDBMS home due to global inventory issue. So I thought of putting all the steps together to recreate global inventory problem. 1. Login as oracle user and identify the oracle Inventory location by referring to content of /var/opt/oracle/oraInst.loc.

$ cat /var/opt/oracle/oraInst.loc inventory_loc=/local/oracle/admin/ntst/oraInventory inst_group=dba

2. Renamed old inventory

$cd /local/oracle/admin/ntst

$mv oraInventory oraInventory.old

$chmod 777 oraInventory

3. Downloaded patch Patch 5035661 for HP-UX 32 (my os is HP-UX)

4. Login as

$ . $APPL_TOP/APPSORA.env

$ pwd /reports/ntrg/patches/secjuly07 $ echo $IAS_ORACLE_HOME /apps/OEBS/ntrg/iAS $ unzip -od /apps/OEBS/ntrg/iAS p5035661_11i_HPUX11.zip

$ cd $IAS_ORACLE_HOME/appsoui/setup $ pwd /apps/OEBS/ntst/iAS/appsoui/setup $ perl OUIsetup.pl

Check log from above script and ensure it was successful.

5. Go to parent directory of oraInventory and change its permission to 777 recursively.

$ pwd /local/oracle/admin/ntrg/oraInventory

$ chmod -R 777 *

6. Login as oracle and set enviroment

$cd /reports/ntrg/patches/secjuly07 $unzip -od $ORACLE_HOME p5035661_11i_HPUX11.zip

$ cd $ORACLE_HOME/appsoui/setup $pwd /local/oracle/product/9.2.0.8.2/appsoui/setup

$perl OUIsetup.pl

Log file : /local/oracle/product/9.2.0.8.2/appsoui/setup/OUIsetup.log

7. Check if you can list oraInventory

$cd $ORACLE_HOME/OPatch/

$./opatch lsinventory

8. You can also invoke universal installer to check the home registration validity in global inventory.

$export DISPLAY=:0.0

$cd $ORACLE_HOME/appsoui/oui/install

$./runInstaller.sh

It will invoke universal installer and you can see RDBS home registered there.

Subject: How to Recreate the Global oraInventory Note: 295185.1