TOAD for Oracle by Quest Software Forum

1. Download latest version of CrossOver 18.0.0.3094 from CodeWeavers.com.

2. Download latest version of Toad for Oracle 12.11 – 2017 MSI version 32bit version from quest.com. (64 bit version is giving memory errors).

3. Download Oracle instant client 32bit version instantclient_12_2 from oracle.com. Unzip in download folder.

4. Install CrossOver by moving downloaded CrossOver file to Application folder on Mac.

5. Modify security preferences to allow CrossOver to run. Open System Preferences -> Security & Privacy -> click on radio button Anywhere.

6. Start CrossOver, click Install a Windows Application. Choose downloaded Toad for Oracle 12.11.0.95 32bit MSI installer file and click continue.

7. Select New Windows 7 Bottle (do NOT choose Windows 7 64-bit!)

8. Click Install on Installation screen, installer will start installation of Microsoft .NET Framework 2.0 and SP2. Let it finish.

9. Click Click on Restart Now and continue through installation for >NET Framework 4 setup

10. Once it finished NET Framework, Toad for Oracle installation will start.

11. It might give you error in end "Installing TOAD for Oracle" task failed. Click on skip this step.

12. Open Toad for Oracle, it will open but will show for Oracle Client not found error.

13. Open CrossOver window, click on bottle -> click open c drive. Create new folder oracle and copy downloaded unzipped folder instantclient_12_2 in.

14. Create new folder c:\oracle\instantclient_12_2\network\admin and put your tnsnames.ora and sqlnet.ora files.

15. Type regedit which will open Registry Windows. Create new key under My Computer->HKEY_LOCAL_MACHINE->Software->Oracle
    Create following string values in right windows of Oracle Key.
    LD_LIBRARY_PATH = c:\oracle\instantclient_12_2
    ORACLE_HOME = c:\instantclient_12_2
    ORACLE_HOME_NAME = c:\instantclient_12_2
    SQL_PATH = c:\instantclient_12_2
    TNS_ADMIN = c:\instantclient_12_2\network\admin
    NLS_LANG=AMERICAN.AMERICA
    NLS_DATE_LANGUAGE = AMERICAN
    NLS_DATE_FORMAT =MM-DD-RRRR
    Save and exist Registry.

16. Open Toad, you will see newly created Oracle Home entry

17. Select Oracle Home from Installed Client drop down. Verify Oracle Home related entries by clicking on ... button on right.

18. If you see all registry entries, you should able to connect to Oracle Libraries.

DONE!!! Enjoy and please post comments in forum.

Kalpesh Jani
Oracle Database Administrator
Oracle Certified Professional