6 Replies Latest reply: Jan 3, 2007 10:47 AM by Murali2 RSS

    Portal access - Loadbalancer problem

    459644
      Problem on Oracle 10g Portal With Load Balance

      I have installed Oracle 10g Portal as below

      Bl1 => middle tier 1 (Portal & wireless)
      Bl2 => middle tier 2 (Portal & wireless)
      Oracle10g-srv => infrastructure (Metadata Repository & OID)

      and all machine can work properly.

      But after i use Load Balance "F5" to share load between Bl1 and Bl2
      by follow the instruction in "Oracle Application Server Portal configuration Guide 10g Release2" documentation

      Computer Details

      LBR host name = ecommerce.nationgroup.com
      IP Address: 203.154.97.16
      Listen Port = 80
      Invalidation Port = 9401

      BL1 (M1) hostname = bl1
      IP = 203.154.97.20
      Oracle HTTP Server Listening Port: 7778
      OracleAS Web Cache Listening Port: 7777
      OracleAS Web Cache Invalidation Port:9401
      OracleAS Web Cache Administration Port:9400


      Test result as below :
      • http://ecommerce.nationgroup.com /index.html => OK
      • http://ecommerce.nationgroup.com/pls/portal/htp.p?cbuf=test => OK
      • http://ecommerce.nationgroup.com/pls/portal => HTTP 500 -
      Internal server error


      and error in log file "$ORACLE_HOME/j2ee/OC4J_Portal/application-
      deployments/portal/OC4J_Portal_default_island_1/application.log" show these messages :

      06/12/18 17:28:40 portal: id=90662430803,1 Stall Timeout reached. Interrupting Fetcher name=content-fetcher4 label=pageMeta url=http://tango.mcdonalds.com.ar:7783/pls/portal/!PORTAL.wwpob_page.show?_pageid=6,1,6_13 time=61929ms timeout=61000ms process=GotResponse
      06/12/18 17:28:40 portal: id=90662430803,1 Connection Timeout reached. Timing out Fetcher: java.io.InterruptedIOException: Operation interrupted name=content-fetcher4 label=pageMeta url=http://tango.mcdonalds.com.ar:7783/pls/portal/!PORTAL.wwpob_page.show?_pageid=6,1,6_13 time=61930ms timeout=60000ms process=GotResponse
      06/12/18 17:28:40 portal: FetchGroup caught uncaughtException=java.lang.NullPointerException in thread name=content-fetcher4, starting a new fetcher. 27 total threads in this group. Parent Groups : ApplicationServerThreadGroup=45, main=57, system=63, end.

      Any idea?
      Thanks.
      Fernando.
        • 1. Re: Portal access - Loadbalancer problem
          Erik Janssen-Oracle
          The message 'Stall Timeout reached' indicates that the parallel page engine (PPE) is unable to retrieve the page metadata. The PPE acts as client requesting information through HTTP. Therefore your middle tier needs to be able to resolve the address of the load balancer.

          Does the host name in the portal URL resolve to the load balancer on your middle tiers and can you reach the load balancer at the port specified in the URL from the middle tiers ?
          • 2. Re: Portal access - Loadbalancer problem
            459644
            The middle tiers resolve de load balancer. By example Discoverer or Form on the same middle tier run OK. I have problem with portal only.

            Thanks.
            • 3. Re: Portal access - Loadbalancer problem
              Erik Janssen-Oracle
              What about the database server ?

              Are you able to issue a request to the load balancer when connected to the database with SQL*PLUS ?

              SQL> select utl_http.request('http://www.acme.com') from dual ;

              (replace www.acme.com with the proper url.
              • 4. Re: Portal access - Loadbalancer problem
                459644
                I couldn't. I get

                ORA-29273: HTTP request failed
                ORA-06512: at "SYS.UTL_HTTP", line 1577
                ORA-12535: TNS:operation timed out
                ORA-06512: at line 1

                I have to enable infra structure server access to the content switch?
                • 5. Re: Portal access - Loadbalancer problem
                  Erik Janssen-Oracle
                  There's the bugger :-)

                  The metadata indeed needs to be able to call the load balancer URL.

                  I'm also still puzzled about the following update in this post :

                  <quote>The middle tiers resolve de load balancer. By example Discoverer or Form on the same middle tier run OK. I have problem with portal only</quote>

                  Are you able to call the load balancer URL on each midtier ? You can test this with command line HTTP utilities such as wget or simply telnet to the http/https port.
                  • 6. Re: Portal access - Loadbalancer problem
                    Murali2
                    after looking at this, i think you just cant load balance from a load balancer to any of the Portal Middle Tiers similar to Oracle Apps. Portal requires lot more wiring than load balancing.

                    Have you rewired your portal instance with your load balancer??

                    Refer this Section
                    http://download-west.oracle.com/docs/cd/B14099_19/core.1012/b13998/portal.htm#CACBDJBC