Skip to Main Content

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle database 18 XE and https

Marko MatanovicApr 17 2020 — edited Apr 19 2020

Hi.

I have installed Oracle database 18 XE and currently trying to make http call to secured site.

declare

l_req      utl_http.req;

begin

utl_http.set_wallet('file:D:\app\korisnik\wallet2', 'welcome123');

l_req := utl_http.begin_request('https://google.com', 'GET', 'HTTP/1.1');

end;

I have configured wallet and ACL. This call works fine on 12.2. Standard edition. But on 18c I'm constantly getting

ORA-29273: HTTP request failed

ORA-29024: Certificate validation failure

ORA-06512: at "SYS.UTL_HTTP", line 380

ORA-06512: at "SYS.UTL_HTTP", line 1148

I have imported all root CA certificates. This call works fine on 12.2. SE with same certificates, but not working on 18 XE.

Has anyone suceeded to call https on 18 XE?

Regards,

Marko

Comments
Post Details
Added on Apr 17 2020
4 comments
1,807 views