Description
Hello everyone,
I am facing the ORA-29024: Certificate Validation Failure error when trying to access the Oracle Cloud webservice to fetch images from a Bucket.
Context:
Using APEX_WEB_SERVICE.Make_Rest_Request passing URL, Method, Body and Credential Id as parameters, I'm getting the error ORA-29024 when ORDS and Database is installed in different servers.
Test Environment (Works)
- ORDS and Database (APEX) on the same server.
- Web Credentials registered with the private key and API Key information obtained from my profile in Oracle Cloud.
- Wallet created and certificate chain installed for HTTPS access to the Oracle site.
- Wallet Path configured correctly in the APEX instance.
- Everything works fine.
Production Environment (Error)
- ORDS server separated from the Database.
- Wallet created with the same certificates used in the test environment.
- Wallet Path configured in the instance.
- Same Web Credentials that its in Test Env.
- Constantly receiving the "Certificate Validation Failure" error.
Steps Already Taken:
- Verified that the Wallet contains all necessary certificates.
- Confirmed that the Wallet Path is correctly configured in the APEX instance.
- Tested communication with Oracle Cloud from the production server, ensuring that network and access configurations are correct.
- Reinstalled everything from scratch on a new enviroment (using ords and db on same server) and works perfectly, but if I change ORDS to a separate server, the error appears.
Questions:
- Has anyone experienced a similar issue and could share the solution?
- Is there any additional specific configuration I need to perform in the production environment, considering ORDS is separated from the Database?
- Any tips on additional diagnostics I can perform to identify the cause of the problem?
I appreciate any help or guidance you can offer!
Thank you!