Wow…it is nearly 4 years ago now that I wrote an article on connecting to the database via a wallet to avoid having to hard code passwords into script. That article is here:
So I went to do a similar exercise on my new 18c Windows database today, and to my surprise things went pear shaped at the very first step
c:\oracle\product\18\bin>mkstore -create -wrl c:\temp\wallet The syntax of the command is incorrect.
Not a lot of feedback there
Unfortunately it’s just a small error in the script (See MOS Note 2406404.1 ). All you need to do copy the mkstore.bat from as 12.1 client and you’ll be fine. I called mine mkstore121.bat.
c:\oracle\product\18\bin>mkstore121.bat -create -wrl c:\temp\wallet Oracle Secret Store Tool Release 220.127.116.11.0 - Production Version 18.104.22.168.0 Copyright (c) 2004, 2017, Oracle and/or its affiliates. All rights reserved. Enter password: ********* Enter password again: *********