I'm testing UTL_HTTP and SSL, so the following are the steps taken as per (https://oracle-base.com/articles/misc/utl_http-and-ssl):
Grant access to user DEMO on URL (www.redhat.com):
BEGIN
DBMS_NETWORK_ACL_ADMIN.append_host_ace (
host => 'www.redhat.com',
lower_port => 443,
upper_port => 443,
ace => xs$ace_type(privilege_list => xs$name_list('http'),
principal_name => 'demo',
principal_type => xs_acl.ptype_db));
END;
Download certificate for (www.redhat.com):
Redhat.txt (1.3 KB)
Create an Oracle wallet and add certificate using OWM:
Call the URL using UTL_HTTP:
DECLARE
l_url VARCHAR2(50) := 'https://www.redhat.com/';
l_http_request UTL_HTTP.req;
l_http_response UTL_HTTP.resp;
BEGIN
UTL_HTTP.set_wallet('file:/u01/app/oracle/product/version/db_1/owm/wallets/oracle',
'WalletPasswd123');
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;
I get error (ORA-29024: Certificate validation failure). What else is missing?