Configuring software loadbalancer for Oracle E-Business Suite

Posted in: Technical Track

HAProxy (high availability proxy) is a free, open source software that provides TCP & HTTP-based load balancing capabilities for various applications. As it supports session persistence by enabling the sticky bit, this software can be used with Oracle E-Business Suite as a software-based load balancing application that helps to achieve high scalable and availability application services.

The following steps help to configure HAProxy load balancer services. For configuration purposes, the following names were used to demonstrate this.

Server Linux server acting as a load balancer and running HAProxy and would listen to E-Business suite on 80 port.

Servers, E-Business suite middle tiers and running Apache on 8000 port.

Server E-Business suite database tier.



1. Set up HAProxy utility as the root user on load balance servers.

[[email protected] ~]# yum install haproxy -y
[[email protected] ~]# chkconfig haproxy on

2. Configure syslogd service for HAProxy. Save /etc/rsyslog.conf after making the changes below and restart the service. All incoming requests would be logged into /var/log/haproxy.log and can be used for any troubleshooting.

[[email protected] ~]# cp -p /etc/rsyslog.conf /etc/rsyslog.conf_$(date + %d%m%y)
[[email protected] ~]# view /etc/rsyslog.conf
#$ModLoad imklog # reads kernel messages (the same are read from journald)
$ModLoad imklog # reads kernel messages (the same are read from journald)
#$ModLoad imudp
#$UDPServerRun 514
$ModLoad imudp
$UDPServerRun 514

[[email protected] ~]# echo "local2.* /var/log/haproxy.log" > /etc/rsyslog.d/haproxy.conf
[[email protected] ~]# systemctl restart rsyslog

3. Replace the HAProxy default config to loadbalance E-Business suite middle tier. Save /etc/haproxy.cfg after making the below changes and bounce HAProxy service.

[[email protected] ~]# cp -p /etc/haproxy/haproxy.cfg /etc/haproxy/haproxy.cfg_$(date + %d%m%y)
[[email protected] ~]# vi /etc/haproxy/haproxy.cfg
option forwardfor except
option forwardfor except header ClientIP

frontend main *:5000
acl url_static path_beg -i /static /images /javascript /stylesheets
acl url_static path_end -i .jpg .gif .png .css .js

use_backend static if url_static
default_backend app
frontend main

default_backend ebs

backend app
balance roundrobin
server app1 check
server app2 check
server app3 check
server app4 check
backend ebs
balance roundrobin
cookie LB insert
server app ebsapps01:8000 cookie ebs-app1 check
server app ebsapps02:8000 cookie ebs-app2 check

[[email protected] ~]# haproxy -f /etc/haproxy/haproxy.cfg -c
[[email protected] ~]# service haproxy start

4. Configure E-Business suite middle tier to listen on HAProxy server. Change the following context file variables and run autoconfig on both E-Business suite middle tiers. Port 80 being http default, URL config is not populated with port details.

[[email protected]/02 ~]$ $ADMIN_SCRIPTS_HOME/
[[email protected]/02 ~]$ vi $CONTEXT_FILE

Variable Name                                Configuration values
s_webentryurlprotocol  http
s_webentryhost         ebs-lb
s_active_webport       80

[[email protected]/02 ~]$ $ADMIN_SCRIPTS_HOME/
[[email protected]/02 ~]$ $ADMIN_SCRIPTS_HOME/

With the above steps, we could configure HAProxy load balancer for E-Business suite with no additional cost to the load balancer. Also, Keepalived utility can be used with HAProxy for configuring the virtual IP and enable the failover in case of an HAProxy server failure to provide uninterrupted services to the users.

Want to talk with an expert? Schedule a call with our team to get the conversation started.

No comments

Leave a Reply

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