Where are Application Install Inventories Stored in Oracle EPM 11.1.2.1

Where are Application Install Inventories Stored in Oracle EPM 11.1.2.1 [ID 1304532.1]

Applies to:

Hyperion BI+ - Version: 11.1.2.1.000 and later [Release: 11.1 and later ]
Hyperion Essbase - Version: 11.1.2.0.00 to 11.1.2.1.000 [Release: 11.1 to 11.1]
Hyperion Planning - Version: 11.1.2.0.00 to 11.1.2.1.000 [Release: 11.1 to 11.1]
Information in this document applies to any platform.

Goal

Identify the location of software inventories associated with Oracle EPM 11.1.2.1.

Solution

It is important to know where installation inventory lists are stored: to detect the completeness of an install, to determine whether a patch has been applied, or to delete as part of a reinstall.

• \Oracle\Middleware\EPMSystem11R1\oraInst.loc points to the location of the central inventory. oraInst.loc may have been installed in a previous Oracle install on Unix in: /var/opt/oracle or /etc or $HOME (of the user installing Oracle software), preventing the 'reinstall' of OHS or other software.
  
  
• \Program Files\Oracle\Inventory is typically the location of the central inventory (despite the name 'central inventory', there may exist mutually exclusive inventories generated with the install of other Oracle products). On Unix/Linux the central inventory is in the installer's 'home' directory.
  
  
• A local inventory is typically found in \Oracle\Middleware\EPMSystem11R1\.oracle.products
  
  
• A local pointer (.oracle.instances) to the instance(s) set by EPM 11.1.2.0 and EPM 11.1.2.1 (and referenced by EPM 11.1.2.1 Installer for 'Apply Maintenance Release' option) is put in C:\Users\\ Ensure the same user installs both versions.
  
  
• \Oracle\Middleware\EPMSystem11R1\.oracle.products is used to recreate an inventory if need be (but a regeneration of an inventory will exclude service fixes/patches installed via OPatch. To recreate an inventory after one is corrupted...run \Oracle\Middleware\EPMSystem11R1\OPatch\createInventory.bat.)
  
  
• \Oracle\Middleware\ohs\.patch_storage (holds records of previous OPatches)