Testing the Oracle Wallet holding the User Certificate

 Test by running this as sys (to avoid ACL issues):

SELECT utl_http.Request('[secure url]', NULL, 'file:[path to wallet directory]',
              '[password for wallet]') a
FROM   dual;

Eg:

SELECT
utl_http.Request('https://mycompany.mydomain.in', NULL, 'file:/oradb/proddb/19.12.0/appsutil/wallet12jan', 'welcome123') x
FROM   dual;

If it works, you won’t get any errors and you’ll see the http code that is returned by the secure web page.

select utl_http.request('[secure url]'
,null
,'file:[path to wallet directory]'
,'[password for wallet]') a
from dual
/

select utl_http.request('[secure url]'
,null
,'file:[path to wallet directory]'
,'[password for wallet]') a
from dual
/