I'm having problems to be able to login with oracle wallets in windows.
With sqlplus I can just do a sqlplus /@CONNECTION_NAME and works fine.
But if I do the same with sqlcl, I just receive an invalid credentials and doesn't seem to recognize the user:
sql /@CONNECTION_NAME
USER =
URL = jdbc:oracle:thin:@CONNECTION_NAME
Error Message = ORA-01017: invalid username/password; logon denied
If i do a show tns all seems to be fine. Can I use same syntax as sqlplus? What I'm missing? Latest versions used of sqlcl and oraclie instant client for windows.
My sqlnet.ora looks like this:
WALLET_LOCATION =
(SOURCE =
(METHOD = FILE)
(METHOD_DATA =
(DIRECTORY = C:\Oracle\oracle_home\network\admin)
)
)
SQLNET.WALLET_OVERRIDE = TRUE
I have in the same folder the tnsnames.ora and the wallet and proper environment variables set to this directory.