Hi Guys,
I am running Oracle XE 11g on Windows 10. I have used the orapki bundled with Oracle Database 12c Release 2 Client (12.2.0.1.0) for Microsoft Windows (x64) to create a wallet (I tried to use the 11g release but it had problems with some of the certificates). As far as I can tell, the root and intermediate certificates are in the wallet. The wallet was set up as auto-login.
I have created a user (dev) and granted him privileges. I run utl_http.set_wallet('file:C:\wallet', 'xxxxx'); - I have tried this with and without a password.
When I run, say, SELECT utl_http.request('https://www.oracle.com/', null, 'file:C:\wallet', 'xxxxx') FROM dual; - I get 'ORA-28759: failure to open file'. I have tried this, again, with and without a password.
I think this may be a file permission problem - though I'm open to alternative suggestions. When I installed both the database and client, I used to default built-in user but this may have been my mistake.
Has anybody got a suggestion as to how to fix this? Maybe change the file permissions? Are there any diagnostic tools that may point to the problem?
Is there a way to find out which OS user is attempting to open the wallet file?
Thanks in advance - Steve