Requires installation of Windows 32-bit InstantClient from Oracle, .NET 4.5, and MSXML 6.
Start with a 32-bit wineprefix:
- In a terminal, enter "WINEARCH=win32 WINEPREFIX=~/.wine32 winecfg"
- In the winecfg window, set Windows version to "Windows 7"
- Click on the "graphics" tab, tick "emulate a virtual desktop" and set desktop size to something that will fit your display. This can be undone later, but is useful for some installer notifications and dialogs that might not work without it. Click "OK"
- Make sure you have the latest winetricks script from WineHQ
- Back in the terminal, enter "winetricks dotnet45 msxml6". Windows dialogs will appear, and just follow through them to install .NET 4.5 and MSXML6
Install InstantClient for Windows 32-bit:
- Download 32-bit basic plus any extras needed from http://www.oracle.com/technetwork/topics/winsoft-085727.html
- Unzip downloaded files to a folder on a Wine drive, e.g. to ~/.wine/drive_c/oracle/instantclient_21_2
- In the terminal window, enter "wine regedit", navigate to "HKEY_CURRENT_USER/Environment", and add a string value named PATH
- Set the PATH string to the location of the InstantClient directory in Windows path format. E.g., "C:\oracle\instantclient_12_2"
- Create a string value named TNS_ADMIN
- Set the TNS_ADMIN string to the location where you will store any tnsnames.ora or sqlnet.ora files. Using the same directory as the InstantClient base directory is fine. E.g., "C:\oracle\instantclient_12_2"
Install Toad for Oracle 32-bit:
- Download the 32-bit trial version or full installation from qwest.com
- In the terminal, enter "wine ./Toad_for_Oracle_2017_x86_Full.exe" (substitute the name of your exe if different)
- Complete the installation as you would on Windows. If prompted about installing Gecko, answer yes to install it.
- You'll get some shortcuts for Toad on your Linux/Unix desktop. Use them to start Toad.
- To import settings from another machine, open Toad on that machine and select "View" menu, "Toad Options," and use the search box for "application data directory". Copy the folder shown in that field to a USB drive and then insert the drive into the Linux machine. On the Wine machine, open Toad and go to "Utilities," "Copy User Settings," and, on "copy user files..." browse to the USB location with the files. Click "OK" and you're done.
- You can use winecfg again to unset the option "emulate a virtual desktop."