My Oracle Support Banner

ORA-29024: Certificate Validation Failure (Doc ID 3027162.1)

Last updated on JUNE 10, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 to 12.2.0.1 [Release 11.2 to 12.2]
Information in this document applies to any platform.

Symptoms

On : 11.2.0.4 version


After importing the wallet, execute "SELECT utl_http.request('https://xxxx.xxxx.com/') FROM dual", an error occurred

ERROR
-----------------------
ORA-29273: HTTP request failed
ORA-06512: at "SYS UTL_HTTP", line 1720
ORA-29024: Certificate validation failure
ORA-06512: at line 1


STEPS
-----------------------
1. Upload crt file to the /tmp/wallet directory on the server

2. $ orapki wallet create -wallet /tmp/wallet -pwd password -auto_login

3. $ orapki wallet add -wallet /tmp/wallet -trusted_cert -cert "/tmp/wallet/DigiCert Global Root CA.crt" -pwd password

4. $ sqlplus / as sysdba

SQL> EXEC UTL_HTTP.set_wallet('file:/tmp/wallet', 'password');

PL/SQL procedure successfully completed.

SQL> SELECT utl_http.request('https://xxxx.xxxx.com/') FROM dual;
SELECT utl_http.request('https://xxxx.xxxx.com/') FROM dual
  *
ERROR at line 1:
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1720
ORA-29024: Certificate validation failure
ORA-06512: at line 1


Changes

None 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


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