In oracle, ORA-29273: HTTP request failed ORA-29024: Certificate validation failure

50 Views Asked by At

My plsql for accessing intranet site

DECLARE
  l_url            VARCHAR2(50) := 'https://www.domainname.net';
  l_http_request   UTL_HTTP.req;
  l_http_response  UTL_HTTP.resp;
BEGIN
  -- Make a HTTP request and get the response.
  utl_http.set_wallet('file:WALLETPATH', pass);
  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;

receiving below error

ERROR at line 1: 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 ORA-06512: at line 9

/sys/acls/domainname-net-permissions.xml www.domainname.net GRANTED

please help in clearing the error

Wallet already created and it is displaying correctly using orapki wallet display -wallet command. Still receives certificate validation failure. But in browser the domain is able to access in the server. Only from oracle it is receiving this error

0

There are 0 best solutions below