DECLARE
  l_url            VARCHAR2(50) := '[url]http://192.168.201.233:80[/url]';
  l_http_request   UTL_HTTP.req;
  l_http_response  UTL_HTTP.resp;
BEGIN
  -- Make a HTTP request and get the response.
  l_http_request  := UTL_HTTP.begin_request(l_url);
  l_http_response := UTL_HTTP.get_response(l_http_request);
  UTL_HTTP.end_response(l_http_response);
END;
/

DECLARE
*
ERROR at line 1:
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1130
ORA-12541: TNS:no listener
ORA-06512: at line 7

lsnrctl status 

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 22-FEB-2015 21:19:12

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.201.233)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date                22-FEB-2015 20:32:26
Uptime                    0 days 0 hr. 46 min. 45 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/snode/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.201.233)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "ec" has 1 instance(s).
  Instance "ec", status READY, has 1 handler(s) for this service...
Service "ecXDB" has 1 instance(s).
  Instance "ec", status READY, has 1 handler(s) for this service...
Service "sprod_DGMGRL" has 1 instance(s).
  Instance "sprod", status UNKNOWN, has 1 handler(s) for this service...
Service "test" has 1 instance(s).
  Instance "test", status READY, has 1 handler(s) for this service...
Service "testXDB" has 1 instance(s).
  Instance "test", status READY, has 1 handler(s) for this service...
The command completed successfully

orclz>
orclz> DECLARE
  2  l_url VARCHAR2(50) := 'http://www.oracle.com';
  3  l_http_request UTL_HTTP.req;
  4  l_http_response UTL_HTTP.resp;
  5  BEGIN
  6  -- Make a HTTP request and get the response.
  7  l_http_request := UTL_HTTP.begin_request(l_url);
  8  l_http_response := UTL_HTTP.get_response(l_http_request);
  9  UTL_HTTP.end_response(l_http_response);
 10  END;
 11  /

PL/SQL procedure successfully completed.

orclz>

  1  DECLARE
  2      l_url           VARCHAR2(50) := 'http://localhost:80';
  3      l_http_request  utl_http.req;
  4      l_http_response utl_http.resp;
  5  BEGIN
  6      -- Make a HTTP request and get the response.
  7      l_http_request := utl_http.Begin_request(l_url);
  8      l_http_response := utl_http.Get_response(l_http_request);
  9      utl_http.End_response(l_http_response);
 10* END;
SQL> /

PL/SQL procedure successfully completed.

SQL> 

SQL> DECLARE
  2    l_url            VARCHAR2(50) := 'http://www.google.com:80';
  3    l_http_request   UTL_HTTP.req;
  4    l_http_response  UTL_HTTP.resp;
  5  BEGIN
  6    -- Make a HTTP request and get the response.
  7    l_http_request  := UTL_HTTP.begin_request(l_url);
  8    l_http_response := UTL_HTTP.get_response(l_http_request);
  9    UTL_HTTP.end_response(l_http_response);
 10  END;
 11  /

PL/SQL procedure successfully completed.