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

Last updated on JULY 24, 2017

Applies to:

Advanced Networking Option - Version 11.2.0.4 and later
Information in this document applies to any platform.

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.



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms