Oracle Hyperion Database Administrator

Oracle Hyperion EPM Installation and Administration : Part1


Oracle Hyperion Enterprise Performance Management (EPM) as name suggests is enterprise performance management software that provides planning, budgeting and forecasting solution.

Hyperion was acquired by Oracle in 2007 and consists of following components

• Hyperion Foundation Services
• Hyperion Essbase
• Hyperion Reporting and Analysis
• Oracle Hyperion Data Management
• Hyperion Financial Performance Management Application that consists of

• Hyperion Financial Close Management
• Hyperion Financial Disclosure Management
• Hyperion Financial Management – Fusion Edition
• Hyperion Strategic Management – Fusion Edition
• Hyperion Performance Scorecard – Fusion Edition
• Hyperion Profitability and Cost Management – Fusion Edition

This post covers high level steps to install Oracle Hyperion EPM 11.1.1.2.1

1. Download Oracle Hyperion EPM Software from eDelivery (select product Oracle Enterprise Performance Management System)
2. Install Database for Hyperion (Database character set must be with UTF-8 encoding (AL32UTF8, UTF8, UTFE)
3. Install Java Development Kit (JDK or JRockit) 1.6 or higher
4. Install Hyperion EPM System Components using installTool.sh/bat (This will install WebLogic Server, Oracle HTTP Server, and EPM System)
5. Configure Hyperion EPM System Components using configTool.sh/bat ( This will create Weblogic Domain, configure OHS Server, System Component for EPM i.e. EPM ORACLE_INSTANCE and configure EPM applications)
6. Start Hyperion EPM System Components using EPM_ORACLE_INSTANCE /bin/start.sh
7. Validate/Access Hyperion EPM System Components