|UTL_HTTP and SSL (HTTPS) using Oracle Wallets - This article describes how to use the UTL_HTTP package to interact with resources secured by SSL (HTTPS).|
Tony Reed said...Hi,
the example will not work on Oracle 12.1
According to Oracle Support only the certificate chain should be imported, not the end site certificate.
I.e. In the example you use, only import these:
Builtin Object Token:GTE CyberTrust Global Root
Akamai Subordinate CA
If the third certificate, *.redhat.com, is imported utl_http throws a Certificate validation failure at you.
Yes. I just did a run through to check and I get the same issue as you. I will amend the article to make sure this is clear.
It works fine with just the chain, not the end entry on 11.2 and 12.1.
Steve said...when executing:
SET SERVEROUTPUT ON
EXEC UTL_HTTP.set_wallet('file:/wallet2', 'xxxxxxxxx');
I get ORA-28759: failure to open file.
Either you've done the setup incorrectly, or the DB server doesn't have access to the internet.
Difficult to know with the lack of information presented. If you want me to help, please post a question in the forum on this site.