EPMVirt: Oracle Hyperion 11.1.2.4 Virtual Environment

Oracle Hyperion 11.1.2.4 Virtual Environment

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. Copy downloaded software from step 1 to virtual instance
4. Run custom buildEPMvirt script to build the environment 

The steps above will give you a canned set of scripts to flawlessly, easily create an virtual Oracle EPM / Hyperion virtual environment. All of the hard work is done for you: analyzing requirements, OS administration, database administration, EPM installation and configuration, solving issues, and testing!

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.4

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

Oracle RDBMS 12.1.0.1.0

Environment Details

Links:

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

Hyperion admin user: admin , password: password

Linux users:
  oracle , password=oracle
  root,     password=EPMVirt

WebLogic user: epm_admin,   password=epm_admin

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

EPM_HFM - Hyperion Financial 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. 40G will be used for Virtual Image, 10G used as space as temp space for downloaded files.
• 8 Gigs of RAM ( min 5 Gigs given to VM)
• Any 64-bit operating system which is supported by Oracle Virtual Box. I have only tried on Windows, but Mac and Linux should be supported.

Step 1: Download Required Software

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

An important 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-01

   3.7G

3. Create a new folder called vm_files to separate from the previous downloads
4. Download Oracle Database 12c into the vm_files folder
   
   Go to the Oracle 12c Download page. Download Standard Edition 12.1.0.2.0 for Linux x86-64
   http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html
   
   
   
   
   The two files should be
   linuxamd64_12102_database_se2_1of2.zip
   linuxamd64_12102_database_se2_2of2.zip



5. Download Oracle EPM Software
   Start at the EPM Download pagehttp://www.oracle.com/technetwork/middleware/epm/downloads/index.html
   
   

   Hyperion Performance Management and BI Downloads (v11.1.2.4) example:  Hyperion Enterprise Performance Management System Foundation Services Download the following: Under EPM System Release 11.1.2.4.0 Download Files 1,2,3,4 for Linux 64 bit: - for Linux x86-64 File1, File2, File3, File4 Under Oracle Hyperion Planning (2 files below):   EPM System Release 11.1.2.4.0 Part 5 - for Linux x86-64 File 1   EPM System Release 11.1.2.4.0 Part 6 - for Linux x86-64 File 1

            After all the downloads, you will end up with:
            "Foundation-11124-linux64-Part1.zip",
            "Foundation-11124-linux64-Part2.zip",
            "Foundation-11124-Part3.zip",
            "Foundation-11124-linux64-Part4.zip",
            "Essbase-11124-linux64.zip",
            "Apps-11124-linux64.zip",

Step 1 is completed. 

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. 

https://yoyoclouds.wordpress.com/2012/04/25/how-to-check-whether-your-pc-has-virtualization-enabled-or-not/

Choose at least 5 gigs of memory for the virtual machine (5120 meg). If you do not have enough memory and your system will start to swap heavily and will not usable.

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 40GB 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.

Finally, we will be pushing the limits of the memory on your system. By default Oracle Virtual Box does not pre-allocate RAM and will halt the virtual machine prematurly when memory is low. We want to prevent this by pre-allocating all the memory used in the VM when the VM starts up. The following setting should be run on your machine, open a cmd prompt (for windows) and run:

"C:\Program Files\Oracle\VirtualBox\vboxmanage" setextradata "epmvirt" VBoxInternal/RamPreAlloc 1

  ** where epmvirt is the name of your virtual machine

The above command will ensure that the VM stays running and is important even if you have plenty of memory on the system.

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...

Quick Tip for Oracle VM: When you click inside the virtual machine's window your mouse and keyboard will maintain focus inside the virtual window. To release the focus and switch back to working on your computer, hit the RIGHT CTRL key. 

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 press the Tab key to provide additional options.

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

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 a custom Linux kickstart script
2. The Linux kickstart script specifies the list of RPM packages to install automatically. This helps complete pre-installation requirements for Oracle RDBMS and Oracle EPM.
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.1.82 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.

Step 3: Copy the Downloads to the Virtual Machine

ETA for this step: 25 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. Specifically, the files in vm_files directory will be copied to the virutal machine.

Using winscp ( http://winscp.net/eng/index.php )
Login to the Virtual Machine using epmvirt as the host name, this is the address that was added to the hosts file in step 2.

The password for the user oracle is oracle.

On the left hand pane (your machine) navigate to your vm_files folder where you stored the downloads. The vm_files folder should not include the Oracle Virtual Box or Oracle Linux files.

On the right hand pane navigate to the Unix folder in oracle's home directory, downloads
  (ie, /home/oracle/downloads)

Drag the downloaded files from the left hand pane to the right to begin the copy.

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/linuxamd64_12c_database_1of2.zip
   creating: /u0/install/oracle_db/database/
  inflating: /u0/install/oracle_db/database/welcome.html
   creating: /u0/install/oracle_db/database/response/
  inflating: /u0/install/oracle_db/database/response/db_install.rsp
  inflating: /u0/install/oracle_db/database/response/netca.rsp
  inflating: /u0/install/oracle_db/database/response/dbca.rsp
   creating: /u0/install/oracle_db/database/sshsetup/
  inflating: /u0/install/oracle_db/database/sshsetup/sshUserSetup.sh
   creating: /u0/install/oracle_db/database/rpm/
  inflating: /u0/install/oracle_db/database/rpm/cvuqdisk-1.0.9-1.rpm
   creating: /u0/install/oracle_db/database/stage/
  inflating: /u0/install/oracle_db/database/stage/oracle.server.12_1_0_1_0_1369428198015.bak
  inflating: /u0/install/oracle_db/database/stage/shiphomeproperties.xml
  inflating: /u0/install/oracle_db/database/stage/install2.jar
   creating: /u0/install/oracle_db/database/stage/sizes/

....
  inflating: /u0/install/epm/odi/Disk2/stage/Components/oracle.ua.odi/11.1.1.7.0/1/DataFiles/filegroup1.jar
  inflating: /u0/install/epm/odi/Disk2/stage/Components/oracle.ua.odi/11.1.1.7.0/1/DataFiles/filegroup2.jar
  inflating: /u0/install/epm/odi/Disk2/stage/disk.label
  inflating: /u0/install/epm/odi/Labels.txt
  inflating: /u0/install/epm/zipinfo_Apps-11124-linux64.properties
Found /u0/install/downloads/linuxamd64_12c_database_1of2.zip
Found /u0/install/downloads/linuxamd64_12c_database_2of2.zip
Found /u0/install/downloads/Foundation-11124-linux64-Part1.zip
Found /u0/install/downloads/Foundation-11124-linux64-Part2.zip
Found /u0/install/downloads/Foundation-11124-Part3.zip
Found /u0/install/downloads/Foundation-11124-linux64-Part4.zip
Found /u0/install/downloads/Essbase-11124-linux64.zip
Found /u0/install/downloads/Apps-11124-linux64.zip
Starting Oracle Universal Installer...

Checking Temp space: must be greater than 500 MB.   Actual 18621 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 3775 MB    Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2015-01-31_03-51-52PM. 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/OraInstall2015-01-31_03-51-52PM/installActions2015-01-31_03-51-52PM.log
   ACTION: Identify the list of failed prerequisite checks from the log: /tmp/OraInstall2015-01-31_03-51-52PM/installActions2015-01-31_03-51-52PM.log. Then either from the log file or from installation manual find the appropriate configuration to meet the prerequisites and fix it manuall
y.
You can find the log of this install session at:
 /u0/app/oraInventory/logs/installActions2015-01-31_03-51-52PM.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/silentInstall2015-01-31_03-51-52PM.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_EPMVirt_2015-01-31_16-01-49.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 Sat Jan 31 16:01:50 2015

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

Connected to an idle instance.

SQL> ORACLE instance started.

Total System Global Area  534462464 bytes
Fixed Size                  2290416 bytes
Variable Size             473959696 bytes
Database Buffers           50331648 bytes
Redo Buffers                7880704 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 Sat Jan 31 16:02:08 2015

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.



Session altered.


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

SQL> SQL> SQL> SQL> SQL>   2    3
Tablespace created.

SQL> SQL>
User created.

SQL>
User created.

SQL>
User created.

SQL>
User created.

SQL>
User created.

SQL>
User created.

SQL>
User created.

SQL>
User created.

SQL>
User created.

SQL>
User created.

SQL>
User created.

SQL> SQL>
User altered.

SQL>
User altered.

SQL>
User altered.

SQL>
User altered.

SQL>
User altered.

SQL>
User altered.

SQL>
User altered.

SQL>
User altered.

SQL>
User altered.

SQL>
User altered.

SQL>
User altered.

SQL> SQL> SQL>
Role created.

SQL> SQL>
Grant succeeded.

SQL>
Grant succeeded.

SQL>
Grant succeeded.

SQL>
Grant succeeded.

SQL>
Grant succeeded.

SQL>
Grant succeeded.

SQL>
Grant succeeded.

SQL> SQL> SQL>
Grant succeeded.

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

LSNRCTL for Linux: Version 12.1.0.1.0 - Production on 31-JAN-2015 16:36:01

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

Starting /u0/app/oracle/product/12.1.0/dbhome_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 12.1.0.1.0 - Production
System parameter file is /u0/app/oracle/product/12.1.0/dbhome_1/network/admin/HYPDB/listener.ora
Log messages written to /u0/app/oracle/diag/tnslsnr/EPMVirt/hypdb/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=epmvirt)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=REGLSNR_HYPDB)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     HYPDB
Version                   TNSLSNR for Linux: Version 12.1.0.1.0 - Production
Start Date                31-JAN-2015 16:36:02
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u0/app/oracle/product/12.1.0/dbhome_1/network/admin/HYPDB/listener.ora
Listener Log File         /u0/app/oracle/diag/tnslsnr/EPMVirt/hypdb/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=epmvirt)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=REGLSNR_HYPDB)))
Services Summary...
Service "HYPDB" has 1 instance(s).
  Instance "HYPDB", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

SQL*Plus: Release 12.1.0.1.0 Production on Sat Jan 31 16:36:02 2015

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


Connected to:
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
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 12356 MB free disk space.
EPMINS-01034: You have 12808 MB free disk space.
Status of database is....

SQL*Plus: Release 12.1.0.1.0 Production on Sat Jan 31 17:03:52 2015

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

Last Successful login time: Sat Jan 31 2015 16:36:02 -05:00

Connected to:
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
Configuring...
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: 332 ms
    Maximum jars depth achieved: 6, while restriction was: unrestricted
    Parsed 421 manifests
    Total jars and classpath entries encountered: 421
    Total not-existing referenced classpath entries count: 25
    Total classpath elements to check: 58
Jars manifest  succeeded
Running Environment variables ...
    EPMCFG-10223: Environment variable isnt set: {0}
    EPMCFG-10223: Environment variable isnt set: {0}
    Default tmp directory /tmp would be used
Environment variables  succeeded
Preconfig checks passed! Proceeding further
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: 342 ms
    Maximum jars depth achieved: 6, while restriction was: unrestricted
    Parsed 421 manifests
    Total jars and classpath entries encountered: 421
    Total not-existing referenced classpath entries count: 25
    Total classpath elements to check: 58
Jars manifest  succeeded
Running Environment variables ...
    EPMCFG-10223: Environment variable isnt set: {0}
    EPMCFG-10223: Environment variable isnt set: {0}
    Default tmp directory /tmp would be used
Environment variables  succeeded
Preconfig checks passed! Proceeding further
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: 315 ms
    Maximum jars depth achieved: 6, while restriction was: unrestricted
    Parsed 421 manifests
    Total jars and classpath entries encountered: 421
    Total not-existing referenced classpath entries count: 25
    Total classpath elements to check: 58
Jars manifest  succeeded
Running Environment variables ...
    EPMCFG-10223: Environment variable isnt set: {0}
    EPMCFG-10223: Environment variable isnt set: {0}
    Default tmp directory /tmp would be used
Environment variables  succeeded
Preconfig checks passed! Proceeding further
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: 354 ms
    Maximum jars depth achieved: 6, while restriction was: unrestricted
    Parsed 421 manifests
    Total jars and classpath entries encountered: 421
    Total not-existing referenced classpath entries count: 25
    Total classpath elements to check: 58
Jars manifest  succeeded
Running Environment variables ...
    EPMCFG-10223: Environment variable isnt set: {0}
    EPMCFG-10223: Environment variable isnt set: {0}
    Default tmp directory /tmp would be used
Environment variables  succeeded
Preconfig checks passed! Proceeding further
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: 314 ms
    Maximum jars depth achieved: 6, while restriction was: unrestricted
    Parsed 421 manifests
    Total jars and classpath entries encountered: 421
    Total not-existing referenced classpath entries count: 25
    Total classpath elements to check: 58
Jars manifest  succeeded
Running Environment variables ...
    EPMCFG-10223: Environment variable isnt set: {0}
    EPMCFG-10223: Environment variable isnt set: {0}
    Default tmp directory /tmp would be used
Environment variables  succeeded
Preconfig checks passed! Proceeding further
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: 331 ms
    Maximum jars depth achieved: 6, while restriction was: unrestricted
    Parsed 421 manifests
    Total jars and classpath entries encountered: 421
    Total not-existing referenced classpath entries count: 25
    Total classpath elements to check: 58
Jars manifest  succeeded
Running Environment variables ...
    EPMCFG-10223: Environment variable isnt set: {0}
    EPMCFG-10223: Environment variable isnt set: {0}
    Default tmp directory /tmp would be used
Environment variables  succeeded
Preconfig checks passed! Proceeding further
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: 331 ms
    Maximum jars depth achieved: 6, while restriction was: unrestricted
    Parsed 421 manifests
    Total jars and classpath entries encountered: 421
    Total not-existing referenced classpath entries count: 25
    Total classpath elements to check: 58
Jars manifest  succeeded
Running Environment variables ...
    EPMCFG-10223: Environment variable isnt set: {0}
    EPMCFG-10223: Environment variable isnt set: {0}
    Default tmp directory /tmp would be used
Environment variables  succeeded
Preconfig checks passed! Proceeding further
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: 324 ms
    Maximum jars depth achieved: 6, while restriction was: unrestricted
    Parsed 421 manifests
    Total jars and classpath entries encountered: 421
    Total not-existing referenced classpath entries count: 25
    Total classpath elements to check: 58
Jars manifest  succeeded
Running Environment variables ...
    EPMCFG-10223: Environment variable isnt set: {0}
    EPMCFG-10223: Environment variable isnt set: {0}
    Default tmp directory /tmp would be used
Environment variables  succeeded
Preconfig checks passed! Proceeding further
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: 337 ms
    Maximum jars depth achieved: 6, while restriction was: unrestricted
    Parsed 421 manifests
    Total jars and classpath entries encountered: 421
    Total not-existing referenced classpath entries count: 25
    Total classpath elements to check: 58
Jars manifest  succeeded
Running Environment variables ...
    EPMCFG-10223: Environment variable isnt set: {0}
    EPMCFG-10223: Environment variable isnt set: {0}
    Default tmp directory /tmp would be used
Environment variables  succeeded
Preconfig checks passed! Proceeding further
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: 359 ms
    Maximum jars depth achieved: 6, while restriction was: unrestricted
    Parsed 421 manifests
    Total jars and classpath entries encountered: 421
    Total not-existing referenced classpath entries count: 25
    Total classpath elements to check: 58
Jars manifest  succeeded
Running Environment variables ...
    EPMCFG-10223: Environment variable isnt set: {0}
    EPMCFG-10223: Environment variable isnt set: {0}
    Default tmp directory /tmp would be used
Environment variables  succeeded
Preconfig checks passed! Proceeding further
java version "1.6.0_37"
Java(TM) SE Runtime Environment (build 1.6.0_37-b06)
Oracle JRockit(R) (build R28.2.5-50-153520-1.6.0_37-20121220-0843-linux-x86_64, compiled mode)
Generating Encrypted Passwords
Logging configuration class "oracle.core.ojdl.logging.LoggingConfiguration" failed
oracle.core.ojdl.logging.LoggingConfigurationException: ODL-52042: undefined property: ${EPM_ORACLE_INSTANCE}.

SQL*Plus: Release 12.1.0.1.0 Production on Sat Jan 31 17:36:26 2015

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

Last Successful login time: Sat Jan 31 2015 17:26:52 -05:00

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

SQL> SQL> SQL>
0 rows deleted.

SQL>
1 row created.

SQL> Disconnected from Oracle Database 12c Release 12.1.0.1.0 - 64bit Production
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
LCM IMPORT OF CANNED APP
Archive:  /u0/automation/apps/PLANDEMO.zip
  inflating: /tmp/lcm/HP-PLANDEMO/info/sourceInfo.xml
  inflating: /tmp/lcm/HP-PLANDEMO/info/listing.xml
  inflating: /tmp/lcm/HP-PLANDEMO/Import.xml
  inflating: /tmp/lcm/HP-PLANDEMO/resource/Configuration/Properties/Application Definition.xpad
  inflating: /tmp/lcm/HP-PLANDEMO/resource/Configuration/Properties/Application Settings.xml
  inflating: /tmp/lcm/HP-PLANDEMO/resource/Plan Type/Consol/Calculation Manager Rules/AggAll.xml
  inflating: /tmp/lcm/HP-PLANDEMO/resource/Plan Type/Consol/Calculation Manager Rules/AggPlan.xml
  inflating: /tmp/lcm/HP-PLANDEMO/resource/Plan Type/Consol/Calculation Manager Rules/CalcRev.xml
  inflating: /tmp/lcm/HP-PLANDEMO/resource/Plan Type/Consol/Calculation Manager Rules/ClrBS.xml
  inflating: /tmp/lcm/HP-PLANDEMO/resource/Plan Type/Consol/Calculation Manager Rules/ClrFinal.xml
  inflating: /tmp/lcm/HP-PLANDEMO/resource/Plan Type/Consol/Calculation Manager Rules/ClrTrgts.xml
  inflating: /tmp/lcm/HP-PLANDEMO/resource/Global Artifacts/Substitution Variables/PriorYr.xml
  inflating: /tmp/lcm/HP-PLANDEMO/resource/Global Artifacts/Substitution Variables/CurrYr.xml
  inflating: /tmp/lcm/HP-PLANDEMO/resource/Global Artifacts/Substitution Variables/NextYr.xml
  inflating: /tmp/lcm/HP-PLANDEMO/resource/Global Artifacts/Substitution Variables/NextYr1.xml
  inflating: /tmp/lcm/HP-PLANDEMO/resource/Global Artifacts/Substitution Variables/PriorPrd.xml
  inflating: /tmp/lcm/HP-PLANDEMO/resource/Global Artifacts/Substitution Variables/CurrPrd.xml
  inflating: /tmp/lcm/HP-PLANDEMO/resource/Global Artifacts/Substitution Variables/NxtPrd.xml
  inflating: /tmp/lcm/HP-PLANDEMO/resource/Plan Type/Consol/Calc scripts/Default Calc
  inflating: /tmp/lcm/HP-PLANDEMO/resource/Global Artifacts/Spread Patterns/EvenlySplit.xml
  inflating: /tmp/lcm/HP-PLANDEMO/resource/Global Artifacts/Spread Patterns/Fill.xml
  inflating: /tmp/lcm/HP-PLANDEMO/resource/Plan Type/Consol/Standard Dimensions/Year.csv
  inflating: /tmp/lcm/HP-PLANDEMO/resource/Plan Type/Consol/Standard Dimensions/Period.csv
  inflating: /tmp/lcm/HP-PLANDEMO/resource/Plan Type/Consol/Standard Dimensions/Currency.csv
  inflating: /tmp/lcm/HP-PLANDEMO/resource/Plan Type/Consol/Standard Dimensions/Scenario.csv
  inflating: /tmp/lcm/HP-PLANDEMO/resource/Plan Type/Consol/Standard Dimensions/Version.csv
  inflating: /tmp/lcm/HP-PLANDEMO/resource/Plan Type/Consol/Standard Dimensions/Entity.csv
  inflating: /tmp/lcm/HP-PLANDEMO/resource/Plan Type/Consol/Standard Dimensions/Account.csv
  inflating: /tmp/lcm/HP-PLANDEMO/resource/Plan Type/Consol/Standard Dimensions/Segments.csv
  inflating: /tmp/lcm/HP-PLANDEMO/resource/Configuration/User Variables.xml
  inflating: /tmp/lcm/HP-PLANDEMO/resource/Configuration/Data Load Settings.xml
  inflating: /tmp/lcm/HP-PLANDEMO/resource/Global Artifacts/Custom Menus/Plan Revenue.xml
  inflating: /tmp/lcm/HP-PLANDEMO/resource/Plan Type/Consol/Data Forms/Financials/Balance Sheet.xml
  inflating: /tmp/lcm/HP-PLANDEMO/resource/Plan Type/Consol/Data Forms/Financials/Cash Flow.xml
  inflating: /tmp/lcm/HP-PLANDEMO/resource/Plan Type/Consol/Data Forms/Financials/Financials Summary.xml
  inflating: /tmp/lcm/HP-PLANDEMO/resource/Plan Type/Consol/Data Forms/Financials/Income Statement.xml
  inflating: /tmp/lcm/HP-PLANDEMO/resource/Plan Type/Consol/Data Forms/Revenue/Plan Revenue - All Years.xml
  inflating: /tmp/lcm/HP-PLANDEMO/resource/Plan Type/Consol/Data Forms/Revenue/Plan Revenue - Assumptions.xml
  inflating: /tmp/lcm/HP-PLANDEMO/resource/Plan Type/Consol/Data Forms/Revenue/Plan Revenue - COS.xml
  inflating: /tmp/lcm/HP-PLANDEMO/resource/Plan Type/Consol/Data Forms/Revenue/Plan Revenue - Detail by Year.xml
  inflating: /tmp/lcm/HP-PLANDEMO/resource/Plan Type/Consol/Data Forms/Expenses/Plan Department Expenses.xml
  inflating: /tmp/lcm/HP-PLANDEMO/resource/Plan Type/Consol/Data Forms/Expenses/Plan Facilities Expenses.xml
  inflating: /tmp/lcm/HP-PLANDEMO/resource/Plan Type/Consol/Data Forms/Expenses/Plan Operating Expenses.xml
  inflating: /tmp/lcm/HP-PLANDEMO/resource/Plan Type/Consol/Data Forms/Expenses/Review G&A Expenses.xml
  inflating: /tmp/lcm/HP-PLANDEMO/resource/Plan Type/Consol/Data Forms/Allocation/Allocation - Expense.xml
  inflating: /tmp/lcm/HP-PLANDEMO/resource/Plan Type/Consol/Data Forms/Allocation/Allocation - IT.xml
  inflating: /tmp/lcm/HP-PLANDEMO/resource/Plan Type/Consol/Data Forms/Allocation/Allocation - Marketing.xml
  inflating: /tmp/lcm/HP-PLANDEMO/resource/Plan Type/Consol/Data Forms/Allocation/Allocation - Facilities Expense.xml
  inflating: /tmp/lcm/HP-PLANDEMO/resource/Plan Type/Consol/Data Forms/Allocation/Allocation - Segment.xml
  inflating: /tmp/lcm/HP-PLANDEMO/resource/Global Artifacts/Composite Forms/Financials/Revenue Impact.xml
  inflating: /tmp/lcm/HP-PLANDEMO/resource/Global Artifacts/Task Lists/Financial Plan.xml
  inflating: /tmp/lcm/HP-PLANDEMO/resource/Configuration/User Preferences.xml
  inflating: /tmp/lcm/HP-PLANDEMO/resource/Security/Access Permissions/Users.xml
  inflating: /tmp/lcm/HP-PLANDEMO/resource/Configuration/Adhoc Options.xml
  inflating: /tmp/lcm/HP-PLANDEMO/resource/Relational Data/Account Annotations.xml
  inflating: /tmp/lcm/HP-PLANDEMO/resource/Relational Data/Cell Texts.xml
  inflating: /tmp/lcm/HP-PLANDEMO/resource/Relational Data/Planning Units.xml
  inflating: /tmp/lcm/HP-PLANDEMO/resource/Relational Data/Supporting Detail.xml
  inflating: /tmp/lcm/HP-PLANDEMO/resource/Relational Data/Text Values.xml
  inflating: /tmp/lcm/Import.xml
  inflating: /tmp/lcm/Export.xml

Importing Artifact - Application Definition.

Migrating artifacts from /tmp/lcm/HP-PLANDEMO to Default Application Group/PLANDEMO

Importing Artifact - Application Definition.

Importing Artifact - Application Settings.

Importing Artifact - AggAll.

Importing Artifact - AggPlan.

Importing Artifact - CalcRev.

Importing Artifact - ClrBS.

Importing Artifact - ClrFinal.

Importing Artifact - ClrTrgts.

Importing Artifact - PriorYr.

Importing Artifact - CurrYr.

Importing Artifact - NextYr.

Importing Artifact - NextYr1.

Importing Artifact - PriorPrd.

Importing Artifact - CurrPrd.

Importing Artifact - NxtPrd.

Importing Artifact - Default Calc.

Importing Artifact - EvenlySplit.

Importing Artifact - Fill.

Importing Artifact - Year.

Importing Artifact - Period.

Importing Artifact - Currency.

Importing Artifact - Scenario.

Importing Artifact - Version.

Importing Artifact - Entity.

Importing Artifact - Account.

Importing Artifact - Segments.

Importing Artifact - User Variables.

Importing Artifact - Data Load Settings.

Importing Artifact - Plan Revenue.

Importing Artifact - Balance Sheet.

Importing Artifact - Cash Flow.

Importing Artifact - Financials Summary.

Importing Artifact - Income Statement.

Importing Artifact - Plan Revenue - All Years.

Importing Artifact - Plan Revenue - Assumptions.

Importing Artifact - Plan Revenue - COS.

Importing Artifact - Plan Revenue - Detail by Year.

Importing Artifact - Plan Department Expenses.

Importing Artifact - Plan Facilities Expenses.

Importing Artifact - Plan Operating Expenses.

Importing Artifact - Review G&A Expenses.

Importing Artifact - Allocation - Expense.

Importing Artifact - Allocation - IT.

Importing Artifact - Allocation - Marketing.

Importing Artifact - Allocation - Facilities Expense.

Importing Artifact - Allocation - Segment.

Importing Artifact - Revenue Impact.

Importing Artifact - Financial Plan.

Importing Artifact - User Preferences.

Importing Artifact - Users.

Importing Artifact - Adhoc Options.

Importing Artifact - Account Annotations.

Importing Artifact - Cell Texts.

Importing Artifact - Planning Units.

Importing Artifact - Supporting Detail.

Importing Artifact - Text Values.

Migration Status - Success
Planning Database Cube Refresh
Enter administrator password: Cube refresh completed successfully.
Essbase Outline api 6d77d620
Essbase EssOtlVaryingAssociateAttributeDimension function address 4c66d970
Essbase Outline api 6d77d620
Essbase EssOtlVaryingAssociateAttribute function address 4c66b9f0
Essbase Outline api 6d77d620
Essbase EssOtlVaryingDisassociateAttribute function address 4c66b910
Essbase Outline api 6d77d620
Essbase EssOtlAttributeRestructure function address 4c66f4b0
Unzip the Planning Data
Archive:  /u0/Oracle/Middleware/EPMSystem11R1/products/Planning/bin/sampleapp/sampApp_data.zip
  inflating: /tmp/sampapp/SampleApp_data.txt
Load Data and Calc Planning Cube

 Essbase MaxL Shell 64-bit - Release 11.1.2 (ESB11.1.2.4.000B193)
 Copyright (c) 2000, 2015, Oracle and/or its affiliates.
 All rights reserved.

MAXL> login admin password;

 OK/INFO - 1051034 - Logging in user [admin@Native Directory].
 OK/INFO - 1241001 - Logged in to Essbase.

MAXL> import database PLANDEMO.Consol data from data_file "/tmp/sampapp/SampleApp_data.txt" on error abort;

 OK/INFO - 1003040 - Parallel dataload enabled: [1] block prepare threads, [1] block write threads..
 OK/INFO - 1003037 - Data Load Updated [5738859] cells.
 OK/INFO - 1003024 - Data Load Elapsed Time : [6.34] seconds.
 OK/INFO - 1241113 - Database import completed ['PLANDEMO'.'Consol'].

MAXL> execute calculation default on PLANDEMO.Consol;

 OK/INFO - 1012675 - Commit Blocks Interval for the calculation is [3000].
 OK/INFO - 1012714 - Regular member [501111] depends on dynamic-calc member [Headcount]..
 OK/INFO - 1012714 - Regular member [501130] depends on dynamic-calc member [501110]..
 OK/INFO - 1012714 - Regular member [501240] depends on dynamic-calc member [501100]..
 OK/INFO - 1012714 - Regular member [501250] depends on dynamic-calc member [Headcount]..
 OK/INFO - 1012669 - Calculating [ Account(All members) Period(All members) HSP_Rates(All members) Year(All members) Entity(All members) Segments(All members) Currency(All members) Scenario(All members) Version(All members)].
 OK/INFO - 1012677 - Calculating in serial.
 OK/INFO - 1012568 - Commit Blocks Interval was adjusted to be [5195] blocks.
 OK/INFO - 1012550 - Total Calc Elapsed Time : [20.526] seconds.
 OK/INFO - 1013274 - Calculation executed.


  MaxL Shell completed

LCM Import for Reporting and Analysis
Archive:  /u0/automation/apps/RA.zip
  inflating: /tmp/lcm/Export.xml
  inflating: /tmp/lcm/Import.xml
   creating: /tmp/lcm/RnA-Reporting and Analysis/
   creating: /tmp/lcm/RnA-Reporting and Analysis/resource/
   creating: /tmp/lcm/RnA-Reporting and Analysis/resource/Repository Objects/
 extracting: /tmp/lcm/RnA-Reporting and Analysis/resource/Repository Objects/0000014a32898e3f-0000-b5a4-7f000001 (PlanReport1).0000014b40ba79f0-0000-a6a6-7f000001_1
  inflating: /tmp/lcm/RnA-Reporting and Analysis/resource/Repository Objects/REPORTMART.xml
  inflating: /tmp/lcm/RnA-Reporting and Analysis/resource/Repository Objects/0000014a32898e3f-0000-b5a4-7f000001 (PlanReport1).xml
 extracting: /tmp/lcm/RnA-Reporting and Analysis/resource/Repository Objects/0000014a32898e3f-0000-b5a4-7f000001 (PlanReport1).0000014b40ba79ec-0000-a6a6-7f000001_1
 extracting: /tmp/lcm/RnA-Reporting and Analysis/resource/Repository Objects/0000014a32898e3f-0000-b5a4-7f000001 (PlanReport1).0000014b40ba79e9-0000-a6a6-7f000001_1
   creating: /tmp/lcm/RnA-Reporting and Analysis/info/
  inflating: /tmp/lcm/RnA-Reporting and Analysis/info/sourceInfo.xml
  inflating: /tmp/lcm/RnA-Reporting and Analysis/info/listing.xml
  inflating: /tmp/lcm/RnA-Reporting and Analysis/Import.xml

Migrating artifacts from /tmp/lcm/RnA-Reporting and Analysis to Reporting and Analysis/Reporting and Analysis

Importing Artifact - PlanReport1.

Migration Status - Success
Starting at 0, stopping at 99999
Running step number 0
Extracting files...
Running step number 1
Installing Database...
DB Connection OK!
Running step number 2
Installing EPM...
EPM Install Component Count OK.
Running step number 3
Configuring EPM...
EPM Config OK...
Running step number 4
Configuring APPS (preinstall)...
Running step number 5
Starting EPM...
Running step number 6
Installing APPS...

Installation Complete!

All Finished!

To find details regarding your new Oracle Hyperion 11.1.2.4 environment, check intro section above.

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