1 Reply Latest reply on Sep 13, 2013 5:49 AM by Billy~Verreynne

    Unable to establish a SSL connection using UTL_HTTP

    rchaparr-Oracle

      Hi,

       

      I am unable to establish a SSL connection using UTL_HTTP.

       

      The certificate is imported in Oracle Wallet.

       

      I am using:

      utl_http.set_proxy

      utl_http.set_wallet

      utl_http.begin_request

       

      I get the error:

      ORA-29273: HTTP request failed

      ORA-06512: at "SYS.UTL_HTTP", line 1130

      ORA-29259: end-of-input reached

      ORA-06512: at line 6

      29273. 00000 - "HTTP request failed"

      *Cause: The UTL_HTTP package failed to execute the HTTP request.

      *Action: Use get_detailed_sqlerrm to check the detailed error message.

      Fix the error and retry the HTTP request.

       

      If I don't use the set_wallet, I get an "ORA-29024: Certificate validation failure", so I guess that the connection and certificate is ok?

       

      How can I debug this?

       

      Thanks.

        • 1. Re: Unable to establish a SSL connection using UTL_HTTP
          Billy~Verreynne

          I've seen this error before when the SSL handshaking fails.

           

          Can you turn on logging on the https server to trace the incoming https call from your PL/SQL code?

           

          If not (e.g. https server is a 3rd party), then I suggest running a browser (Firefox or Chrome) on the Oracle db server, setting its wallet to match the exact contents (and nothing more) of your Oracle wallet, enable http header tracing, and make the https call via the browser.