Hi,
We are trying to setup a SSL connection (using PL/SQL) with https://www.ngfkaart.nl, specifically https://www.ngfkaart.nl/club/modules/handicaps/gethandicap.php.
This used to work before with their old certificate, but now we get a ORA-29024 error with the new certificate. We did the following course of action, which we always do for a SSL connection:
- Save the certificate chain in p7b format using Chrome (also tried with Internet Explorer)
- Make a new wallet manager and import the chain
- Use that wallet for the UTL_HTTP request
This has worked before, and we also now tried it with a different site (https://www.centos.org), which gives no error.
Looking at the documentation on https://docs.oracle.com/cd/B28196_01/core.1014/b28185/ssl_tr.htm, we tried to find the reason for the error, but have not found it.
The software supplier of www.ngfkaart.nl says their certificate and chain should be in orde, which is confirmed by https://www.sslshopper.com/ssl-checker.html#hostname=www.ngfkaart.nl. Accessing the site via browser also gives no problem.
Is there any way to pinpoint the exact reason for this error, and how we can make it work? Or is there a step which we are missing?
Thanks in advance for the help!