7 Replies Latest reply: Aug 4, 2013 11:04 AM by Hussein Sawwan-Oracle RSS

    Issue with Load balancing for 2 Apps Node for EBS 12.1

    Hungry DBA

      Hi Guys,

       

      I had been following section 2.4 of Using Load-Balancers with Oracle E-Business Suite Release 12 (Doc ID 380489.1).

       

      As per doc, I should be able to (but which is not happening in my case)

       

      [root@ebs1 etc]# nslookup ebslbr.oracle.com

      Server:         172.18.0.99

      Address:        172.18.0.99#53

       

      Name:   ebslbr.oracle.com

      Address: 172.18.0.102

      Name:   ebslbr.oracle.com

      Address: 172.18.0.101

       

      [root@ebs1 etc]# telnet ebslbr.oracle.com

      Trying 172.18.0.101...

      telnet: connect to address 172.18.0.101: Connection refused

      Trying 172.18.0.102...

      telnet: connect to address 172.18.0.102: Connection refused

      telnet: Unable to connect to remote host: Connection refused

      [root@ebs1 etc]#

       

       

      I could able to lookup individual servers as well.

       

      [root@ebs1 etc]# nslookup ebs1

      Server:         172.18.0.99

      Address:        172.18.0.99#53

       

      Name:   ebs1.oracle.com

      Address: 172.18.0.101

       

      [root@ebs1 etc]# nslookup ebs2

      Server:         172.18.0.99

      Address:        172.18.0.99#53

       

       

      Name:   ebs2.oracle.com

      Address: 172.18.0.102

       

      [root@ebs1 etc]# cat /etc/hosts

      # Do not remove the following line, or various programs

      # that require network functionality will fail.

      127.0.0.1       localhost.localdomain   localhost

      #:1             localhost6.localdomain6 localhost6

      #172.18.0.101    ebs1.oracle.com        ebs1

      #172.18.0.102     ebs2.oracle.com        ebs2

      #172.18.0.111    db1.oracle.com         db1

      [root@ebs1 etc]# ping ebs2

      PING ebs2.oracle.com (172.18.0.102) 56(84) bytes of data.

      64 bytes from ebslbr (172.18.0.102): icmp_seq=1 ttl=64 time=0.482 ms

      64 bytes from ebslbr (172.18.0.102): icmp_seq=2 ttl=64 time=0.546 ms

       

      --- ebs2.oracle.com ping statistics ---

      2 packets transmitted, 2 received, 0% packet loss, time 999ms

      rtt min/avg/max/mdev = 0.482/0.514/0.546/0.032 ms

       

      [root@ebs1 etc]# ping ebs1

      PING ebs1.oracle.com (172.18.0.101) 56(84) bytes of data.

      64 bytes from ebs1 (172.18.0.101): icmp_seq=1 ttl=64 time=0.032 ms

      64 bytes from ebs1 (172.18.0.101): icmp_seq=2 ttl=64 time=0.044 ms

      64 bytes from ebs1 (172.18.0.101): icmp_seq=3 ttl=64 time=0.041 ms

       

       

      [root@ebs1 etc]#

      [root@ebs1 etc]# telnet 127.0.0.1

      Trying 127.0.0.1...

      telnet: connect to address 127.0.0.1: Connection refused

      telnet: Unable to connect to remote host: Connection refused

      [root@ebs1 etc]# service iptables status

      Firewall is stopped.

      [root@ebs1 etc]#

       

      I've further went, made changes in context file...ran autoconfig...but not getting frontend with 'ebslbr' hostname.

       

      Can you please assist what could be the issue ?

       

       

      Thanks,

        • 1. Re: Issue with Load balancing for 2 Apps Node for EBS 12.1
          Hussein Sawwan-Oracle

          Trying 172.18.0.101...

          telnet: connect to address 172.18.0.101: Connection refused

          Trying 172.18.0.102...

          telnet: connect to address 172.18.0.102: Connection refused


          This is not an EBS issue and it's more a telnet/connectivity issue that you need to resolve -- http://bit.ly/14m4Mxi


          Thanks,

          Hussein

          • 2. Re: Issue with Load balancing for 2 Apps Node for EBS 12.1
            Hungry DBA

            Hi Hussein,

             

            I've checked it... but  there is a confusion... is telnet work without any port no ?

             

            I mean see below output,

             

            [applmgr@ebs1 ~]$ telnet ebs1 8000

            Trying 172.18.0.101...

            Connected to ebs1.

            Escape character is '^]'.

             

            Connection closed by foreign host.

            [applmgr@ebs1 ~]$ telnet ebs2 8000

            Trying 172.18.0.102...

            Connected to ebs2.

            Escape character is '^]'.

             

            Connection closed by foreign host.

            [applmgr@ebs1 ~]$ telnet ebs2

            Trying 172.18.0.102...

            telnet: connect to address 172.18.0.102: Connection refused

             

            [applmgr@ebs1 ~]$ telnet ebslbr

            Trying 172.18.0.101...

            telnet: connect to address 172.18.0.101: Connection refused

            Trying 172.18.0.102...

            telnet: connect to address 172.18.0.102: Connection refused

             

            [applmgr@ebs1 ~]$ telnet ebslbr 8000

            Trying 172.18.0.101...

            Connected to ebslbr.

            Escape character is '^]'.

             

            As per Metalink DOC: 380489.1, my Context file entries for both nodes,

             

            [applmgr@ebs1 ~]$ grep -i s_webentryurlprotocol $CONTEXT_FILE

                     <webentryurlprotocol oa_var="s_webentryurlprotocol">http</webentryurlprotocol>

            [applmgr@ebs1 ~]$ grep -i s_webentryhost $CONTEXT_FILE

                     <webentryhost oa_var="s_webentryhost">ebslbr</webentryhost>

            [applmgr@ebs1 ~]$ grep -i s_webentrydomain $CONTEXT_FILE

                     <webentrydomain oa_var="s_webentrydomain">oracle.com</webentrydomain>

            [applmgr@ebs1 ~]$ grep -i s_webentrydomain $CONTEXT_FILE

                     <webentrydomain oa_var="s_webentrydomain">oracle.com</webentrydomain>

            [applmgr@ebs1 ~]$ grep -i s_active_webport $CONTEXT_FILE

                  <activewebport oa_var="s_active_webport" oa_type="DUP_PORT" base="8000" step="1" range="-1" label="Active Web Port">8000</activewebport>

            [applmgr@ebs1 ~]$ grep -i s_login_page $CONTEXT_FILE

                     <login_page oa_var="s_login_page">http://ebslbr.oracle.com/OA_HTML/AppsLogin</login_page>

            [applmgr@ebs1 ~]$ grep -i s_external_url $CONTEXT_FILE

                     <externURL oa_var="s_external_url">http://ebslbr.oracle.com</externURL>

             

             

            After running autoconfig, I still get frontpage for http://ebs1.oracle.com:8000/OA_HTML/AppsLogin & http://ebs2.oracle.com:8000/OA_HTML/AppsLogin  which eventually redirects to http://ebslbr.oracle.com:8000/OA_HTML/RF.jsp?function_id=28716&resp_id=-1&resp_appl_id=-1&security_group_id=0&lang_code=… but which is wrong (there is no load balancing at all)...as my local desktop system32\drivers\etc\hosts file have following entries,


             

            172.18.0.101    ebs1.oracle.com ebslbr.oracle.com    ebslbr
            172.18.0.102    ebs2.oracle.com ebslbr.oracle.com    ebslbr

             

            so,

             

            ebs1.oracle.com:8000 -> ebslbr.oracle.com:8000 (It will always go to 1st node only)

             

             

            This can be also proved  by,

             

            [applmgr@ebs1 ~]$ telnet ebslbr.oracle.com 8000 (telnet to ebslbr always going to 1st node on ebs1)

            Trying 172.18.0.101...

            Connected to ebslbr.oracle.com.

            Escape character is '^]'.

             

            [applmgr@ebs2 scripts]$ telnet ebslbr.oracle.com 8000 (telnet to ebslbr always going to 2nd node on ebs2)

            Trying 172.18.0.102...

            Connected to ebslbr.oracle.com.

            Escape character is '^]'.

             

            This should be round robin fashion...

             

            Can you please help me, what is going wrong here ?

             

            your help would be much appreciated ...

             

            Regards,

            Manish

            • 3. Re: Issue with Load balancing for 2 Apps Node for EBS 12.1
              Hussein Sawwan-Oracle

              Manish,

               

              IINM, the default port number is 23 so try to telnet using this port. If you get the same error then you need to have this port open.

               

              Thanks,

              Hussein

              • 4. Re: Issue with Load balancing for 2 Apps Node for EBS 12.1
                Hungry DBA

                Thanks Hussein, Issue is resolved now, it was due to port 80 (for which I followed How To Configure Apache In R12 (10.1.3) To Listen on a Restricted Port Such as 80 or 443 (Doc ID 578001.1) which is mentioned by you only some other post)


                But by default, whenever I hit ebslbr.oracle.com application URL, it's always going on 2nd node (ebs2). and if I stop apache on 2nd (ebs2) node then only it goes to 1st node (ebs1). so my question to you is whether DNS Server of Windows really provides Load Balancing or we need something else to be configured as to distribute the load between to application server.



                Thanks,

                Manish

                • 5. Re: Issue with Load balancing for 2 Apps Node for EBS 12.1
                  Hungry DBA

                  Hi Hussein / Others

                   

                  does DNS Server of Windows provides Load Balancing & other feature like port translation / forwarding because I could see option of Round robin but it seems not working in my case. is there any other configuration needs to be done at DNS ?


                  Please reply, thanks....

                  • 6. Re: Issue with Load balancing for 2 Apps Node for EBS 12.1
                    Srini Chavali-Oracle

                    You will have to check with Microsoft on the capabilities of Win DNS. One of the requirements for EBS load balancing is session persistence - see MOS Doc 601694.1

                     

                    HTH
                    Srini

                    • 7. Re: Issue with Load balancing for 2 Apps Node for EBS 12.1
                      Hussein Sawwan-Oracle

                      HungryDBA wrote:

                       

                      Hi Hussein / Others

                       

                      does DNS Server of Windows provides Load Balancing & other feature like port translation / forwarding because I could see option of Round robin but it seems not working in my case. is there any other configuration needs to be done at DNS ?


                      Please reply, thanks....

                       

                      Yes, it should.

                       

                      http://technet.microsoft.com/en-us/library/cc787484(v=ws.10).aspx

                      http://technet.microsoft.com/en-us/library/gg398251.aspx

                       

                      Formslauncher.Class Not Found When Failing Over Using DNS Round Robin Load Balancing (Doc ID 604040.1)

                      E-Business Suite Users Experience Intermittent HTTP-500 Errors and Database Connection Errors (Doc ID 1314433.1)

                      11i/R12 How to Debug "Transaction Context Is Lost" or "You are trying to access a page that is no longer active" (Doc ID 456906.1)

                       

                      Thanks,

                      Hussein