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:

Saturday, January 31, 2015

EPMVirt: Get Your New Hyperion 11.1.2.4 Virtual Environment

I have finished putting together the latest EPMVirt release for automating the new Hyperion 11.1.2.4 Installation/Configuration. Check it out:
What is EPMVirt?
  • Prerequisites completed for Oracle RDBMS/EPM
  • Automated Linux Install
  • Automated Oracle DB Installation
  • Database configuration for EPM
  • Automated EPM Installation
  • Automated EPM Configuration
  • Automated Configuration of Sample Planning App
Don't spend time fussing around with the install, try EPMVirt and immediately start evaluating Hyperion 11.1.2.4!

Thursday, January 29, 2015

Having trouble starting MAXL on 11.1.2.4 (and Essbase Server)?



Having trouble starting MAXL on 11.1.2.4 (and Essbase Server)?

[oracle@EPMVirt bin]$ ./startMaxl.sh
/u0/Oracle/Middleware/EPMSystem11R1/products/Essbase/EssbaseServer/bin/essmsh: error while loading shared libraries: libnuma.so.1: cannot open shared object file: No such file or directory



[oracle@EPMVirt bin]$ yum whatprovides libnuma.so.1
numactl-2.0.7-6.el6.i686 : Library for tuning for Non Uniform Memory Access machines
Repo        : public_ol6_latest
Matched from:
Other       : libnuma.so.1



(As root install...)
[root@EPMVirt ~]# yum install numactl

Installed:
  numactl.x86_64 0:2.0.9-2.el6


Works now...
[oracle@EPMVirt bin]$ /u0/Oracle/Middleware/user_projects/epmsystem1/EssbaseServer/essbaseserver1/bin/startMaxl.sh

 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>

Wednesday, January 28, 2015

New Oracle EPM 11.1.2.4 Installation & Configuration


I am currently running though install and config of the new Oracle EPM 11.1.2.4 release. The following is the roughly outlined process...


The 11.1.2.4 EPM binaries can be found here:
http://www.oracle.com/technetwork/middleware/epm/downloads/index.html

I downloaded the following files:
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

In addition, pick up the Client installers and OHS if you prefer to use OHS.

Installation

I ran through the installer, selecting nearly everything available:
/u0/install/epm/installTool.sh




Installer summary:



On to the config...

/u0/Oracle/Middleware/EPMSystem11R1/common/config/11.1.2.0/configtool.sh


I like to configure each component separately. I find that it helps localize any errors that might occur and helps keep my mind on a single task to avoid making human errors during config.



































































Starting the environment....

[oracle@EPMVirt database]$ /u0/Oracle/Middleware/user_projects/epmsystem1/bin/start.sh
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


Logging in...
http://epmvirt:9000/workspace/index.jsp




Next I will spend time to do some regression testing and make sure everything is working as expected. To be continued...