{"id":2403,"date":"2011-04-21T05:01:01","date_gmt":"2011-04-21T09:01:01","guid":{"rendered":"http:\/\/onlineappsdba.com\/index.php\/2011\/04\/21\/how-to-configure-load-balancer-in-oracle-e-business-suite-r12\/"},"modified":"2016-04-14T10:34:51","modified_gmt":"2016-04-14T14:34:51","slug":"how-to-configure-load-balancer-in-oracle-e-business-suite-r12","status":"publish","type":"post","link":"https:\/\/onlineappsdba.com\/index.php\/2011\/04\/21\/how-to-configure-load-balancer-in-oracle-e-business-suite-r12\/","title":{"rendered":"How to configure Load Balancer in Oracle E-Business Suite R12"},"content":{"rendered":"

\"\"<\/a><\/p>\n

This post covers steps to configure Load Balancer <\/strong>(with assumptions mentioned below) with Oracle E-Buisness Suite\u00a0R12 . For overview and various options for High Availability (at application tier level) follow Metalink (Oracle My Support) note 380489.1<\/strong>Using Load-Balancers with Oracle E-Business Suite Release 12<\/p>\n

.<\/p>\n

Assumptions
\n<\/u><\/strong>Configuration steps mentioned in this post are based on following assumptions<\/span><\/p>\n

1.<\/strong>E-Business Suite (Apps)\u00a0is installed and accessible using at least one apps server\u00a0via web server port (assume port pool 0 i.e. 8000) i.e.\u00a0 http:\/\/ebsapp01.domain.com:8000<\/p>\n

2. There is hardware load balancer available with port translation (8000 to 80) – (Optional and required only if you want port translation or URL on non default port<\/span>)<\/p>\n

Note: If your load balancer does not have port translation feature and you would like to use standard HTTP(s) port i.e. 80 or 443 then additional steps are required to reconfigure EBS on 80\/443<\/span><\/p>\n

3. If you want URL to be SSL\/HTTPS (port 443) then Load Balancer should have capability to SSL encryption\/decryption<\/a>\u00a0(In this case SSL will terminate at Load Balancer and from Load Balancer to Web\/Apps Tier configure is HTTP)<\/p>\n

Note: If you want SSL to be configured all the way till Web\/Apps Tier then additional steps are required to re-configure EBS on 443<\/span><\/p>\n

4. EBS R12 supports multiple URLs pointing to same application. (For this setup you need minimum 2 apps tier + additional profile option configuration<\/span>)<\/p>\n

Follow section 2.2 Using Hardware Load Balancer with Multiple Web Entry Points of Note # 380489.1<\/p>\n

5. Session Persistence<\/a>\u00a0is configured at Load Balancer (Mandatory if you have multiple middle\/apps tier<\/span>)<\/p>\n

Configuration below are based on following setup (change\u00a0values where required)<\/span><\/strong><\/p>\n

1.<\/strong> There are two application tier (appserver1.localdomain.com and appserver2.localdomain.com) with web port as 8000<\/p>\n

2.<\/strong> Load Balancer URL after setup is mylbr.lbrdomain.com (listening on port 80)<\/p>\n

3.<\/strong> Load Balancer is configured with entry mylbr.lbrdomain.com:80 forwarding request to appserver1.localdomain.com:8000 & appserver2.localdomain.com:8000 (with session stickiness)<\/p>\n

.<\/p>\n

Step to follow to re-configure Oracle Apps to use Load Balancer<\/u><\/strong><\/p>\n

1. Update following five values in Context File ($CONTEXT_FILE)\u00a0 (Context file is at $INST_TOP\/appl\/admin<\/span>) of application tier. To know more about INST_TOP and CONTEXT_FILE click here<\/a>\u00a0 and \u00a0here<\/a><\/p>\n

a) s_webentryhost<\/strong> – To load balancer\u00a0 URL i.e. mylbr (Do not enter full name with domain<\/span>)
\nb) s_active_webport<\/strong> -to load balancer port i.e.\u00a080 (For SSL use\u00a0443)
\nc) s_login_page<\/strong> – Full URL pointing to Load Balancer\u00a0http:\/\/loadbalancer.domain:port\/OA_HTML\/AppsLogin\u00a0i.e. http:\/\/mylbr.lbrdomain.com:80\/OA_HTML\/AppsLogin (For SSL use https and port as 443<\/span>)
\nd) s_external_url<\/strong> – Load Balancer URL\u00a0http:\/\/loadbalancer.domain:port\u00a0 i.e. http:\/\/mylbr.lbrdomain.com:80\u00a0(For SSL use https and port as 443<\/span>)
\ne) s_webentryurlprotocol<\/strong> – http\u00a0 (Change to https if using SSL<\/span>)
\nf) s_webentrydomain<\/strong> – Load Balancer Domain i.e. lbrdomain.com<\/p>\n

2. Run Autoconfig<\/strong> on application tier<\/p>\n

3. Repeat step 1 & 2 on all nodes running Web Server. (To check which servers are running as Web Nodes, login\u00a0to database as user\u00a0apps and run query “select node_name from fnd_nodes where SUPPORT_WEB=’Y’;”)<\/p>\n

4. Test load balancer configuration by accessing load balancer URL i.e. http:\/\/mylbr.lbrdomain.com<\/strong><\/p>\n

5. If you get page not found error then check if request is coming from load balancer to Web Server access logs<\/strong> at $LOG_HOME\/ ora\/10.1.3\/ access_log.NNNNNNNN (sort access log based on time stamp “ls -ltr access_log*”)<\/p>\n

.<\/p>\n

Reference<\/u><\/strong><\/p>\n