

If you can get it to work with SQLPlus, tnsnames.ora, and sqlnet.ora, it will work with Toad. John is correct that it really is not a Toad issue. I have not done more than one wallet, but have seen it described in articles found on the web, but don't currently have a link. I have gotten the regional wallet, and instance wallet to work. Download instance wallets for each ATP instance and make an entry for each instance wallet in your sqlnet.ora file that points to each wallet. Make sure the port is open from your source IP (Toad server) to your destination IP (Oracle DB) you can test it with telnet. The trade off is the same as the benefit, a single wallet opens an encrypted channel to all of the ATP dbs in your region, which depending on what you are doing might not make sense from a security perspective. Save time and reduce risks with the leading Oracle database development and optimization software tool, as ranked by IDC. Quest Support Product Release Notification - Toad Edge 2.6.

Quest Support Product Release Notification - Toad for Oracle 16.2 Subscription.

The regional wallet will work for the ATP's you have defined in your region and you won't need an individual Instance Wallet. Toad for Oracle is a database development and management toolset that reduces the time and effort developers and DBAs spend on daily tasks. Security Bulletins & Product Notifications. The first is to get a "Regional wallet" from Oracle Cloud Infrastructure (OCI) from your autonomous transaction processing (ATP) database, put that on your local workstation, and update your sqlnet.ora to reflect the path to the regional wallet. There are two possibilities that I know of to get this to work.
