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.

EPMVirt: Create your own Oracle Hyperion Virtual Environment:

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-013.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 page
    http://www.oracle.com/technetwork/middleware/epm/downloads/index.html

    Hyperion Performance Management and BI Downloads (v11.1.2.4)


    example:
    Download 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
    File1File2File3File4

    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. 


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. 

41 comments:

  1. Great post. This worked like a charm.. keep'em coming!!!

    Norman

    ReplyDelete
  2. Hi Nick,

    Thanks again for putting this post together. I'm a Hyperion Developer that's pretty new to linux and Oracle DB's. Up until now, I've worked primarily with Windows and SQL Server. I'm trying to use your VM as a sandbox on my laptop and had a few questions. Hopefully you can help me out.

    1. I'm trying to create a new planning app and I need to create a new schema/user for the data source. What steps do I need to take to accomplish this? Is there an oracle admin account that I can use to log into sqlplus?
    2. It seems my IP address keeps changing. When I login to the vm and run ifconfig, the ip address is different than the initial setup. Because of this, I have to log into Hyperion workspace using the IP address instead of using the server name. I’m not sure what I’m doing wrong, is there a way to make it so that the IP address doesn’t change?
    3. Proper Shutdown – How do I properly shutdown the vm? Do I need to run the oracle epm stop script?
    Thanks in advance
    Norman

    ReplyDelete
    Replies
    1. To create a new schema, have a look at /u0/automation/database/install_DB_create_objects.sql

      Essentially,

      sqlplus / as sysdba
      CREATE USER EPM_HPAPP2 IDENTIFIED BY PWD DEFAULT TABLESPACE EPM_OBJECTS temporary tablespace TEMP profile DEFAULT;
      ALTER USER EPM_HPAPP2 QUOTA UNLIMITED ON EPM_OBJECTS;

      grant EPM_ROLE to EPM_HPAPP2;

      2) Regarding ip address, if you no longer need external access to the internet, you can to into oracle virtual box settings for the host and change the network from bridged to host only. This will give you a static ip but will not be available on the general network.

      3) regarding shutdown, I think just going to virtual box and hitting "insert CTRL+ALT+DELETE" and then power it down when it has started to reboot would work. I am not a huge fan of waiting 10 minutes to run the EPM stop scripts. Pretty sure this will work, but its not very graceful - though better than just powering it off.

      Delete
    2. Dear Nicholas King
      Today i came across your Blog,i found it quite helpful and its a big job you done for a great help.
      I have queries regarding Architecture of EPM for 11.1.2.4 version.
      kindly provide me in detail as we have planning and HFM in BOM.
      Looking for a prompt response
      Thanks in Advance for your time!
      Thanks &Regards
      Anwar Abbas

      Delete
  3. Dear Nick,

    For me the download of the kickstart script is not working.

    Is there a way that from the source forge I can download the script and run it later.

    Will it mess up with some package not being available with the os during the Installation Phase.

    Sorry for all spelling mistaked am using a german Keyboard.

    Regards,
    Bhasker

    ReplyDelete
    Replies
    1. The post section in the kickstart just tries to download and install this rpm,you can try it manually as root:
      curl -L http://sourceforge.net/projects/epmvirt/files/11.1.2.4.0%20EPM%20Virtual%20Env/epmvirt-11.1.2.4.0-3.x86_64.rpm/download -o EPMVirt.rpm
      yum install -y EPMVirt.rpm

      Also, have a look at /root/ks-post.log to see what happened during install.

      Delete
  4. This comment has been removed by the author.

    ReplyDelete
  5. Hi Nicholas,
    Thanks for this, this definitely saves a lot of investigation and time. Works pretty good for me!

    ReplyDelete
  6. Hi Nick,

    Thank you for instructions. I did installation on the physical server and it worked perfectly. I have some questions I need your help:
    1) What scripts shall I execute to stop/start EPM/Oracle database?
    2) I was not able to connect to HFM using SmartView? Do I need to do addition configuration/setup to make SmartView work?

    Thank you in advance, Slava

    ReplyDelete
    Replies
    1. 1) My preference for a test box is to just have it take care of itself - the environment automatically comes up on boot. Oracle should be pretty intelligent about recovering from shutting down the node hard. So I have not included stop/start scripts for the db. I would just power down the node, or more gracefully do a soft reboot and power it down when the OS comes down. If you do want to shut it down,
      sqlplus / as sysdba
      shutdown immediate
      You can use the /u0/automation/startDB.sh script to startup the db.

      2) You shouldn't have to do anything special to get smartview working. I was able to test it on my install using this url, http://epmvirt:9000/workspace/SmartViewProviders. If you want to look at this in more detail, please send details to info@interopconsulting.com.
      Thanks

      Delete
  7. Hi Nick,

    Thank you for quick turnaround. I figured out the issue with SmartView. I used SmartView version 11.1.2.1 and it did not work properly with 11.1.2.4. Shutting down database and DB related components is not an issue. I have notice all scripts are missing from EPM_ORACLE_INSTANCE/bin. It was my question about starting/stopping EPM.

    Thank you, Slava

    ReplyDelete
  8. This is a great post and tremendous contribution to the community.

    ReplyDelete
  9. As X Windows is not installed, given this configuration of OEL, do you have a tested approach to get a GUI interface running so that the that settings via the EPM configurator can be modified?

    Thank you!

    ReplyDelete
  10. As X Windows is not installed, given this configuration of OEL, do you have a tested approach to get a GUI interface running so that the that settings via the EPM configurator can be modified?

    Thank you!

    ReplyDelete
    Replies
    1. I use X11-Forwarding in Putty.
      Open putty, go to connection -> SSH -> X11. Click the checkbox that says "enable X11 forwading".
      Under X display location, enter "localhost:0". Save your connection changes.

      Then you just need a local x server on your windows machine, I use XMing. Just open xming so the X is displayed in your running tasks panel and try to launch an x app.
      Nick

      Delete
  11. Hi Nicholas, for me the process fails while installing Linux; I receive a message stating "Unable to Dowload the kickstart file. Please modify the kickstart parameter below..." and the parameter is http://interopconsulting.com/ks2.that seems to be right.
    Have you ever seen this before? Any idea on how to solve it?

    ReplyDelete
    Replies
    1. Login as root and try:

      curl -L http://sourceforge.net/projects/epmvirt/files/11.1.2.4.0%20EPM%20Virtual%20Env/epmvirt-11.1.2.4.0-3.x86_64.rpm/download -o EPMVirt.rpm

      yum install -y EPMVirt.rpm

      Delete
    2. Hey Nick, i am getting the same error while trying to do an installation for 11.1.2.3 .. also being new to Linux OS, if you help in making me understand, how to login as root .. do i need to do a linux insallation manually and then try this command that you have mentioned above ?

      Delete
    3. This probably means that the VM does not have a valid internet connection. In your adapter settings do you have it set to "Bridged"? Are there any firewalls or network restrictions which would prevent the vm from obtaining an IP address on your network?

      Delete
  12. Hi Nicholas,

    Thank you very much for this. Ive managed to install and run it smoothly. My question is to how to add HFM to the applications as I only see Planning and Essbase.

    Many thanks

    ReplyDelete
    Replies
    1. I think there may be an issue with the HFM configuration. I'll need to try and debug in my spare time. Currently I am bit overloaded. If you want to poke around, here are the initial notes when I got it working:
      http://epm-errors.blogspot.com/2015/02/how-to-get-hfm-running-on-11124-oracle.html

      Thanks
      Nick

      Delete
  13. Hi,
    Thank you for putting this together! I'm having an issue with it, however. It fails at the point listed below (from the output):

    sudo: /u0/app/oraInventory/orainstRoot.sh: command not found

    SQL*Plus: Release 12.1.0.1.0 Production on Mon Aug 31 16:46:36 2015

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

    ERROR:
    ORA-12547: TNS:lost contact


    Enter user-name: SP2-0306: Invalid option.
    Usage: CONN[ECT] [{logon|/|proxy} [AS {SYSDBA|SYSOPER|SYSASM|SYSBACKUP|SYSDG|SYSKM}] [edition=value]]
    where ::= [/][@]
    ::= [][/][@]
    Enter user-name: SP2-0306: Invalid option.
    Usage: CONN[ECT] [{logon|/|proxy} [AS {SYSDBA|SYSOPER|SYSASM|SYSBACKUP|SYSDG|SYSKM}] [edition=value]]
    where ::= [/][@]
    ::= [][/][@]
    SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus


    Any assistance would be greatly appreciated.
    Sabrina

    ReplyDelete
    Replies
    1. I tried creating the virtual box with Parallels Desktop and am encountering the same ORA-12547 error. Something is going wrong with the Oracle installation.

      Delete
    2. Please take a look here and I'll try to help:
      http://epm-errors.blogspot.com/2014/11/epmvirt-debugging.html

      Delete
    3. Are you sure you downloaded the correct version of Oracle Database 12c? That seems to be the problem.

      Delete
  14. Hi Nicholas,

    I am not a Linux guy. How do i start EPM once I restart the VM? When I login as "oracle" user, it just gives me the next prompt. What do I type?

    Thanks,
    smilo

    ReplyDelete
  15. Hello Nicholas,

    We were installing the virtual box and executed the "buildEPMvirt" command and after installing the database, and just after "running step number 2" I've got an error "IndexError: list index out of range". It refers to lines 79 and 35 of the file "/u0/automation/buildEPMvirt.py".

    After this error, everything stops and we can't continue further.

    Could you help us with this issue, please?

    Thanks for you help

    ReplyDelete
  16. It took several attempts but I eventually managed to get it working.
    An allocation of 5 Gb of RAM allows the VM to work but it's very slow. For people willing to try, I'd suggest using a higher amount of RAM.

    Thank you for this contribution.

    ReplyDelete
  17. This comment has been removed by the author.

    ReplyDelete
  18. Thank you so much for this - it's saved me a lot of time and hassle. The Oracle images have too many problems. The only thing I changed was when the install couldn't find the kickstart file - I changed the adapter type to NAT and it worked. I then changed it back to Bridged after the install.

    ReplyDelete
  19. Thanks a Lot Nicholas. I was able to follow the provided procedure and successfully installed 11.1.2.4 on a Windows 10 machine using the Virtual Box 5.1.4. Although I notice a few performance issues, I assume it is because of just 5 GB of RAM allocated.

    ReplyDelete
  20. Pure gold Nicholas. The way you brought it together with python is impressive. I hope you don't mind. I may have to borrow some of your ideas for doing EPM Deployments in the future.

    ReplyDelete
  21. Nicholas, my Planning install is complete. Any document which could guide me with the Hyperion planning software learning?

    ReplyDelete
  22. the default font package which got installed as part of the OS install is very weak. How can I fix the fonts in OEL?

    ReplyDelete
  23. The software is installed. I had to shutdown the VM and restart. Is their a script to start all the Hyperion services and DB automatically on start of the machine?

    ReplyDelete
  24. Hi everyone.
    I successfully followed all the steps and got my EPMvirt working a few months ago. However, I had not explored some of it's features as of yet. Now I've realized that --for some reason-- the Business Rules of the PLANDEMO application were not imported during the install of the environment. They don't seem to exist anywhere even though they are listed when I got to Tools>Business Rules inside the PLANDEMO application. Whatever it happened, it's sure they don't exist in Calc Manager.

    Hence I'm asking if someone could kindly export the BRs and post them somewhere so I can fetch them and re-import them.

    Thank you so much in advance.

    Cheers!

    ReplyDelete
  25. What is the sysdba username for Oracle server?

    ReplyDelete
    Replies
    1. Hi Sahil.
      Try with

      SYS user: SYS , password: orcle
      DBA user: SYSTEM , password: orcl

      Cheers!

      Delete