In Oracle UTL_HTTP Fails With ORA-29024 After Importing WebServer's Certificate into the Oracle Wallet
(Doc ID 1682823.1)
Last updated on DECEMBER 29, 2023
Applies to:
Oracle Cloud Infrastructure - Database Service - Version N/A and laterOracle Database Backup Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Security Service - Version 19.7.0.0.0 to 19.20.0.0.0 [Release 18.1 to 19.0]
Oracle Database - Enterprise Edition - Version 12.1.0.1 to 19.20.0.0.0 [Release 12.1 to 19]
Information in this document applies to any platform.
Symptoms
In Oracle12c, when attempting to use UTL_HTTP in SSL mode the following error occurs.
ERROR
-----------------------
ORA-29024 Certificate validation failure.
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create the wallet and put the web server certificates
2) sqlplus / as sysdba
select UTL_HTTP.REQUEST('https://test.domain','www-proxy.domain','file:/home/oracle/TESTCASE/SR_HTTPS,'Welcome1') FROM DUAL;
Changes
Upgrade from Oracle11g Release 2 (11.2.0.x) to Oracle12c Release 1 (12.1.0.x)
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 |