Hi,
We have setup Oracle wallet for our DB and this was working fine.
Recently we had an our server patched, since then we have been facing wallet opening issues. Below is my wallet config
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
WALLET_LOCATION=
(SOURCE = (METHOD=FILE)
(METHOD_DATA=(DIRECTORY = F:\wallet))
)
SQLNET.WALLET_OVERRIDE = TRUE
Using this wallet I'm able to login in the server with no issues, but when i use a tool to do stuff it gives me below error.
SQL*Plus: Release 11.2.0.1.0 Production on Tue Jul 16 14:33:49 2019
Copyright (c) 1982, 2010, Oracle. All rights reserved.
ERROR:
ORA-12578: TNS:wallet open failed
Enter user-name: SP2-0306: Invalid option.
Usage: CONN[ECT] [{logon|/|proxy} [AS {SYSDBA|SYSOPER|SYSASM}] [edition=value]]
where <logon> ::= <username>[/<password>][@<connect_identifier>]
<proxy> ::= <proxyuser>[<username>][/<password>][@<connect_identifier>]
And when i change SQLNET.WALLET_OVERRIDE = FALSE, it gives invalid Credentials errors even if the credentials are correct.
We have an antivirus in place, could this be the issues can someone help and guide us.
Thanks All in advance.