Why... Why... Why?
This blog is dedicated to documenting error resolution and other tidbits that I discover while working as a Consultant in the Oracle EPM (Hyperion) field. As much of my job revolves around issue resolution, I see an opportunity to supplement the typical troubleshooting avenues such as the Oracle Knowledgebase and Oracle Forums with more pinpointed information about specific errors as they are encountered. Beware, the information found in this blog is for informational purposes only and comes without any warranty or guarantee of accuracy.

Sunday, November 9, 2014

EPMVirt Debugging


For anyone needing assistance debugging the EPMvirt installation please run the following script to gather some debug info (as oracle)


#!/bin/sh
rm -f /tmp/epmvirt_logs.zip
rm -rf /tmp/epmvirt_debug/
mkdir /tmp/epmvirt_debug
ps -wwef > /tmp/epmvirt_debug/ps
env > /tmp/epmvirt_debug/env
tnsping HYPDB > /tmp/epmvirt_debug/tnsping
rpm -qa > /tmp/epmvirt_debug/rpm
df -h > /tmp/epmvirt_debug/df
free -m > /tmp/epmvirt_debug/free
zip /tmp/epmvirt_logs.zip /tmp/epmvirt_debug/* \
    /root/ks-post.log \
    /u0/Oracle/Middleware/user_projects/epmsystem1/diagnostics/logs/config \
    /u0/Oracle/Middleware/EPMSystem11R1/diagnostics/logs/install \
    /u0/automation/epm/installAll.log \
    /u0/app/oracle/admin/diag/rdbms/hypdb/HYPDB/trace/alert_HYPDB.log \
    /u0/automation/*.log \
    /u0/automation/database/*.log \
    /u0/automation/epm/*.log \
    /u0/automation/root/*.log 


The script will generate a file /tmp/epmvirt_logs.zip

Please email this log file to info@interopconsulting.com and I will take a closer look.

Thanks!

Monday, October 27, 2014

EPMVirt - Step 4: Run buildEPMvirt Script


EPM Virtual Environment Intro
Step 1: Download Required Software
Step 2: Create Virtual Oracle Linux Instance
Step 3: Copy Downloads to Virtual Machine

Step 4: The buildEPMvirt script

ETA for this step: 5 hours (automated install of Oracle EPM)

This automated script does most of the work. The following are the high level steps:
  1. Extracts the files in /u0/install/downloads
  2. Performs an unattended/silent install of Oracle Database
  3. Creates a database instance HYPDB and create schemas...etc for Hyperion
  4. Performs an unattended/silent install of Oracle EPM
  5. Performs an unattended/silent configuration of Oracle EPM
  6. Starts Oracle EPM

Kicking off the buildEPMvirt script

This process will take a few hours and should not be interrupted. Please make sure to do this at a time when you can kick off the script and let it run without putting your computer to sleep...etc. 

Login via PUTTY to the virtual machine, epmvirt, as 'oracle' user. The password is also 'oracle'. 

at the Linux prompt, enter:
    buildEPMvirt

Sit back and relax. This process will take a while, but rest assured it is much faster than doing it yourself! After the script runs, you are finished and should have a complete Oracle EPM environment.

Sample Output

Archive:  /u0/install/downloads/V37933-01.zip
  inflating: /u0/install/epm/InstallTool.properties
  inflating: /u0/install/epm/installTool.lang
  inflating: /u0/install/epm/setup.jar
   creating: /u0/install/epm/assemblies/
   creating: /u0/install/epm/assemblies/biplus_workspace_new_webapp/
   creating: /u0/install/epm/assemblies/biplus_workspace_new_webapp/11.1.2.0/
   creating: /u0/install/epm/assemblies/ocm/
   creating: /u0/install/epm/assemblies/ocm/11.1.2.0/
   creating: /u0/install/epm/assemblies/oracle_common/
   creating: /u0/install/epm/assemblies/oracle_common/11.1.2.0/
   creating: /u0/install/epm/assemblies/sharedServices/
   creating: /u0/install/epm/assemblies/sharedServices/11.1.2.0/
   creating: /u0/install/epm/assemblies/staticContent/
   creating: /u0/install/epm/assemblies/staticContent/11.1.2.0/
   creating: /u0/install/epm/assemblies/tools/
   creating: /u0/install/epm/assemblies/tools/11.1.2.0/
  inflating: /u0/install/epm/assemblies/biplus_workspace_new_webapp/11.1.2.0/assembly.dat
  inflating: /u0/install/epm/assemblies/ocm/11.1.2.0/assembly.dat
  inflating: /u0/install/epm/assemblies/oracle_common/11.1.2.0/assembly.dat
  inflating: /u0/install/epm/assemblies/sharedServices/11.1.2.0/assembly.dat
  inflating: /u0/install/epm/assemblies/staticContent/11.1.2.0/assembly.dat
  inflating: /u0/install/epm/assemblies/tools/11.1.2.0/assembly.dat
   creating: /u0/install/epm/appdev_patchset/
   creating: /u0/install/epm/appdev_patchset/Disk1/
   creating: /u0/install/epm/appdev_patchset/Disk1/doc/
   creating: /u0/install/epm/appdev_patchset/Disk1/doc/dcommon/
   creating: /u0/install/epm/appdev_patchset/Disk1/doc/dcommon/css/
   creating: /u0/install/epm/appdev_patchset/Disk1/doc/dcommon/gifs/
   creating: /u0/install/epm/appdev_patchset/Disk1/doc/dcommon/html/
   creating: /u0/install/epm/appdev_patchset/Disk1/doc/images/
   creating: /u0/install/epm/appdev_patchset/Disk1/doc/online_help/
   creating: /u0/install/epm/appdev_patchset/Disk1/doc/online_help.bi/
   creating: /u0/install/epm/appdev_patchset/Disk1/doc/online_help.bi/biesg/
   creating: /u0/install/epm/appdev_patchset/Disk1/doc/online_help/aiaag/
   creating: /u0/install/epm/appdev_patchset/Disk1/doc/online_help/asadm/
   creating: /u0/install/epm/appdev_patchset/Disk1/doc/online_help/asper/
   creating: /u0/install/epm/appdev_patchset/Disk1/doc/online_help/astda/
   creating: /u0/install/epm/appdev_patchset/Disk1/doc/online_help/csmsp/
.....

Found /u0/install/downloads/linuxamd64_12c_database_2of2.zip
Starting Oracle Universal Installer...

Checking Temp space: must be greater than 500 MB.   Actual 30094 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 5135 MB    Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2014-10-27_11-48-21PM. Please wait ...[WARNING] [INS-13014] Target environment does not meet some optional requirements.
   CAUSE: Some of the optional prerequisites are not met. See logs for details. /tmp/OraInstall2014-10-27_11-48-21PM/installActions2014-10-27_11-48-21PM.log
   ACTION: Identify the list of failed prerequisite checks from the log: /tmp/OraInstall2014-10-27_11-48-21PM/installActions2014-10-27_11-48-21PM.log. Then either from the log file or from installation manual find the appropriate configuration to meet the prerequisites and fix it manually.
You can find the log of this install session at:
 /u0/app/oraInventory/logs/installActions2014-10-27_11-48-21PM.log

Prepare in progress.
..................................................   9% Done.

Prepare successful.

Copy files in progress.
..................................................   15% Done.
..................................................   20% Done.
..................................................   25% Done.
..................................................   30% Done.
..................................................   35% Done.
..................................................   40% Done.
..................................................   45% Done.
..................................................   50% Done.
..................................................   55% Done.
..................................................   60% Done.
..................................................   65% Done.
..................................................   70% Done.
..................................................   75% Done.
..................................................   80% Done.

Copy files successful.

Link binaries in progress.

Link binaries successful.

Setup files in progress.
........................................
Setup files successful.
..................................................   86% Done.

Setup Inventory in progress.

Setup Inventory successful.
..........
Finish Setup in progress.
..................................................   94% Done.

Finish Setup successful.
The installation of Oracle Database 12c was successful.
Please check '/u0/app/oraInventory/logs/silentInstall2014-10-27_11-48-21PM.log' for more details.

As a root user, execute the following script(s):
        1. /u0/app/oraInventory/orainstRoot.sh
        2. /u0/app/oracle/product/12.1.0/dbhome_1/root.sh


..................................................   100% Done.
Successfully Setup Software.
Check /u0/app/oracle/product/12.1.0/dbhome_1/install/root_localhost.localdomain_2014-10-28_00-06-41.log for the output of root script
Changing permissions of /u0/app/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.

Changing groupname of /u0/app/oraInventory to dba.
The execution of the script is complete.

SQL*Plus: Release 12.1.0.1.0 Production on Tue Oct 28 00:06:43 2014

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> ORACLE instance started.

Total System Global Area 1369579520 bytes
Fixed Size                  2288200 bytes
Variable Size            1241515448 bytes
Database Buffers          117440512 bytes
Redo Buffers                8335360 bytes
SQL>
File created.

SQL> Disconnected from Oracle Database 12c Release 12.1.0.1.0 - 64bit Production

SQL*Plus: Release 12.1.0.1.0 Production on Tue Oct 28 00:09:42 2014

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Release 12.1.0.1.0 - 64bit Production

SQL>   2    3    4    5    6    7    8    9   10   11   12   13   14   15   16   17   18   19   20   21   22   23
Database created.

SQL> SQL>
Session altered.


Session altered.
....



Oracle Database 12c Release 12.1.0.1.0 - 64bit Production

SQL> Disconnected from Oracle Database 12c Release 12.1.0.1.0 - 64bit Production

Installer Path check... Ok
Checking if running under root account... Ok
Current user is not root.
EPMINS-01087: Checking if the file exist and have read permissions: /u0/install/epm/assemblies... Ok
EPMINS-01087: Checking if the file exist and have read permissions: /u0/install/epm/jre... Ok
EPMINS-01087: Checking if the file exist and have read permissions: /u0/install/epm/setup.jar... Ok
Check assemblies:
    /u0/install/epm/assemblies/biplus_product_reporting_client... Not exists
    /u0/install/epm/assemblies/staticContent/11.1.2.0/assembly.dat... Ok
    /u0/install/epm/assemblies/webLogicCommonComponent/11.1.2.0/assembly.dat... Ok
    /u0/install/epm/assemblies/dbclient64... Not exists
    /u0/install/epm/assemblies/aif/11.1.2.0/assembly.dat... Ok
    /u0/install/epm/assemblies/ocm/11.1.2.0/assembly.dat... Ok
    /u0/install/epm/assemblies/calc/11.1.2.0/assembly.dat... Ok
    /u0/install/epm/assemblies/opmn/11.1.2.0/assembly.dat... Ok
    /u0/install/epm/assemblies/bpm_architect_datasync/11.1.2.0/assembly.dat... Ok
    /u0/install/epm/assemblies/essbase_services/11.1.2.0/assembly.dat... Ok
    /u0/install/epm/assemblies/biplus_interactive_reporting_services/11.1.2.0/assembly.dat... Ok
    /u0/install/epm/assemblies/bpm_architect_batch_client/11.1.2.0/assembly.dat... Ok
    /u0/install/epm/assemblies/hsf_server... Not exists
    /u0/install/epm/assemblies/tools/11.1.2.0/assembly.dat... Ok
    /u0/install/epm/assemblies/productCommonComponents/11.1.2.0/assembly.dat... Ok
    /u0/install/epm/assemblies/hpm/11.1.2.0/assembly.dat... Ok
    /u0/install/epm/assemblies/bpm_architect_webapp/11.1.2.0/assembly.dat... Ok
    /u0/install/epm/assemblies/biplus_product_reporting_common/11.1.2.0/assembly.dat... Ok
    /u0/install/epm/assemblies/dbclient32... Not exists
    /u0/install/epm/assemblies/fdm... Not exists
    /u0/install/epm/assemblies/biplus_financial_reporting_common/11.1.2.0/assembly.dat... Ok
    /u0/install/epm/assemblies/arm/11.1.2.0/assembly.dat... Ok
    /u0/install/epm/assemblies/biplus_financial_reporting_webapp/11.1.2.0/assembly.dat... Ok
    /u0/install/epm/assemblies/biplus_webanalysis_webapp/11.1.2.0/assembly.dat... Ok
    /u0/install/epm/assemblies/biplus_workspace_webapp/11.1.2.0/assembly.dat... Ok
    /u0/install/epm/assemblies/ohs... Not exists
    /u0/install/epm/assemblies/hfm_client/11.1.2.0/assembly.dat... Ok
    /u0/install/epm/assemblies/sharedServices/11.1.2.0/assembly.dat... Ok
    /u0/install/epm/assemblies/odi/11.1.2.0/assembly.dat... Ok
    /u0/install/epm/assemblies/biplus_portlets_webapp/11.1.2.0/assembly.dat... Ok
    /u0/install/epm/assemblies/biplus_core_services/11.1.2.0/assembly.dat... Ok
    /u0/install/epm/assemblies/commonComponents/11.1.2.0/assembly.dat... Ok
    /u0/install/epm/assemblies/essbaseProductCommonComponents/11.1.2.0/assembly.dat... Ok
    /u0/install/epm/assemblies/essbase_studio_services/11.1.2.0/assembly.dat... Ok
    /u0/install/epm/assemblies/oracle_common/11.1.2.0/assembly.dat... Ok
    /u0/install/epm/assemblies/hfm_common/11.1.2.0/assembly.dat... Ok
    /u0/install/epm/assemblies/analytic_services_provider_webapp/11.1.2.0/assembly.dat... Ok
    /u0/install/epm/assemblies/planning/11.1.2.0/assembly.dat... Ok
    /u0/install/epm/assemblies/biplus_product_reporting_services/11.1.2.0/assembly.dat... Ok
    /u0/install/epm/assemblies/financial_close/11.1.2.0/assembly.dat... Ok
    /u0/install/epm/assemblies/hsf_webapp... Not exists
    /u0/install/epm/assemblies/disclosure/11.1.2.0/assembly.dat... Ok
    /u0/install/epm/assemblies/bpm_architect_services... Not exists
    /u0/install/epm/assemblies/hfm_services... Not exists
    /u0/install/epm/assemblies/hfm_webapp/11.1.2.0/assembly.dat... Ok
    /u0/install/epm/assemblies/essbase_integration_services/11.1.2.0/assembly.dat... Ok
    /u0/install/epm/assemblies/biplus_workspace_new_webapp/11.1.2.0/assembly.dat... Ok
    /u0/install/epm/assemblies/essbase_administration_services_webapp/11.1.2.0/assembly.dat... Ok
Result of checking assemblies: Ok
Checking environment variables...
    EPMINS-01056: Could not set the environment variable TMP.
    EPMINS-01056: Could not set the environment variable TMPDIR.
Environment variable /tmp would be used.
Ok
EPMINS-01087: Checking if the file exist and have read permissions: /home/oracle...
Ok
    EPMINS-01099: User home have to exist for successful installation.
EPMINS-01002: All installation prerequisites have been met. Starting EPM System Installer.

EPMINS-01032: Checking for available disk space in the /u0/Oracle/Middleware/EPMSystem11R1 directory.
EPMINS-01033: The selected components require 9882 MB free disk space.
EPMINS-01034: You have 24335 MB free disk space.
Extracting files...
Installing Database...
DB Connection OK!
Installing EPM...

Installing...
Running preconfig checks...
Running EPM_ORACLE_HOME...
    EPM_ORACLE_HOME environment variable value: /u0/Oracle/Middleware/EPMSystem11R1
    JAVA_HOME environment variable value: /u0/Oracle/Middleware/EPMSystem11R1/../jdk160_35
EPM_ORACLE_HOME succeeded
Running .oracle.products ... .oracle.products  succeeded
Running Jars manifest ...
    Time spent for manifests parsing: 299 ms
    Maximum jars depth achieved: 6, while restriction was: unrestricted
    Parsed 450 manifests
    Total jars and classpath entries encountered: 450
    Total not-existing referenced classpath entries count: 44
    Total classpath elements to check: 57
Jars manifest  succeeded
Jars manifest  succeeded
Environment variables  succeeded
Preconfig checks passed! Proceeding further
Starting all
Apache Ant version 1.7.1 compiled on June 27 2008
Buildfile: /u0/Oracle/Middleware/EPMSystem11R1/common/config/11.1.2.0/resources/instance/start.xml

Finish all
EPM Install OK.
EPM Install Component Count OK.
Configuring EPM...
EPM Config OK...
Starting EPM...

Installation Complete!

All Finished!

To find details regarding your new environment, check:

I am curious what you think of this process. Please feel free to comment and add feedback on this post. 

EPMVirt - Step 3: Copy the Downloads to Virtual Machine

Step 3: Copy the Downloads to the Virtual Machine
ETA for this step: 45 minutes (waiting for files to copy)

In this step, we copy the files you downloaded in Step 1 over to the Virtual Machine for installation.

Using winscp, http://winscp.net/eng/index.php
Login to the Virtual Machine using the internet address noted in step 2.

The password for the user oracle is oracle.



On the left hand pane (your machine) navigate to the downloads folder where you stored the downloads.


On the right hand pane navigate to the unix folder, /u0/install/downloads

Drag the downloaded files into the right pane to copy them to the virtual server in /u0/install/downloads

Continue to the next step: Run buildEPMvirt script

EPMVirt - Step 2: Create an Oracle Linux Virtual Environment

 Step 2: Create Virtual Image

ETA for this step: 45 minutes (Configuring and Installing VM)

This step will provide the framework for the EPM virtual instance. To start we will install the Oracle VirtualBox software. (https://www.virtualbox.org)


Part a) Install Oracle Virtual Box

Double click on the Virtual Box installer which was downloaded.
Click on Next...

Click Next to accept all default options.
Again, click next for default options.

Chose Yes, acknowledging that your internet connection may be briefly disrupted.

Click Install.

Select Finish to open VirtualBox.

Virtual Box home screen:


Select "New" to create a new Virtual Machine.

Under the name field, chose any name for your new Virtual Machine
Choose Linux for Type and Version Oracle 64 Bit.
Note: You may not see 64 bit as an option if vitalization is not turned on in your BIOS. See below for instructions on how to fix.



SPECIAL NOTE: If 64 bit is not showing up as an option you need to enable Virtualization technology in your computer's BIOS. 


The following link may explain this in more detail. Without 64 bit enabled, none of the steps in this tutorial will work due to incompatible architecture. 


Choose 3 Gigs of memory for the virtual machine (3072 meg). If you have more RAM, this can be adjusted for better performance later.

Chose "Do not add a virtual hard drive." and hit "create"
Accept the warning message by selecting Continue

The creation is complete, the settings are now displayed in the home screen,

Let's adjust a few settings. First create a hard drive:
Click Settings, Select storage.

Right Click on Controller: SATA. Click Add Hard Disk

Select "Create new Disk"

Hit next to select the default disk option (VDI).

For best performance, and to avoid pesky "disk full" errors. Select Fixed Size for the disk size.

Enter 50GB for the disk size:
Select "Create" to finish adding the disk. It will take a while to format the disk.

Next, Under "Network" Change the "Attached to" field from NAT to Bridged Adapter. This will allow the Virtual Machine to connect to the internet for pulling rpm packages during install.


Under "System" , select processor. Move the scroll bar under Processor to select more than 1 CPU. 2 will work. More will result in faster performance.
Select OK to finish adjusting settings.

Part b) Install Linux on the Virtual Machine

Click "Start" to start the VM:
A new window will pop up containing the Virtual Machine. There is no boot image yet so it will not do anything useful. Select CD/DVD devices. Chose a virtual CD/DVD disk file...


Choose the ISO image for Oracle Linux that was downloaded in the previous download step.
Now that the virtual DVD installation media is inserted into the virtual machine, reboot to have it boot from the Oracle Linux installation media.



Quickly... on to the next step and hit the TAB key!

When the Oracle Linux installer splash screen opens tit the Tab key to open options.

This will bring up the command line to boot.
At the end of the line add the text:
     ks=http://interopconsulting.com/ks1  
 to specify the automated Linux install script.
(full line will read vmlinuz initrd=initrd.img ks=http://interopconsulting.com/ks1)


Press enter to boot the Linux installer and begin the automated install. 
The following automated process will occur: 
  1. Linux installer boots, establishes a network connection and downloads ks1 Linux kickstart script
  2. The ks1 script specifies the list of RPM packages to install automatically.
  3. A post installation script will run after packages are installed to download and install the custom EPMVirt RPM Package. EPMVirt is a set of scripts required to install and configure the Oracle EPM environment. This RPM is downloaded and installed automatically. For reference, the RPM is available at:
    http://sourceforge.net/projects/epmvirt

Once complete, login as root and determine the machine's IP address. The initial root password is EPMVirt.

Once logged in type:
  ifconfig

Determine the IP of the machine, for instance 192.168.1.82


Now, let's add this entry to your local machine's hosts file so that you can refer to it by name, rather than using the ip address.

Open a cmd prompt as administrator:
Click on the Windows Start Menu, type "cmd" into the search bar.
Right click on the cmd.exe icon, select "Run as administrator"

In the cmd prompt window type
    echo 192.168.182 epmvirt >> drivers\etc\hosts


This will now associate the name epmvirt with your new virtual machine's ip address.
For instance, referencing the URL from your laptop
http://epmvirt:19000/workspace would now be possible.

Continue to Step 3: Copy Downloads to Virtual Machine

Sunday, October 26, 2014

EPMVirt - Step 1: Download Required Software


EPM Virtual Environment Intro
Step 1: Download Required Software
Step 2: Create Virtual Oracle Linux Instance
Step 3: Copy Downloads to Virtual Machine
Step 4: buildEPMvirt script

 Step 1: Download Required Software

ETA for this step: 2 hours (waiting for downloads to complete)

Note regarding software downloads. You are responsible for potential licensing requirements for any of the software. The script buildEPMVirt simply automates the installation of the software. You are responsible for downloading and accepting the Oracle license agreements.  
  1. Download Virtual Box for your OS
    https://www.virtualbox.org/wiki/Downloads
    Specifically I am using VirtualBox 4.3.18 for Windows hosts
  2. Download Oracle Linux 6.5
    Using the Oracle Software Delivery Cloud,
    https://edelivery.oracle.com/linux

    Select Oracle Linux and 64-bit options


    Choose Oracle Linux 6 Update 5


    Download this file:
    Oracle Linux Release 6 Update 5 for x86_64 (64 Bit)V41362-013.7G

  3. Download Oracle Database 12c

    Go to the Oracle 12c Download page. Download Standard Edition 12.1.0.1.0.

    http://www.oracle.com/technetwork/database/enterprise-edition/downloads/database12c-linux-download-1959253.html

    The two files should be
    linuxamd64_12c_database_1of2.zip
    linuxamd64_12c_database_2of2.zip


  4. Go to Oracle Software Delivery Cloud
    https://edelivery.oracle.com/

    Choose "Enterprise Performance Management"
    Linux x86-64


    Choose 11.1.2.3.0 Media Pack

    Download Part 1-7,

Step 1 is completed. 

Please move on to Step 2: Creating an Oracle Linux Virtual Environment


EPMVirt - Build your own Hyperion EPM virtual environment


 EPM Virtual Environment Intro

Beta (Please note, this process is in early testing stages)

I have been working on a small project to provide the ability to create a Oracle EPM virtual instance. The idea for the project is to provide a semi-automated method for creating a EPM virtual installation that can be used on laptops or, any machine, as it is generic. Where this method differs from most other virtual EPM projects is that rather than providing the virtual image directly (binary image), this method will provide all the scripts needed to build out the environment on the fly.
The basic idea is this:
  1. Download all the required software
  2. Create a virtual Oracle Linux instance using Oracle Virtual Box
  3. Install my custom provided custom RPM, buildEPMvirt
    Code repository hosted on SorceForge (https://sourceforge.net/projects/epmvirt/)
  4. Copy downloaded software from step 1 to virtual instance
  5. Run buildEPMvirt script to build the environment 
The steps above will give you a canned set of scripts to flawlessly, easily create an virtual EPM environment. All of the hard work is done for you: Analyzing requirements, OS administration, database administration, EPM installation and configuration, solving issues, and testing are all done for you!

EPMVirt - What do you get? 

EPMVirt is a process for creating a Virtual Environment for Hyperion / Oracle EPM. After completing the installation process detailed here you will have:

Oracle Hyperion 11.1.2.3.0
  • Foundation Services
  • Calculation Manager
  • Hyperion Planning
  • Essbase Administrative Services (EAS)
  • Essbase
  • Essbase Integration Services
  • Essbase Provider Services (APS/Smartview)
  • Financial Reporting / Workspace
  • FDM Enterprise Edition (FDMEE)
  • Disclosure Management
  • Profitability and Cost Management
Oracle RDBMS 12.1.0.1.0


What is coming? As Oracle matures in the Linux realm, I may provide HFM and EPMA in future 11.1.2.4 releases. Also, I will provide a 11.1.2.3.500 release shortly.

Environment Details

Links:

Workspace: http://epmvirt:9000/workspace/index.jsp
EAS Console: http://epmvirt:9000/easconsole/console.html

Hyperion admin user: password
Linux users:
  oracle , password=oracle
  root,     password=EPMVirt

Database:
  SID: HYPDB
  Port: 1521
Passwords: PWD
DB Accounts: 
EPM_HSS - Shared Services/Foundation
EPM_RA - Reporting and Analysis
EPM_CALC - Calculation Manager
EPM_HPSYS - Planning System Database
EPM_HPAPP1 -  Empty schema for creating planning application
EPM_ESTUDIO - Essbase Studio
EPM_EAS - Essbase Administration Studio
EPM_PROFIT - Profitability
EPM_FDMEE - FDM Enterprise Edition
EPM_DISC - Disclosure Management

Before You Start: Requirements

Before beginning, you will need
  • 50 gigs of hard disk space. This can be provided by using local storage, or an external USB device. 
  • 10 gigs of temporary hard disk space for downloads 
  • 2 gigs of RAM 
  • 64 bit Operating System 
  • A supported OS for Oracle Virtual Box. I have only tried on Windows, but Mac and Linux should be supported