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.

 

See Connecting to databases with MFA in Toad blog for complete details.