Recent Posts


Using Oracle HTTP Server 12c with Oracle EPM (Hyperion)
Posted on March 29, 2017
Author: Andy Tauro, Performance Architects

Ever since Oracle released Oracle Business Intelligence Enterprise Edition (OBIEE) 12c (12.2.x), it has been a waiting game to see when Oracle EPM (Hyperion) would move to the 12c versioning.  As of the date of publication of this blog post, the latest version of Oracle EPM is, which bundles many improvements over the prior releases of Oracle EPM. However,  Oracle Fusion Middleware (FMW) is still 11g, to be precise This includes Oracle HTTP Server (OHS), and we have been asked more than once when Oracle EPM will be updated to use the latest version of FMW or OHS.

As a workaround to meet Infrastructure standards, we often set up a standalone instance of OHS with EPM. Until recently, the version of OHS that we typically used was OHS, which is the latest version of OHS in the 11g family.

With the migration to 12c versions of Oracle Relational Database (RDBMS), OBIEE and WebLogic, the 12c version of OHS is also being adopted as part of some of these products. The natural progression is to bring EPM into the fold. But the transition is not simply plug-and-play.

OHS 12c is based on Apache HTTP Server 2.4, whereas the 11g version was based on 2.2. The change in the base code results in changes in the implementation. While most of the functionality is the same, there are some key differences in the directives used. For instance, “Order” and “Deny” directives have been replaced by the “Require” directive. Luckily, there is an Apache webpage that lists a lot of the changes:  https://httpd.apache.org/docs/2.4/upgrading.html

This is not a certification of Hyperion EPM with OHS 12c. While we have seen it work for the uses that we have put this combination through, this does not imply Oracle’s support for the combination at this time. The reason for this is most likely the fact that Oracle EPM is closely integrated into the instance of OHS that gets deployed with it. In the above-described scenario, the 12c instance of OHS serves as a duplicate to the bundled instance and serves as a proxy to the requests that it serves.

While there are benefits to integrating OHS 12c with Oracle EPM, such as updated security code and better performance, it is necessary to keep in mind the Oracle Support certification of the solution. Continued support from Oracle for a complex suite of tools like Oracle EPM is essential, so keeping the solution simple helps. And this also reduces the chances of the solution breaking down when the next upgrade comes around.


© Performance Architects, Inc. and Performance Architects Blog, 2006 - present. Unauthorized use and/or duplication of this material without express and written permission from this blog's author and/or owner is strictly prohibited. Excerpts and links may be used, provided that full and clear credit is given to Performance Architects, Inc. and Performance Architects Blog with appropriate and specific direction to the original content.

2 thoughts on “Using Oracle HTTP Server 12c with Oracle EPM (Hyperion)

  1. Venu says:

    Hi Andy,

    We have Hyperion running on multiple Windows servers and it has OHS (bundled with Hyperion) configured in multiple servers. We would like to upgrade OHS to to integrate Hyperion with Oracle Access Manager (OAM) to enable SSO functionality.

    But we could not locate any documentation how to use/upgrade OHS to for Hyperion. And if the OHS is upgrade, whether it is certified with Hyperion and if it supported by Hyperion Configurator.. if we ever had to re-configure Hyperion.

    Can you please share your ideas on how to achieve this?


  2. andytauro@PA says:

    As per the EPM compatibility matrix, OHS is not certified with Hyperion EPM. And with the push to the Oracle Cloud, it is not likely to happen soon, if ever. Having said that, to achieve the setup that you are aiming for, the safest bet is to install the new version of OHS in a separate Home and use that to front your EPM environment. We have similar setups at multiple locations, and they perform without issues or compatibility problems.
    Hope this helps,

Leave a Reply

Your email address will not be published. Required fields are marked *