Create an Oracle Wallet to store DB Credentials on Windows

Question

I managed to create and store credentials in an oracle wallet on a Unix system using mkstore command line tool.

How can I achieve the same in Windows? Oracle Wallet manager seems to be a different thing that ask for certificate and certification authority and on command line mkstore give me syntax error ...

'The syntax of command is incorrect.'

I have run as administrator and have the Oracle Runtime Client 12.2 installed.

Any idea or help?

Answer 1

There is a known issue with the mkstore.bat from version 12.2.0.1 - when you attempt to use it, it results in the error message: The syntax of command is incorrect. Here are a couple of possible options to get you going:

1. Revert to version 12.1.0.2.
2. Try updating your ORACLE_HOME environment variable to point to the 12.2.0.1 client to see if that has any impact.
3. Try copying the mkstore.bat from a 12.1.0.2 binary to replace your 12.2.0.1 version. Make sure to backup the previous .bat file.

For anyone interested, this is related to Bug 26827996. https://support.oracle.com/epmos/faces/DocumentDisplay?id=2406404.1