UTL_HTTP Call Fails With Error 'ORA-29024: Certificate Validation Failure' After Applying MES Patch (Doc ID 2287905.1)

Last updated on AUGUST 17, 2022

Applies to:

Symptoms

DB: 11.2.0.4

MES patch 24975421 was applied in 11.2.0.4 DB to have the database support TLS1.2 communication with an external web service. The patch was applied and communication with that web service is functional, however previously existing web service calls to an internal SOAP based application thru UTL_HTTP no longer functions. It returns the errors:

select UTL_HTTP.request('<https URL>','<proxy server>:<port>','file:<wallet location>','<wallet password>') from dual;
ORA-29273: HTTP request failed ORA-06512: at "SYS.UTL_HTTP", line 1130 ORA-29024: Certificate validation failure.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.