My Oracle Support Banner

Encountering ORA-29024: Certificate validation failure on Oracle Database EE 12.1.0.2 for google certs (Doc ID 2538980.1)

Last updated on MAY 08, 2020

Applies to:

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

Symptoms

 encountering an ORA-29024 error when attempting to connect to www.google.com using UTL_HTTP with HTTPS on Oracle Database 12.1.0.2.

1) Running the following query using HTTPS fails with ORA-29024 on Oracle Database 12.1.0.2.

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

SQL> select UTL_HTTP.REQUEST( 'https://www.google.com', NULL, 'file:/u01/app/oracle/wallet' ) from dual;
select UTL_HTTP.REQUEST( 'https://www.google.com', NULL, 'file:/u01/app/oracle/wallet' ) from dual
*
ERROR at line 1:
ORA-29273: HTTP request failed
ORA-29024: Certificate validation failure
ORA-06512: at "SYS.UTL_HTTP", line 1491
ORA-06512: at line 1

Changes

 Not Applicable

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

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