Monday, 26 April 2010

EPM 11.1.2 Installation

Well it finally arrived, nobody seemed to know the exact day it would appear and there was so much speculation around when it would.
Even though Oracle doesn’t make a fanfare about when it releases software, with all the activity on the various blogs and forums it didn’t take long for the word to spread.

For some reason I had this vision that many were constantly refreshing edelivery waiting anxiously for a glimmer of excitement in their lives. I am not putting myself in that bracket even though many would try.

Anyway I am not going to blurb on about meaningless nonsense, as I am sure that will not hold your attention for long. Today I want to go through the installation of 11.1.2 and highlight any issues I come across and point out any new items that are worth giving a mention.

It is just under 2 years since I blogged about installing the first major release of 11 and taking you throughthe new features and now the time has come to return to the challenge. Please note these are just my early observations of the new release, I apologize if any of the comments are inaccurate or you disagree with them.

The first document I checked out was the support matrix to pick up any new additions, you can download the Excel document here

There are a handful of new updates that interest me.

Operating System :- Windows 2008 x86 and Windows 2008 x64 are now officially supported, this is good news as I know the question has been asked many many times when it would be supported and the rumours were true.

On Windows x64 most products are now true 64bit with the exceptions of FDM, Financial Reporting Print Server, Interactive Reporting Services, and Strategic Finance.

Staying with Microsoft, SQL Server 2008 is supported as a repository and datasource though cannot be used as repository for ERP Integrator.

Finally Java 1.5 has bitten the dust and Java 1.6 is now the standard.

Microsoft Client Side :- Windows 7, Vista SP1+ and Windows 2008 SP1+ are all now supported for 32bit

The list of Microsoft 64bit supported clients has certainly grown, as I am sure it just used to be Windows 2003, the list is now XP Professional SP2+, Vista SP1+ and Windows 7.

Browsers :- Internet Explorer 8 at last becomes supported and good news that Firefox 3.5.x is on the list though not if you use FDM.

I am not going to go through individual new product features today, but in the EPM system readme there are some new additions and changes that are worth airing.

Goodbye Tomcat and Hello Weblogic– “WebLogic Server (replaces Apache Tomcat as the embedded Java container), Oracle HTTP Server (replaces Apache Web server as the embedded Web server)” – I know weblogic is far superior on a production system though I did enjoy using Tomcat as it is a lightweight installation and is very useful when prototyping or using a VM that can’t be given many GB of memory resources.

“Most EPM System products have adopted Oracle Diagnostic Logging (ODL) as the logging mechanism. The ODL framework provides uniform support for managing log files, including log file rotation, maximum log file size, and the maximum log directory size” – On quick inspection it looks like you now can update an logging configuration xml file to define how you want to maintain logs for each of the products, something I may cover in the future.

“Oracle Configuration Manager (OCM) integrates with My Oracle Support and provides configuration information for Oracle software. It assists in the troubleshooting, maintenance, and diagnostics of your EPM System deployment.” – This seems an interesting concept and it is the first time I have come across the process. I would like to see if it is actually worthwhile and how it interfaces with Oracle Support.

A little more information on the product

Oracle Configuration Manager (OCM), which EPM System installations include in the EPM Oracle home directory, collects information about your Oracle software installation and configuration and uploads the information to My Oracle Support. The information collected by OCM speeds resolution of problems and enables My Oracle Support to tailor content for your configuration.
Product documentation can be found here

“This release is intended for new deployments only. Upgrading or migrating from previous EPM System releases is not supported. In addition, products from this release are not compatible with products and applications from previous releases.” – Sorry you are going to have to wait for a future release to upgrade your current version 11 installation. Considering the amount of core changes there are in this release would you really want to trust an upgrade in future or is it best just go down the route of a clean install?

“Relational Database as Native DirectoryReplaces OpenLDAP as the central storage for native EPM System user accounts and provisioning information. Unlike previous releases, this release supports using only a relational database as Native Directory. Native Directory is created in the database that you configure as the Shared Services database while deploying EPM System components.” - So long Openldap you crashed far too many times and had to be recovered, not sure how much it will be missed, using a relational source is definitely the logical way to go.

“The EPM System directory structure has changed. The default directories are now Middleware Home and EPM Oracle Home – The default EPM Oracle home location is MIDDLEWARE_HOME/EPMSystem11R1”– Does this mean the mention of Hyperion in the directory structure is no more, well at least directories should have been dropped.

“The new Foundation Services Web application consolidates to one JVM and includes these Web applications: Shared Services and EPM Workspace.” – Interesting Shared Services is now being integrated with workspace but does this mean if workspace crashes all authentication across the EPM system is lost or do all the products now communicate directly with the relational directory.

Ok on to the installation, as I mentioned that Windows 2008 is now supported so I am going to give it a test drive to see if everything goes smoothly. I am going to use the 32bit OS as it will be easier for demo purposes. I hope to test out the Windows 2008 64bit version in the near future.

First of all if you are considering installing many of the products on one machine make sure it is of a high end spec and has plenty of memory, this version is much more resource hungry than previous versions.

The installation process is pretty much similar to previous version 11 installs.

First make sure you have downloaded all the required files, the best place to download the full set of files is Oracle edelivery.

The foundation parts 1-4 (V20799-01,V20800-01,V20801-01,V20802-01) and the installer (V20850-01) are vital, it is also worth downloading the “additional contents file” (V20843-01) as this includes the Oracle HTTP component. (this blog uses all of the above files)
Additionally you will need the files for products you want to install.

Extract all files to the same directory, this is very important. Also make sure you have plenty of room on the drive you are installing the EPM suite to it has to be about double the size of all the extracted files, if it is not the installation will fail.

Double click installTool.cmd and this should start up the installer, it will check if the machine you are using passes the prerequisites.

The installer looks pretty much the same as the previous V11 installer.

Drive was changed to F:\ as I didn’t want to install on the C:\ drive.

You can select to install the products individually or by tier, I kept the default which is selected by tier.

I have most of the product set selected.

The above screen just highlights all the components that are going to get installed.

Click next and off the installation goes.

Notice WebLogic Application Server and Oracle HTTP server are automatically installed in this release.

I would go off and do something more interesting because depending on the number of products you are installing it can take a while, just hope on your return that all the icons are green.

That is what you want to see all green icons and the code of EPMINS-1020

In the start Menu you should hopefully see “Oracle EPM System”, “Oracle Web Tier 11g – Home1” and “Oracle Weblogic”.

You should also have a file structure similar to the one above.

On to the configuration, click the configure button (ok I clicked it and nothing happened) so I went through the start menu instead > Oracle EPM System > Foundation Services > EPM System Configurator.

Think I must of hit the first bug :- 9402134 - On the EPM System Installer summary window, clicking the Configure button does not start EPM System Configurator.

The first screen will display all the product areas that can be configured depending on what products you have installed. I never go down the route of configuring everything at once.

I have seen installations go wrong when everything is selected at once so I unchecked everything and just left Foundation just to be sure. This is just the way I like to go about it and everybody has their own preference.

This is the minimum requirement for the first configuration, there are a couple of notable additions to the foundation configuration in this version, “Configure Logical Address for Web Applications” and “Configure Oracle Configuration Manager”

As this is the first configuration “Perform 1st-time configuration of Shared Services database” should be selected.
Database connection details are then entered. I had already set up a number of schemas to be used as the EPM repositories, I know you can probably use one schema but I like to separate them out by product.

The next screen is basically just used to enter Mail server information that will be used with the EPM system.

This is one of the new additions that I highlighted earlier OCM, it should integrate with My Oracle Support and assist with troubleshooting any issues with the configuration. I am not sure how it does work yet hopefully the documentation will make it clearer.

Another new addition to the configuration, maybe too many people were sticking with the default password with previous installs.

Clicking next will configure the foundation components.

Once again all green ticks are what you are expecting.

If you check your services you should see two new services that have not been seen in previous releases.
“Oracle Process Manager” – You will get to know more about this product if you install essbase (or Oracle HTTP Server) as it used to control starting, stopping and managing failover for essbase clustering.

The other service is for “Oracle Configuration Manager” which I highlighted earlier, Oracle have decided to give it the longest service name in history.

Next I deployed the Foundation Application Server.

The default settings were kept, I just changed the admin user and supplied a password.

Default settings were kept; notice workspace is now running on the same app server instance as Shared Services.

The application server deployment was successful.

You should have a new service “Hyperion Foundation Services – Managed Server” – the service will be set to automatic, I usually change this manual and use a start up script to start the services I require. You will also notice there is no longer an OpenLdap service.

Shared services can be tested just as you would in other version 11 releases e.g. http://<foundation_server>:28080/interop/index.jsp

If shared services is up and running you are in a good position with your configuration and can carry on.

Shared services is pretty much the same as previous releases, the look has slightly changed to fit in line with Oracle Middleware products.

Next, on to configuring essbase.

Essbase Custom Configuration was selected.

You will notice that there is an option to set an “Essbase Instance Name”, this is the name that Oracle Process Manager will use to interact with essbase.

The full path to essbase has changed in this release; products now sit under <EPM_ORACLE_HOME>\user_projects\epmsystem1\..

You also have the option of setting the ARBORPATH environment variable, this is not set by default.

In previous version 11 releases this variable was only set for the administrator who installed the product, if you logged in as another user the variable would not be set and you can encounter problems when using Maxl or esscmd.

Configuration was successful.

If you look at the windows services there will not be a service there that relates to Essbase, as I said earlier “Oracle Process Manager” controls this.

If you start the service you should find that the Essbase process starts.

You can then use command line to start, stop and restart essbase for example

opmnctl startproc ias-component=EssbaseInstanceName
opmnctl restartproc ias-component=EssbaseInstanceName
opmnctl stopproc ias-component=EssbaseInstanceName

You can also start essbase using :-


This method will still use OPMN, if OPMN is not running it will first start up the OPMN processes and then start up Essbase.

If you want to find more information on OPMN go here

You don’t have to use OPMN to start essbase, I can see OPMN being more beneficial if you are using Essbase clustering.

If you don’t want to use OPMN you can start essbase by using <EPM_ORACLE_HOME>\user_projects\epmsystem1\EssbaseServer\essbaseserver1\bin\startEssbase.bat

Now I am not going to through the configuration of the rest of the products as many of the screens are quite similar and if you have installed previous releases there is nothing outstandingly different.

What I will say is that I configured “Hyperion Foundation” > “Configure Web Server” last, this is because it configures Oracle HTTP Server for the products that will be accessible on port 19000 via workspace (that is if you are using Oracle HTTP Server as the web server and the default port).

You can run the web server configuration again at any point and it should pick up any new products that have been installed.

When I was configuring the web server it did seem to freeze at 50% for an age, so I cancelled it and ran the configuration again and it picked up the configuration where it left off at 50% and completed successfully.

The Oracle HTTP Server is also controlled by OPMN and a service should have been created with a friendly looking instance name.

If you do have any issues with configuration and are wondering where the logs have moved to have a look at :-

Well I am going to leave it there for today, there are many more areas to cover but they are for another day.


srx said...

Yep I can tell when it appeared on edelivery, it was on April 21st around 01:00 PM GMT... yeah I must admit that I was there, there curious to get that component I've been waiting for so long. So I waited for a component that was born dead or bugged born - I'm talking about the so awaited self contained Excel add-in! What a mess - a real joke! Selected language is not even applied. I was curious to see the NEW promised features such as Essbase web service and plsql query etc. But non of then were actually delivered with 11.1.2. What about next version now?!

Dinga400 said...

Hi John,

I had a successful installation. However after attempting to running the configurator, I received an error saying the following:

Total jars and classpath entries encountered: 417
Total non-existing referenced classpath entries count: 55
Total Classpath elements to check: 67
ERROR: C:\Oracle\Middleware\oracle_common\modules\oracle.http_client_11.1.1 jar not exists; file depth: 2; referenced from C:\Oracle\Middleware\EPMSystem11R1\common\jlib\\epm_soa.jar referenced from C:\Oracle\Middleware\EPMSystem11R1\common\config\\configtool.jar


FATAL ERROR: Jars manifest check failed with message "Some referenced jars do not exist"
Exiting in 30 seconds

Any ideas?

Eshwar said...

Hi John,
Thanks for posting this EPM 11.1.2 installation process.
This is my first time installion in version 11.
I have done the installation and every thing as you mentioned.
I have started the Essbsae server by running batch file startessbase.bat at location

I got some questions

1.How can i get to know , IS Essbase server is running or not.
2.How can i set the Essbase server name and user details .( i did not see any thing at the time of configuration)

John Goodwin said...

If you check the processes in windows task manager and see ESSBASE.exe then the essbase server will be running.
I am not sure about your second question as you don't give essbase a server name, it is just accessed by the name of the server.

Anonymous said...

Thanks John.
Now every thing fine.
Thank you so much once again.

Anonymous said...

Hi John ,

How can i access workspace, What is the url for that.


pavan said...

Hi John,

I am trying to Install EPM 11.1.2 on 2 servers. First box I want to install Foundation and Reporting. Second box for Essbase and Planning. I downloaded and extracted the Installer, Essbase Server, Essbase Client, Planning, Additional components into a folder. But I cannot install anything. What parts of Foundation Services should I use(part1 to 4) to just install the Web server, Essbase and Planning?

John Goodwin said...

If you have installed and configured Oracle HTTP Server and R&A framework, you should be able to access workspace on http://:19000/workspace/index.jsp

John Goodwin said...

I am not clear on the exact foundation files you need, I know in the documentation outlined the required foundation files.
If you are unsure then I would extract foundation 1-4 to be sure.

pavan said...

Thanks John. I have installed all the products successfully but am unable to launch workspace. 'http://hostname:19000/workspace' am using this url. I am able to launch and login to Shared services. What might be the reason?

John Goodwin said...


You may need to install and configure the following files :-
Oracle Hyperion Enterprise Performance Management Reporting and Analysis Core Components Release
Oracle Hyperion Enterprise Performance Management System Additional Content Release

Abhishek said...

Thanks John,
Your blogs and posts on OTN are so helpful, just cant qunatify it.


DG said...

Hi John, We want to create a Hyperion 11.1.2 sandbox for our deveoplers to try out the latest version. My biss has asked me to spec out a couple of servers. Could you please recommend a pair of servers using Windows Server 2008? I have searched all over the internet and I have not found a good "recommendation" out there. I have review the "Matrix" create by Oracle, but that just list what is support and what is not. It does not give a "Here is a recommended architecture" so to speak. Any advise would be apprecaited.


John Goodwin said...

Hi Dave,
If you have a read of the installation document at :-

Section "Sample Deployment Scenarios" should give you some ideas to start with.

Kumar said...

I think your installation and Configuration is really useful becoz in most of the blog then that only talking about the successful installation and configuration.

I was facing the problem while configuring the Hyperion Foundation Services i.e., the webserver was freeze then I was in a state of confusion & finally found out from your blog that we can cancel and restart it.

Thanks a Lot.....!!!!

Carlos said...

Hi there, this did help me a lot!!
Very nice, I didn't have any problemas at all.
Can I make same http requests??


Ali said...

Hi, It will be very useful article for EPM 11 Lovers.

DPress said...

John - I too like to have different schema for each product - I was successful on first round with Shared Services and EAS then I repeated just selecting FR & R&A and now my oracle DB (Same instance different usernames / schema) hits its maximum of 32 gb????

There must be something funny goning on - have i left a logging parameter on or ...


Dan Pressman (DanP from Network54)

John Goodwin said...

Hi Dan,
Something seems very wrong, configuring the relational repository elements should not take up much space by default.
Maybe an issue on the database side as you shouldnt really need to make changes on the EPM side.



Anonymous said...

Hi john,

Thanks for your blog but i want up gradation document for 11.1.1 to

can u help me for this

DPress said...

Still having problem with the compact install I am getting msg that "The following prerequisites were found to be missing:
Oracle EPM Webservice libraries -"

I thought those were in 25494 and I know that was unzipped.

DPress said...

OK John I found the problem - I for some reason did not install the c api

Anonymous said...

Hi John
Great blog
Just realised my downloaded V20799 zip is corrupt and cant be unzipped. Anyone know where this version is to download as now on eDelivery

Jay said...

Hi John

A very helpful blog for someone who is new to Hyperion and installing it for the first time.The installation went perfectly but the system will not let me configure. The error i get states:

Fatal error:"Inventory existence check failed with message: Failed to determine EPM_username home; "

I tried troubleshooting on internet but I only found one related post and that is not helping. Any suggestions here?

I have 64 bit Windows Home edition if that helps.

Unknown said...

I'm a regular reader of your blogs..

I'm attempting a distributed install of EPM (only reporting and analysis) managed to do the foundation services and reporting services in the first box. In the second box I installed webserver with raframework webapplication and OHS. All works sweet.

When I tried the same with IIS on the second box - IIS on port 80 gives forbidden 404 or 403 message.

boxes are both in a workgroup , windows 2008 64 bit and no firewall inbtw.

wonder if you have come across this issue ?