Encountering ORA-29024: Certificate validation failure on Oracle Database EE 12.1.0.2 for google certs
(Doc ID 2538980.1)
Last updated on JULY 20, 2024
Applies to:
Advanced Networking Option - Version 12.1.0.2 and laterInformation 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 |