-
Oracle emallet works on-prem but not in DBCS
Oracle 19c in cloud and Oracle 12c on-prem both using Red Hat Linux
Oracle ewallet allows connections to remote server on-prem from database on-prem.
But when creating a new ewallet in DBCS database, cannot connect to remote server on-prem.
Get the following error:
ORA-29024: Certificate validation failure
Here is the code when testing against remote server:
SQL> select apex_web_service.make_rest_request(
2 p_url => 'https://earthquake.usgs.gov/earthquakes/feed/v1.0/summary/2.5_day.geojson',
3 p_http_method => 'GET',
4 p_wallet_path => 'file:///u01/app/oracle/admin/mydatabase/wallet' ) from dual;
ERROR:
ORA-29273: HTTP request failed
ORA-06512: at "APEX_220100.WWV_FLOW_WEB_SERVICES", line 1182
ORA-06512: at "APEX_220100.WWV_FLOW_WEB_SERVICES", line 782
ORA-29024: Certificate validation failure
ORA-06512: at "SYS.UTL_HTTP", line 380
ORA-06512: at "SYS.UTL_HTTP", line 1148
ORA-06512: at "APEX_220100.WWV_FLOW_WEB_SERVICES", line 756
ORA-06512: at "APEX_220100.WWV_FLOW_WEB_SERVICES", line 1023
ORA-06512: at "APEX_220100.WWV_FLOW_WEB_SERVICES", line 1371
ORA-06512: at "APEX_220100.WWV_FLOW_WEBSERVICES_API", line 568
ORA-06512: at line 1
no rows selected
Any ideas?
Thanks.
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|