UTL_HTTP Without Using Certificate

Today I was checking a certeficate against a web service. I use the next query below for this kind of task but I get a problem with the certificate,
It give me a validation failure;

 
SQL> select utl_http.request ('https://clients.tecno.com', Null, 'file:/DB/PROD/UTIL/CERTIFICATES_TLS/','XXXXXX') from dual;
select utl_http.request ('https://clients.tecno.com', Null, 'file:/DB/PROD/UTIL/CERTIFICATES_TLS/','XXXXXX') from dual
       *
ERROR at line 1:
ORA-29273: HTTP request failed
ORA-29024: Certificate validation failure
ORA-06512: at "SYS.UTL_HTTP", line 1491
ORA-06512: at line 1

I probed to remove the “s” from “https” string for testing only (As a silly test to see what happened), I never think it works with out “s” but yes it works fine without use certificate.
I don’t know if in this case Oracle read the certificate because of it don’t need.

 
SQL> select utl_http.request ('http://clients.tecno.com', Null, 'file:/DB/PROD/UTIL/CERTIFICATES_TLS/','XXXXXX') from dual;

UTL_HTTP.REQUEST('HTTP://clients.tecno.com',NULL,'FILE:/DB/PROD/UTIL/CERTIFICATES_TLS/','XXXXXX')
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
<html><head><title>Error</title></head><body><head><title>Directory Listing Denied</title></head>
<body><h1>Directory Listing Denied</h1>This Virtual Directory does not allow contents to be listed.</body></body></html>

HTH – Antonio NAVARRO

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s