05.05.2020

Toad For Mac Oracle Client

47
Toad For Mac Oracle Client Average ratng: 7,8/10 4999 votes
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:oracleinstantclient_12_2networkadmin 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:oracleinstantclient_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_2networkadmin
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

Step 1: Where to install the Files


Opinions differ about the best location for installing the downloaded files.

Download latest version of Toad for Oracle 12.11 – 2017 MSI version 32bit version from quest.com. (64 bit version is giving memory errors). Free vpn client mac. Download Oracle instant client 32bit version instantclient_12_2 from oracle.com. Unzip in download folder. Windows 10. Toad for Oracle solutions are built to meet the needs of your specific job function. Try Toad free for 30 days. Oracle’s Instant Client is a valuable tool allowing anyone on a Mac to connect to Oracle databases, and is a prerequisite for installing SQL Developer, SQLPlus, or OCI8 (for PHP connectivity). However, Oracle’s documentation for installing Instant Client is very light.

Toad For Mac


In practice you can install the Oracle instant client files anywhere on your file system so long as the PATH environment variable is updated to include that directory in the search path
  • Some install instructions suggest copying the install files into the directories:
    /usr/lib or /usr/bin
    This works - but is best avoided. My concern with this approach is that these are the default locations for OS X libraries and commands. Copying in non-standard items gets messy when things go wrong - complicating the process to diagnose and fix issues because of the difficulty identifying which items should (and shouldn’t) be there. If you upgrade Instant Client in future, copying in the new version’s files over top may result in a mixture of old/new libraries which triggers unexpected behaviour. However, if you have issues defining environmental variables then this may be your only choice.
  • In Oracle’s installation example, they’ve created a directory:
    /opt/oracle/instantclient_11_2
    This gives you a separate (clearly specified) directory for your Instant Client files. It’s also good choice as /opt is the base directory favoured for non-standard (i.e. optional) software installs in Unix operating systems …but it’s just not commonly used in Mac circles.
  • My preferred option is:
    /Library/Oracle/instantclient_11_2
    This has the advantage of the choice above - but is a more Mac-like alternative. This is the directory I’ll specify for these instructions going forward (but feel free to use whichever location you think is most appropriate for you).
After downloading the three packages above:

Toad For Mac Oracle Client Download

  1. Extract instantclient-basic and instantclient-plus zip files into single folder (e.g. /Library/Oracle/instantclient_11_2), then
  2. Create a subfolder named “sdk” inside that folder, and extract instantclient-sdk into it.