Wednesday, April 25, 2012

EPM Installation and Configuration - First Impressions Part 2

I know many of you have been waiting to see more details about the EPM release. I have been really busy at work as my calendar is pretty much full of EPM upgrade projects... But here's the update I promised with details about:
  • EPM Deployment Report
  • Enterprise Manager
  • The new HFM web interface and more

EPM Deployment Report

The deployment report is a handy new feature added into the epmsys_registry utility that allows you to output a compact collection of the EPM System installation details.

You create the report by running the epmsys_registry utility with parameters "report deployment":

cd /d d:\Oracle\Middleware\user_projects\epmsystem1\bin
epmsys_registry report deployment

An HTML formatted report is saved to:

Let's split the report into parts and see what kind of information it contains. As you can see each section has a heading and a friendly description text that tells what is documented here:

The Application Tier Components section lists all applications installed on each server. In addition to the server name (here it's the IP address of my VM) the operating system and memory capacity is also recorded. Also note the WebLogic managed server called EPMServer0 running on port 9000 which is the single JVM running web applications in the Compact Deployment mode.

The Data Directories section lists the filesystem paths containing application data and mentions that these directories need to reside on a shared file system in a clustered environment. And while talking about data directories I might note that the LCM import_export path can now be changed in EPM System Configurator when configuring Foundation Services. No need to mess with the HSS Registry properties when changing the path which is a nice touch.

Last part is called the Deployment History and it shows a step-by-step list of configuration tasks performed on the system. This data (among everything else shown in the report) is stored in the Shared Services Registry database.

Enterprise Manager Fusion Middleware Control

Oracle Enterprise Manager is now automatically installed and configured during the WebLogic domain creation for the EPM System. EM was already bundled with EPM but to actually use it you had to deploy the application yourself using WebLogic admin console.

With the EM Fusion Middleware Control you can administer and monitor WebLogic applications and OHS web servers installed on the EPM servers. To access the web interface you need to start the WebLogic Admin Server on the server where you first configured Foundation Services on using either of these methods:
  • C:\Oracle\Middleware\user_projects\domains\EPMSystem\bin\startWebLogic.cmd or the equivalent path and batch script on Unix or Linux
  • On Windows: Start menu > Oracle WebLogic > User Projects > EPMSystem > Start Admin Server for WebLogic Server Domain
You will be presented with an overview of the EPMSystem domain:

From there you can access numerous statistics about the WebLogic managed servers and deployed applications. Oracle EM is not something I have used a lot before but it looks like the Fusion Middleware Control could be a useful tool for checking web application performance figures on a live system.

Managed server response and load graphs
Application sessions and request processing statistics
Oracle Middleware applications use a framework called DMS (Dynamic Monitoring Service) to exchange monitoring data, trace events and other diagnostic information between the components. This information can be displayed via web browser by accessing the DMS Spy servlet at http://servername:7001/dms . I need to educate myself in the mysteries of DMS (this would seem like a good starting point) but it looks like you could easily create a monitoring script that checks any of the gazillion WebLogic and Java metrics that are available via HTTP queries.

Online Help Files

This is a change that is not that visible but I thought you might want to know about it... The help system that is accessible in Workspace and from the Windows clients as well is now served from the Internet by default. This means that every time a user opens the Help function their browser will be fetching the content from If you'd rather have the help content delivered locally you need to follow the steps described in the EPM Installation and Configuration Guide, section "Installing and Configuring Online Help" to download the files and to make the required changes in the OHS configuration files.

Phew, I think I will leave the HFM UI part for a later update as this post has grown long enough already... Feel free to share comments and insights about the new release in the comments or via email if you have already tried it!

Update: My post about the HFM user interface can be found here:


  1. Hi Henri,

    I have installed EPM in vmware server (windows server 2008). When I launch weblogic, epmserver0 is always down. Also when I launch workspace or shared services link, I am getting, "Error 404--Not Found
    From RFC 2068 Hypertext Transfer Protocol -- HTTP/1.1:"

    Can you please give any suggestions.

    Saranya Suresh

    1. Do you see any meaningful errors in the log files produced under the following paths?

      Based on my experience you generally get this kind of errors (web apps not starting) when there's something wrong with the repository database or the JDBC settings in Weblogic. You can use the following steps to verify the database settings in Weblogic Admin Console:

      - Start the WebLogic console for the EPM domain: 'Start' -> 'Programs' -> 'Oracle WebLogic' -> 'User Projects' -> EPMSystem' -> 'Start Admin Server for WebLogic Server Domain'
      - Log in to the WebLogic console: http://:7001/console
      - The user/password combination is what you declared during the EPM System configuration.
      - On the Home Page click 'Data Sources': (under 'Domain Configurations -> 'Services' -> 'JDBC')
      - Select 'EPMSystemRegistry' or the Data Source you require.
      - Click on the 'Connection Pool' tab to view the database settings

      Hope this helps,

    2. The Weblogic console address got mangled... It's http://servername:7001/console

  2. Hi Henri,

    I'm trying to install on Windows 2003R2 server with oracle 10g as database.but its not happening.when I run install tool.cmd it is running properly but at one stage the installation will stop and it won't show any error message

    please help out on this


    1. How far are you getting into the installation? Is it the same component that fails if you try to run the installation again?

  3. I have installed and configured Validation fails with http error on most of them. Any ideas?

    1. What are the errors like in more detail? HTTP errors I tend to see in the validation reports often seem to be false alerts (some kind of issues in the validation scripts).

  4. Hi Henri,

    I'm trying to install on Windows Server 2008 Standard SP1 64 bit. After OS installation, I updated with latest windows updates and enabled MS LoopBack adapter.

    I installed Oracle 11g R2 database 64 bit.
    Oracle client 11g R2 32 bit.
    Oracle client 11g R2 64 bit.

    Is this the right order?

    After I install, the 64 bit client, I do not see a separate short cut for it in Windows Programs Menu, even though I see the files in the Oracle base directory I created for the 64 bit client.

    1. Hi, that is the correct order (as also mentioned in the EPM Installation Start Here guide). The 64-bit client should work fine even though you are not getting the shortcuts in the Start menu.