Friday, January 22, 2016

utl_http.request ORA-12541 TNSno listener

select utl_http.request('http://172.168.1.7') from dual;


ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1722
ORA-12541: TNS:no listener
ORA-06512: at line 1
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.



select utl_http.request('http://172.168.1.7:91') from dual;

No comments:

Post a Comment

Followers