1 Reply Latest reply on Feb 24, 2020 3:38 PM by thatJeffSmith-Oracle

    Certificate Error ORA-29024

    mpatzwahl

      Hi,

       

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

       

      I want to use m 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}

      Copyright (c) 2004, 2017, Oracle und/oder der verbundenen Unternehmen. All rights reserved. Alle Rechte vorbehalten.

       

      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