Using Oracle HTTP Server 12c with Oracle EPM (Hyperion)

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:

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.

Leave a Reply