Toad World Blogs - Toad 10.5 Freeware Runs on Linux

Blogger List

	Johannes Ahrends Toad and Oracle
	Ben Boise Toad SC Discussions
	Kevin Dalton Benchmark Factory
	Steven Feuerstein PL/SQL Obsession
	Devin Gallagher Toad SC discussions
	Stuart Hodgins JProbe Discussions
	Henrik "Mauritz" Johnson Toad Tips & Tricks on the "other" Toads
	Mark Kurtz Toad SC discussions
	Michael Lumbard Toad SC discussions
	Daniel Norwood Toad for Data Analysts, Toad Extension for Visual Studio
	Debbie Peabody Toad for Data Analysts
	Gary Piper Toad Reports Manager
	John Pocknell Toad for Oracle, JProbe
	Kuljit Sangha Toad SC discussions
	Bert Scalzo Toad for Oracle, Data Modeling, Benchmarking
	Jeff Smith Toad product family
	Richard To SQL Optimization
	Jim Wankowski DB2 - LUW and z/OS
	John Weathington
	Toad Data Modeler Data Modeling
	Real Automated Code Testing for Oracle Quest Code Tester blog

Blog Categories

Benchmark Factory (9)

Code Tester for Oracle (24)

JProbe (5)

PL/SQL Obsession (40)

Quest SQL Optimizer (29)

Spotlight on Oracle (4)

SQL Navigator (2)

Toad Data Modeler (10)

Toad Ext for Visual Studio (7)

Toad for Cloud Databases (0)

Toad for Data Analysts (28)

Toad for IBM DB2 (15)

Toad for MySQL (3)

Toad for Oracle (125)

Toad for SQL Server (9)

Blog Tags

toad for oracle (122)
oracle (62)
plsql (46)
sql optimization (37)
toad for data analysts (28)
code tester (19)
toad for ibm db2 (13)
automation (11)
batch optimizer (10)
virtualization (10)
schema browser (9)
toad for sql server (9)
data grid (8)
sql (8)
sql editor (8)
toad data modeler (8)
benchmark factory (7)
excel (7)
query builder (7)
report manager (7)
toad extension (7)
visual studio (7)
11g (6)
configuration (6)
freeware (6)
health check (6)
vmware (6)
connect (5)
dba module (5)
er diagrammer (5)
F4 (5)
linux (5)
refactoring (5)
spotlight (5)
unicode (5)
compare (4)
debugger (4)
export (4)
formatter (4)
make code (4)
rman (4)
strip code (4)
benchmark (3)
bfscript (3)
bulk collect (3)
code templates (3)
code xpert (3)
database browser (3)
db2 (3)
notebook (3)
oem (3)
RAC (3)
session browser (3)
speed (3)
sql optimizer (3)
toad for mysql (3)
tpc-c (3)
9.7 (2)
alert log (2)
app designer (2)
awr (2)
code insight (2)
code snippets (2)
collection (2)
compare and sync (2)
compliance (2)
data generator (2)
data warehouse (2)
database explorer (2)
database monitor (2)
explain (2)
forall (2)
ftp (2)
group execute (2)
handbook (2)
installation (2)
job scheduler (2)
multi-task (2)
nested table (2)
os command (2)
profiler (2)
recovery (2)
release history (2)
save as (2)
schema compare (2)
sql recall (2)
stats pack (2)
subversion (2)
team coding (2)
trace file browser (2)
while loop (2)
10g (1)
64 bit (1)
7zip (1)
action (1)
addm (1)
alter (1)
ansi join (1)
array (1)
ccleaner (1)
code coverage (1)
code road map (1)
CRON (1)
cursor for loop (1)
data browser (1)
data subset (1)
database probe (1)
dbms_flashback (1)
dbms_profiler (1)
ddl (1)
feuerstein (1)
filezilla (1)
flash drive (1)
flow control (1)
for loop (1)
group policy manager (1)
hints (1)
import (1)
index (1)
inheritance (1)
invoker rights (1)
ipad (1)
java (1)
latency (1)
log switch (1)
logical model (1)
ltrim (1)
master-detail browser (1)
monitor (1)
multi-select (1)
naming standards (1)
network (1)
object explorer (1)
OEBS (1)
package (1)
parser (1)
partitioning (1)
performance (1)
pragma (1)
project manager (1)
RAT (1)
revo (1)
REXEC (1)
schema report (1)
script manager (1)
search (1)
set operator (1)
sga (1)
slow (1)
sonarsource (1)
source control (1)
space projection (1)
sql monitor (1)
sql navigator (1)
sql script (1)
sql tracker (1)
sql*plus (1)
standards (1)
statistics (1)
stored procedure (1)
string parser (1)
sub-model (1)
sub-type (1)
synch (1)
synchback (1)
TELNET (1)
toad (1)
trace (1)
unit test (1)
unix (1)
usb (1)
utility (1)
v10 (1)
v9.5 (1)
version control (1)
waits (1)
workload replay (1)
workspace (1)
xml (1)

WELCOME, GUEST

Blogs
Toad and Database Commentaries

Toad World blogs are a mix of insightful how-tos from Quest experts as well as their commentary on experiences with new database technologies. Have some views of your own to share? Post your comments! Note: Comments are restricted to registered Toad World users.

Do you have a topic that you'd like discussed? We'd love to hear from you. Send us your idea for a blog topic.

Toad 10.5 Freeware Runs on Linux

May 10

Written by: Bert
Monday, May 10, 2010 8:59 AM

Look at the screen snapshot below – I’m running Toad for Oracle 10.5 freeware “natively via WINE” on Linux – specifically Ubuntu 10.04. Therefore you can now run the world’s favorite Oracle database tool on Linux. Goodbye Windows!

The steps are not that hard – but you must follow them all for this all to work. Here are the steps:

Download the Toad for Oracle 10.5 freeware – choose the EXE version (not the MSI version)
Download the Oracle 10.2.0.1 client zip file (check “ACCEPT” and then download 2^nd choice)
Unzip the Oracle 10.2.0.1 client into a directory (e.g. ~/client)
Run command: wine --version and verify that you have at least version 1.1.43
If you need to update wine – here are the steps for Ubuntu 9.10 and 10.04
1. Run command: sudo add-apt-repository ppa:ubuntu-wine/ppa (control-c if hangs)
2. Run command: sudo apt-get update
3. Run command: sudo apt-get install wine
Run command: rm -rf ~/.wine* (clears out anything leftover from prior WINE usages)
Run command: winecfg – when GUI launches just click OK (defaults to Windows XP)
Run command: sudo wget www.kegel.com/wine/winetricks
Run command: sudo chmod 777 winetricks
Run command ./winetricks mdac28 msxml3 msxml4 msxml6 vb6run vcrun6sp6 corefonts fontfix tahoma msls31 gecko riched20 riched30 richtx32 comctl32 comctl32.ocx
Run command: cd ~/client (or whatever directory you chose back in step #3)
Run command: wine setup.exe
Choose the option: RUNTIME (213 MB)
Ignore any “SERVICE” errors (i.e. continue)
Run command: cp ~/tnsnames.ora ~/.wine/drive_c/oracle/product/10.2.0/client_1/NETWORK/ADMIN
Run command: wine ToadforOracle105SetupFreeware.exe
Run Toad either via desktop icon or menu Applications->wine->programs->Quest Software->Toad
Ignore any “SDFConverter” error messages
When Toad pop-up for setup/config preferences – STOP, go to next step
Run command: chmod -R 777 ~/.wine/drive_c/users/bert/Application\ Data/Quest\ Software
Now resume answering the Toad pop-up for setup/config preferences
Ignore (and disable) the pop-up window for “New Version Available” (feature not tested on Linux)
Enjoy Toad on Linux!

Trackback Print

Tags: toad for oracle , freeware , linux

Categories: Toad for Oracle

Location: Blogs Parent Separator

Bert Scalzo's Blog

15 comment(s) so far...

Re: Toad 10.5 Freeware Runs on Linux

I followed your instructions and I get the following error when trying to connect to a database: Can't initialize OCI. Error -1 I am running on Ubuntu 10.04 Any ideas?

By bamiller3 on Monday, May 17, 2010 7:05 AM

Re: Toad 10.5 Freeware Runs on Linux

Toad is a 32-bit Windows app and requires a 32-bit Oracle client install - regardless of the Ubuntu or Oracle database bit size. Did you use a 32-bit Oracle client install?

By bscalzo on Monday, May 17, 2010 7:48 AM

Re: Toad 10.5 Freeware Runs on Linux

Yes, I downloaded and installed the version that you linked to in your article.

By bamiller3 on Monday, May 17, 2010 8:09 AM

Re: Toad 10.5 Freeware Runs on Linux

OK - run the following: wine regedit Make sure your PATH includes your Oracle binary (e.g.) [HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\Session Manager\Environment] PATH=C:\Oracle\product\11.2.0\client_1\bin;C:\windows\system32;C:\windows;C:\windows\system32\wbem

By bscalzo on Monday, May 17, 2010 8:17 AM

Re: Toad 10.5 Freeware Runs on Linux

PATH looks the same as yours: C:\oracle\product\10.2.0\client_1\bin;C:\windows\system32;C:\windows;C:\windows\system32\wbem

By bamiller3 on Monday, May 17, 2010 8:21 AM

Re: Toad 10.5 Freeware Runs on Linux

When you have the connection screen open - check these: Oracle home set to point to your install. Tnsnames.ora file shows a green check mark. Open Tnsnames.ora file with Toad tnsnames editor - and do a tnsping on your connection screen.

By bscalzo on Monday, May 17, 2010 8:25 AM

Re: Toad 10.5 Freeware Runs on Linux

It all looks good. tnsping said "Test succeeded"

By bamiller3 on Monday, May 17, 2010 8:30 AM

Re: Toad 10.5 Freeware Runs on Linux

I'm stumped then. This is too weird then given that tnsping passed ???

By bscalzo on Monday, May 17, 2010 8:31 AM

Re: Toad 10.5 Freeware Runs on Linux

I did notice that my Wine install is 1.1.44 and yours was 1.1.43. Could that be the issue?

By bamiller3 on Monday, May 17, 2010 8:31 AM

Re: Toad 10.5 Freeware Runs on Linux

Very possibly. I had various issues/problems with all versions prior to 1.1.43. That's why I had step #4 say check for this version.

By bscalzo on Monday, May 17, 2010 8:33 AM

Re: Toad 10.5 Freeware Runs on Linux

In fact since I wrote this wine 1.1.44 is out - and that too checks out OK.

By bscalzo on Monday, May 17, 2010 8:34 AM

Re: Toad 10.5 Freeware Runs on Linux

Then I am at a loss. Can you think of anything else I can check?

By bamiller3 on Monday, May 17, 2010 8:40 AM

Re: Toad 10.5 Freeware Runs on Linux

I'm stumped - I'll let it swim around in the back of my mind and see if any ideas come up. Can you email me offline so I can ping you if I think of anything? bert.scalzo@quest.com

By bscalzo on Monday, May 17, 2010 8:42 AM

Re: Toad 10.5 Freeware Runs on Linux

I figured out my problem. I had my $ORACLE_HOME environment variable set for my Oracle client installed on my Linux machine (for other stuff I was doing). Once I cleared that out and launched Toad, the issue was resolved.

By bamiller3 on Tuesday, May 18, 2010 3:11 AM

Re: Toad 10.5 Freeware Runs on Linux

Yes - good catch - WINE does not overwrite the Linux environment variables when called. So if ORACLE_HOME is defined on the host Linux, then that value gets passed to (and overwrites) the Windows setting - unless you manually set the Windows variables in registry editor to then override what Linux passes in. So you could do some tricky wine regedit settings to get around - but far easier to eliminate any dups :)

By bscalzo on Tuesday, May 18, 2010 3:15 AM