Home > Uncategorized > RUN TOAD FOR ORACLE ON MAC OS X

RUN TOAD FOR ORACLE ON MAC OS X

Prerequisites

  • 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.

Configuration

My System:

  • 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 11.2.0.3 for WINDOWS  (32-bit)

Toad for Oracle MSI installer 

https://support.quest.com/Search/SoftwareDownloads.aspx?ProductID=268435520&ProductName=Toad%20for%20OracleOracle Instant Client
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:

  1. Go to Configure > Install Software… and select “Unsupported Application”
  2. Next, select your Toad for Oracle MSI installer by clicking on the “Select an installer” section. Use the first option: “Choose Installer File”
  3. In the next section, choose “New winxp Bottle…” and give it a name
  4. Click Install and step through the Toad for Oracle installer.
  5. 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.
  6. 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.

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521))
(CONNECT_DATA =
(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.

Advertisements
Categories: Uncategorized
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: