Skip to Main Content

SQLcl: MCP Server & SQL Prompt

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

sqlcl and wallet authentication support in windows

YevonFeb 2 2022 — edited Feb 2 2022

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.

Comments
Post Details
Added on Feb 2 2022
1 comment
591 views