How to configure Oracle Wallets in Toad for Oracle? (4378614)

How to configure Oracle Wallets in Toad for Oracle?

Single Wallet Configuration Steps:

Single wallet to be used for several databases:

1. Ensure Wallet file is extracted and located in the appropriate path
2. Specify the entry in SQLNET.ORA as: 
   WALLET_LOCATION= (SOURCE= (METHOD=file) (METHOD_DATA= (DIRECTORY=C:\Oracle\Wallet)))
   Details are in Oracle documentation

Multiple Wallets Configuration Steps:

Multiple wallets specified per database:

1. Ensure each Wallet file is extracted and located in the appropriate path. For each Wallet file:
2. Specify the entry in TNSNAMES.ORA file:

NameOfTNSEntry =
  (DESCRIPTION=
    (ADDRESS_LIST =
      (ADDRESS=(PROTOCOL=tcps)(HOST=xyz.somewhere.com)(PORT=1234))
    )
  (CONNECT_DATA=(SERVICE_NAME=NameOfService))

  (SECURITY =
     (WALLET_LOCATION = C:\Oracle\Wallets\Specific_Wallet_Folder)  
  )
)

      3. Other parameters can be used in the SECURITY section in case needed. Details can be found here:  Oracle documentation.  

       Note: TNSNames wallet entries override SQLNET.Ora entries.  You can specify both if you desired, with this in mind.

Wallet configuration in Toad for Direct connections:
For Direct connection, wallets can be configured using the "more" option in the Direct tab of the Connection Manager.