- CrossOver for Mac
- GDI+ library (for Toad version 11.5 only)
- Toad for Oracle MSI installer
- Oracle Instant Client
As excited as I am that Toad runs on Mac within CrossOver, I have to temper things a bit by admitting that it has not been fully tested. You may also find that this may or may not work with your specific OS/software/version combination. So, until this is fully tested, verified, and officially supported by Quest, please understand that your mileage may vary.
- 13” MacBook Pro (2.5GHz Intel i5, 8Gb RAM)
- OS X Lion 10.8.3
- CrossOver for Mac 11.0.3
- Toad for Oracle 11.0 (professional, commercial)
- GDA+ library
- Oracle Instant Client 220.127.116.11 for WINDOWS (32-bit)
Toad for Oracle MSI installer
Download the 32-bit Instant Client – Basic and Instant Client – SQL*Plus from http://www.oracle.com/technetwork/topics/winsoft-085727.html
CrossOver for Mac (www.codeweavers.com)
It’s about $50 for a license, but you can start with a 14-day trial to give you enough time to try..
Step 1: Install CrossOver for Mac
This is real straightforward. If you get stuck here, stop; this article probably isn’t for you.
Step 2: Install Toad for Oracle
Installation via CrossOver is pretty straightforward:
- Go to Configure > Install Software… and select “Unsupported Application”
- Next, select your Toad for Oracle MSI installer by clicking on the “Select an installer” section. Use the first option: “Choose Installer File”
- In the next section, choose “New winxp Bottle…” and give it a name
- Click Install and step through the Toad for Oracle installer.
- CAUTION: If installed Toad for Oracle v11.5 you will need to instll the GDI+ library first. Otherwise, CrossOver will crash when you launch Toad. You can download & install it from here: http://www.codeweavers.com/compatibility/browse/name/?app_id=8227. Make sure you install it into teh same Bottle as Toad for Oracle 11.5.
- Once everything is installed, you should have a shiny new Toad icon in your Launchpad!
Step 3: Connectivity and Environment Variables
Now that we have Toad installed, we need to configure our instant client. Assuming you’ve already downloaded the two packages referenced above, go ahead and unzip them. I recommend placing them all together into a single directory like /instantclient_11_2.
Now create /network/admin folder inside there. This is where we’ll place the tnsnames.ora file (which we have to create). Open your favorite text editor (mine’sTextWrangler) and create your tnsnames.ora file using this structure below. Be sure to replace hostname and SID with the appropriate data for your Oracle instance.
(ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521))
(SERVER = DEDICATED)
(SERVICE_NAME = SID)
CAUTION: If you’re using TextEdit, stop. TextEdit likes to default to RTF formatting which will wreak havoc with Oracle’s OCI. Save yourself the headache of troubleshooting connection problems and avoid using RTF format…
Once you have your instant client folder arranged and your tnsnames.ora file created, you’ll need to move it over to the C:\ drive of the CrossOver emulator. From CrossOver, click Configure > Manage Bottles… and select your new bottle. Click on the “Advanced” tab and then the “Open C: Drive in Finder” button.
Copy your shiny new /instantclient_11_2 folder to the root of C:\ as you see here:
Next, we need to run regedit to add a few environment variables. Back over to CrossOver, click Configure > Manage Bottles… and select your bottle. Click on the “Control Panel” tab and choose “Task Manager”.
In the Task Manager, click File > New Task (run…) and enter “regedit”
Now let’s add some keys. First, navigate to \HKEY_CURRENT_USER\Environment and add a new String Value as “PATH” with data “c:\instantclient_11_2”.(NOTE: If PATH already exists, just append c:\instantclient_11_2 to the end, separated by a semi-colon.)
Next, navigate to \HKEY_LOCAL_MACHINE\SOFTWARE and add a new key named “Oracle.” Then add a new String Value as “ORACLE_HOME” with data “c:\instantclient_11_2”. Lastly, add one more String Value as “TNS_ADMIN” with data “c:\instantclient_11_2\network\admin”.
Let’s check our configuration and see if we’ve got everything set up properly. From the CrossOver menu click Programs > Run Command… In the new window which opens, use the dropdown to select the appropriate Bottle and then expand Debug Options and click “Open Shell.” This will open a terminal window on the Mac and set the environment variables to CrossOver’s Bottle. To invoke the Windows Command Prompt just type wine cmd. If all goes well you should see a familiar C:\> prompt. Type in “sqlplus” to step into SQL*Plus and connect using your Net Service name defined in the tnsnames.ora file
If you can’t connect at this point, I think it’s a good idea to fiddle with your tnsnames.ora and double check your network settings before moving on.
Now that we’ve installed everything and verified connectivity, let’s fire up Toad for Oracle! You can use that shiny new Toad icon in your Mac OS X Launchpad or run it from CrossOver’s menu by clicking Programs > Quest Software > Toad for Oracle > Toad for Oracle 11
The program seems to run fine for most things, though the painting of windows seems a little slow.