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

Posted by satish on May 24, 2023; 10:26am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/1530-ORA-24263-Certificate-of-the-remote-server-does-not-match-the-target-address-tp11914.html

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