I have a Wallet configured and working fine for SQLPlus. Is there a way to make it work with SQL Developer?
Can a Wallet be used with SQL Developer? How
oracleoracle-11g-r2wallet
Related Question
- SQL Developer cannot connect to Oracle database, yet sqlplus can!
- Oracle cannot connect to SQL developer as sys account
- Oracle – How to Launch SQL Developer
- Oracle 12c – How to Configure SQL Developer
- Oracle – How to Fix ORA-01017: Invalid Username/Password in SQL Developer but Not in SQLPlus
- ODP Connect String with Oracle Wallet
- Configure sql developer for oracle using IPC fails with network adapter error
- Understanding SQL Developer User Accounts in Oracle
Best Answer
One way to do this is to specify an Advanced Connection Type and enter a custom JDBC URL as follows:
jdbc:oracle:oci:/@myDatabase
In addition the "OS Authentication" check box needs to be checked. This would seem to cause it to pass the OS username and password, but apparently (perhaps because I don't have NTS set as an authentication service in my sqlnet.ora) it does not and instead uses the wallet.