CODEWITHSUNDEEP
windowsoracle-databasesslcredentialswallet
RevivedPicard
RevivedPicard

Reputation: 129

Create an Oracle Wallet to store DB Credentials on Windows

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?

Upvotes: 2

Views: 4309

Answers (3)

paulH
paulH

Reputation: 1

I had the same issue Syntax error every time I tried to do anything with mkstore. Found that the person who built the server didn't set the ORACLE_HOME or TNS_ADMIN env variables but that didn't help. What did work was Markus F's suggestion to edit the mkstore.bat

:check_orahome if ("%ORACLE_HOME%") == () goto :no_orahome to

:check_orahome if ("%ORACLE_HOME%") == ("") goto :no_orahome

Thanks very much Markus you saved me hours.

Upvotes: 0

Markus F.
Markus F.

Reputation: 21

maybe this works for you too:
I've edit the file mkstore.bat and changed the following line

:check_orahome
if ("%ORACLE_HOME%") == () goto :no_orahome

to

:check_orahome
if ("%ORACLE_HOME%") == ("") goto :no_orahome

That helped me.

Upvotes: 2

1991DBA
1991DBA

Reputation: 805

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

Upvotes: 4

Related Questions