Toad World® Forums

Toad for Oracle not working after in place upgrade to Win 10

After having to perform an inplace upgrade of my OS from Win 7 to Win 10, my TOAD 13.1 stopped working. It seems to connect to the DB (I can see the connection appearing in the session browser - from another machine), but then it stops repsonding, and just closes without further warning.

I installed TOAD 13.1.1, but the same thing happens.

Any suggestions?

Thanks,
Steven

I've never heard of this problem, so I'm not sure what the easiest solution is, but maybe one of the following will fix it:

Remove, Reinstall Oracle client
Steps here: Cannot load OCI: C:\Oracle\product\12.2.0\client_1\BIN\OCI.dll

Reset Toad's user files

  1. From Toad's main menu: Utilities -> Copy User Settings
  2. Choose the option to Reset to a clean set
  3. Click OK
  4. Choose Yes and then OK on the next two dialogs

This will restore Toad to a clean state as if it were freshly installed. Your existing user files will be backed up to %APPDATA%\Quest Software\Toad for Oracle\13.1_bak.

Now, start Toad, make connection, and try again. If it works you can close Toad and copy any configuration files over from the backed up set to the new ( %APPDATA%\Quest Software\Toad for Oracle\13.1 ) . I'd recommend copying only what is absolutely necessary. For example...

  1. CONNECTIONS.* (all of your saved connections)
  2. SavedSQL.dat (SQL Recall)
  3. ToadActions.dat (Automation Designer apps and actions)
  4. Workspaces.dat (saved Workspaces)
  5. *.tpr (Project Manager projects)

If there are some other setting you'd like to find, let me know and I'll add them to the list.

If that doesn't help, maybe reinstall Toad? Usually that doesn't solve anything, but I'm running out of ideas.

I actually found another post, where it was suggested to clear all the files in the folder:
C:\Users...\AppData\Roaming\Quest Software\Toad for Oracle\13.1\User Files

But then TOAD seemed to copy all the files from the 13.0 folder. After deleting both folders, TOAD started normally.

Unfortuantely, all my settings and connections are gone and I have to reconfigure it all.

see the above post for bringing some settings back.

You can also try copying Toad.ini over. We keep a lot of settings in that file, but it may bring the original problem back.

If there are other settings that you'd like to recover, let me know which ones and I'll tell you what to copy over.

Just be sure to copy files over while Toad is not running.

I should have read your post before just deleting everything.. :frowning_face:
I had to "Restore" from the recycle bin.... and now everything is working. Even before I had to copy the user settings.

Magnificent. Thanks for your help...

1 Like