APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Ora-29024 certificate error

mpatzwahlFeb 24 2020 — edited Feb 25 2020

Hi,

i´m struggling on a problem with certificates ....

I want to use my Rest Interface in www.muniqsoft-training.de ....

I have downloaded all certificates i found for this webseite ...

orapki wallet display -wallet https_wallet

Oracle PKI Tool Release 18.0.0.0.0 - Production

18.1.0.0.0 : Version {1}

Requested Certificates:

User Certificates:

Trusted Certificates:

Subject: CN=DST Root CA X3,O=Digital Signature Trust Co.

Subject: CN=Let's Encrypt Authority X3,O=Let's Encrypt,C=US

Subject: CN=muniqsoft-training.de

But then ...

SELECT APEX_WEB_SERVICE.MAKE_REST_REQUEST(

p_url=>'https://muniqsoft-training.de/ords/muso_rest/muso/XXXXXXX',

p_http_method=>'GET',

p_username=>'xxxxxxxxxxxxx',

p_password=>'xxxxxxxxxxxxx') FROM dual; 2 3 4 5

ERROR:

ORA-29273: HTTP request failed

ORA-06512: at "APEX_190200.WWV_FLOW_WEB_SERVICES", line 1283

ORA-06512: at "APEX_190200.WWV_FLOW_WEB_SERVICES", line 924

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_190200.WWV_FLOW_WEB_SERVICES", line 902

ORA-06512: at "APEX_190200.WWV_FLOW_WEB_SERVICES", line 1136

ORA-06512: at "APEX_190200.WWV_FLOW_WEB_SERVICES", line 1473

ORA-06512: at "APEX_190200.WWV_FLOW_WEBSERVICES_API", line 416

ORA-06512: at line 1

What is happening here, or how can i found out which cert is missing

Thanks

Marco

This post has been answered by Carsten Czarski-Oracle on Feb 25 2020

Jump to Answer

Added on Feb 24 2020

#apex-discussions

8 comments

1,322 views