Accessing Web Requests UTL_HTTP: ORA-12543: TNS:destination Host Unreachable (Doc ID 2145116.1)

Last updated on SEPTEMBER 18, 2016

Applies to:

Oracle Net Services - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

Unable to access website using UTL_HTTP.  The following errors are returned:

select utl_http.request('http://www.target.gov') from dual;
select utl_http.request('http://www.target.gov) from dual
*
ERROR at line 1:
ORA-29273: HTTP request failed
ORA-12543: TNS:destination host unreachable

ORA-06512: at "SYS.UTL_HTTP", line 1491
ORA-06512: at line 1

 

Focus on : ORA-12543: TNS:destination host unreachable

 


*** MODULE NAME:(sqlplus@oracle1.com (TNS V1-V3)) 2016-05-31 14:54:28.459

kgasct_connect_tcp: connecting NS (ADDRESS=(PROTOCOL=tcp)(HOST=2a01:358:401d:200::b)(PORT=80))
kgasct_connect_tcp: nscall failed 12543

IP address connection for the host : HOST=2a01:358:401d:200::b is failing

kgasct_connect_tcp: connecting NS (ADDRESS=(PROTOCOL=tcp)(HOST=2a01:358:401d:200::b)(PORT=80))
kgasct_connect_tcp: nscall failed 12543

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms