Oracle Database 12c Enterprise Edition Release 12.1.0.1.0
I need to access the following web page:
https://requestb.in/1l4rj7c1?oldk=fffff
So far, was able to create an ACL to allow the UTL_HTTP page to access that particular site. Since it is an HTTPs web address, I'm getting this error when trying to do the following test:
declare
-- Local variables here
i VARCHAR(2000);
begin
-- Test statements here
i := UTL_HTTP.REQUEST ('https://requestb.in/1l4rj7c1?oldk=fffff');
--
dbms_output.put_line (i);
end;
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1720
ORA-28860: Fatal SSL error
ORA-06512: at line 7
I tried creating a wallet and importing the certificate, but it keeps failing:
orapki wallet create -wallet C:\Certificados -pwd WalletPasswd123 -auto_login
Ends OK. Then:
orapki wallet display -wallet C:\Certificados
Oracle PKI Tool: Versi¾n 12.1.0.2
Copyright (c) 2004, 2014, Oracle y/o sus subsidiarias. Todos los Derechos Reservados.
Requested Certificates:
User Certificates:
Trusted Certificates:
Subject: OU=Class 2 Public Primary Certification Authority,O=VeriSign\, Inc.,C=US
Subject: OU=Class 3 Public Primary Certification Authority,O=VeriSign\, Inc.,C=US
Subject: CN=GTE CyberTrust Global Root,OU=GTE CyberTrust Solutions\, Inc.,O=GTE Corporation,C=US
Subject: OU=Class 1 Public Primary Certification Authority,O=VeriSign\, Inc.,C=US
Then:
orapki wallet add -wallet C:\Certificados -trusted_cert -cert "C:\Temp\COMODOECCCertificationAuthority.crt" -pwd WalletPasswd123
Oracle PKI Tool: Versi¾n 12.1.0.2
Copyright (c) 2004, 2014, Oracle y/o sus subsidiarias. Todos los Derechos Reservados.
Could not install trusted cert atC:\Temp\COMODOECCCertificationAuthority.crt
PKI-04001: Certificado no vßlido.
Any hints?
Note: The first time I run the test, the error was related to the wallet, I did the steps showed above and after that I did not get the wallet error but the one that is showed.
I tried to follow instructions shown here:
https://oracle-base.com/articles/misc/utl_http-and-ssl