Forum Stats

  • 3,784,402 Users
  • 2,254,933 Discussions
  • 7,880,805 Comments

Discussions

https and Oracle database 18 xe

Hello

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?

Thank you