8 Replies Latest reply: Apr 18, 2012 1:36 AM by Billy~Verreynne RSS

    UTL_HTTP.request  Eroor

    931186
      Problem Description: When i run this script
      SELECT UTL_HTTP.request ('www.oracle.com') FROM dual ;
      before , i was receive this error sometimes and sometimes work
      ORA-12535: TNS:operation timed out
      ORA-06512: at "SYS.UTL_HTTP", line 1575
      after i add the proxy
      SELECT UTL_HTTP.request ('www.oracle.com','192.168.0.20') FROM dual ;
      now , i receive this error
      ORA-29270: too many open HTTP requests
      ORA-06512: at "SYS.UTL_HTTP", line 1575
        • 1. Re: UTL_HTTP.request  Eroor
          Fran
          welcome to OTN, here we have a lot of post about this issue, please check a bit.

          On that server, test the network connectivity to the web server, and please show the result

          HTH
          • 2. Re: UTL_HTTP.request  Eroor
            931186
            Thanks Fran

            i search here but i didn't found this error related to UTL_HTTP.request .
            i found only UTL_HTTP.BEGIN_REQUEST not UTL_HTTP.request
            and network connectivity to the web server is good .

            and after i add the getway to the request like that
            SELECT UTL_HTTP.request ('www.oracle.com','192.168.0.20') FROM dual ;
            it's work at the first .
            but after i run this script more than once this error appear to me
            ORA-29270: too many open HTTP requests
            ORA-06512: at "SYS.UTL_HTTP", line 1575
            • 3. Re: UTL_HTTP.request  Eroor
              Aman....
              Did you see this thread?
              Closing HTTP requests

              Aman....
              • 4. Re: UTL_HTTP.request  Eroor
                Fran
                you must have a limit of http request or (Probably) is a bug, please open a SR in oracle support.

                I don't know if exists a query to kill all the http_requests without bouncing the DB
                • 5. Re: UTL_HTTP.request  Eroor
                  931186
                  Thanks Aman for your replay but this topics is taking about utl_http.get_response belong to UTL_HTTP.BEGIN_REQUEST and the solution to end all open request is UTL_HTTP.END_RESPONSE or UTL_HTTP.END_REQUEST;.
                  but my problem is with UTL_HTTP.request
                  Dear Fran ,

                  yes,i want something to end the open request .
                  i'm using oracle Ebs R 12.1.3
                  • 6. Re: UTL_HTTP.request  Eroor
                    Fran
                    if you can bounce database, if not open a Service Request in metalink (support oracle)

                    HTH
                    • 7. Re: UTL_HTTP.request  Eroor
                      Aman....
                      928183 wrote:
                      Thanks Aman for your replay but this topics is taking about utl_http.get_response belong to UTL_HTTP.BEGIN_REQUEST and the solution to end all open request is UTL_HTTP.END_RESPONSE or UTL_HTTP.END_REQUEST;.
                      but my problem is with UTL_HTTP.request
                      Dear Fran ,

                      yes,i want something to end the open request .
                      i'm using oracle Ebs R 12.1.3
                      No, the given thread had the same issue and the solution implemented was to bounce the db. That's the same what Fran has advised you also so either you do that or contact Support.

                      Aman....
                      • 8. Re: UTL_HTTP.request  Eroor
                        Billy~Verreynne
                        Fran wrote:
                        you must have a limit of http request or (Probably) is a bug, please open a SR in oracle support.
                        Come on! Jeez.. you are quick to blame this on a bug.

                        This is a coding error. There is a limit on the number of TCP sockets an Oracle process can create. If your code opens a socket, raises an error, and the code does not close that socket, the code is resource sieve leaking socket handles.

                        And yes - it will run into an error as the system will refuse to open more sockets for that process and that code. With reason too as the code pretty much sucks when it comes to proper exception handling and resource protection.
                        I don't know if exists a query to kill all the http_requests without bouncing the DB
                        No query. No need to bounce the database. Simply tell the session to close all open TCP sockets created by the code. Call +UTL_TCP.Close_All_Connections()+.