Skip to content

ORA-29024: Certificate validation failure

After import end user certificate using oracle wallet manager to database server (19c) still we’re facing the below errors

SQL> select utl_http.request (‘https:// URL FULL PATH’,NULL,’file:/u01/app/oracle/product/19c/orahome_1/owm/wallets/orauat’,’Password’) from dual;
select utl_http.request (‘https:// URL FULL PATH ‘,NULL,’file:/u01/app/oracle/product/19c/orahome_1/owm/wallets/orauat’,’Password’) from dual
*
ERROR at line 1:
ORA-29273: HTTP request failed
ORA-06512: at “SYS.UTL_HTTP”, line 1530
ORA-29024: Certificate validation failure
ORA-06512: at “SYS.UTL_HTTP”, line 380
ORA-06512: at “SYS.UTL_HTTP”, line 1470
ORA-06512: at line 1

Solution :

remove end user certificate, import only root and intermediate certificates

SQL> select utl_http.request (‘ URL FULL PATH ‘,NULL,’file:/u01/app/oracle/product/19c/orahome_1/owm/wallets/orauat’,’Password’) from dual;

Output comes

{ “error”: “missing_client”, “description”: “client_id is missing”

*URL FULL PATH means — certificates url

No comments yet

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: