1530 ORA-24263: Certificate of the remote server does not match the target address

[satish]

Hi Erman,

 Environment:
2 node RAC
Version 19.17

We are trving to access a url from database server. We have created a wallet and placed the site's certificates into wallet.

SQL> select utl_http.request('https:// erpuat.abc.org', null, 'file:/u02/certs/ wallet','welcome123') from dual;

 select utl_http.request('https:// erpuat.abc.org', null, 'file:/u02/certs/ wallet' 'welcome123') from dual
ERROR at line 1:
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1530
ORA-24263: Certificate of the remote server does not match the target address.
ORA-06512: at "SYS.UTL_HTTP", line 651
ORA-06512: at "SYS.UTL_HTTP", line 1472
ORA-06512: at line 1

Please guide.

Thanks,
SG

[ErmanArslansOracleBlog]

Your certificate (which is inside that wallet) is wrong.. Certificate is issued for a hostname, but you are trying to use it for reaching an host, which has another hostname.. Or it may be the case where the common name (CN) attribute of  the certificate does not match the requested connection or URL. So you may correct your certificate if there is a problem with that..
But! there is also a fact : " As of Oracle 12.2 the procedures of the utl_http package used to access remote webservices have a new parameter called https_host. One has to use this new parameter to avoid the error"
If you are all god with the certificate, then there this may be the reason.. See ->
See -> UTL_HTTP / UTL_SMTP Request Fail With ORA-24263 On A 12.2 Database (Doc ID 2275666.1)

[satish]

Thanks erman.

Issue fixed.We followed the note id.