Load Balancing Data Relationship Management Web Applications

You can configure Oracle HTTP Server to provide load balancing support to two or more Oracle Data Relationship Management Web applications. You set up Oracle HTTP Server to redirect requests to the IIS servers hosting the Data Relationship Management Web client. This procedure assumes that the Oracle HTTP Server installed by the EPM System Installer is the logical host. The EPM System Installer performs the necessary prerequisite checks for Oracle HTTP Server. For more information, see the Oracle Enterprise Performance Management System Installation and Configuration Guide .

To set up Oracle HTTP Server as a load balancer for the Data Relationship Management Web client:

Install the Data Relationship Management Web Server component on two or more computers running IIS.

The Data Relationship Management Installer is generally designed to install the Data Relationship Management client applications to the Default Website, where the Default Website’s IIS Site Number is 1. In special circumstances where the first IIS site is non-HTTP, or the Default Website is not IIS Site Number 1, the Data Relationship Management client applications may need to undergo a one-time manual installation into IIS. For any customer impacted with this special situation, contact Support for assistance if needed.
Configure Data Relationship Management applications and host computers using the procedure described in Configuring Data Relationship Management Applications.
Open the httpd.conf file for Oracle HTTP Server found in the following location:

MIDDLEWARE_HOME/user_projects/epmsystem1/httpConfig/ohs/config/OHS/ohs_component/httpd.conf
Ensure that the following directives exist and are enabled. Add the directives if they do not exist.

LoadModule proxy_balancer_module "${ORACLE_HOME}/ohs/modules/mod_proxy_balancer.so"

LoadModule headers_module "${ORACLE_HOME}/ohs/modules/mod_headers.so"
Create a proxy balancer definition for the Data Relationship Management Web client by adding a BalanceMember directive for each IIS server that hosts the Data Relationship Management Web Server component.
```
#Configure members for cluster
<Proxy balancer://iisdrm>
  	BalancerMember http://Machine1:80/drm-web-client route=server1
  	BalancerMember http://Machine2:80/drm-web-client route=server2  
</Proxy>
```
Enable sticky load balancing by adding the following directives. These sample directives instruct Oracle HTTP Server to insert a cookie that keeps track of the route for sticky load balancing of the proxy balancers defined in the previous step.
```
Header add Set-Cookie "BALANCEID= iisdrm.%{BALANCER_WORKER_ROUTE}e; path=/drm-web-client;" env=BALANCER_ROUTE_CHANGED
```

Add the following Forward and Reverse Proxy directives.

#The actual ProxyPass
ProxyPass /drm-web-client balancer://iisdrm stickysession=BALANCEID nofailover=Off

#Do not forget ProxyPassReverse for redirects
ProxyPassReverse /drm-web-client http://<drm_web_server1>:80/drm-web-client
ProxyPassReverse /drm-web-client http://<drm_web_server2>:80/drm-web-client

Save the httpd.conf file and restart the Oracle Process Manager server for the Oracle HTTP Server instance.

After configuration, the Data Relationship Management web application can be accessed using the following URL: http://<ohs_server>:<port>/drm-web-client.