If you search for Oracle GUI Clients in Google, you turn up with nothing. After some more hunting, I found TOAD. I have been using the Free version of TOAD for a few weeks now but it is very annoying and has to be updated often. Also it can only make one connection at a time. The price of the full version > 800$!!
That’s an outrage, especially for us MySQL folks who can get SQLYog for free (which works perfectly well in Linux with wine).

A few days back I installed Ubuntu 7.04 on a new computer at work and was hunting for an Oracle client and I found TOra, an open source Oracle Client. I still haven’t got it connecting to Oracle from Ubuntu and the Windows version won’t even run. Hunting for ways to make it work, I found SQL Developer – which is made by Oracle themselves and is free. If only Oracle would have mentioned this on the download page for InstantClient, it would have saved me a few hours of searching, tinkering and complaining about a lack of choice in Oracle clients.

SQLDeveloper is a cross platform Java Oracle client and it is free and does everything that TOAD does as far as I can tell. No more TOAD for me.

2 thoughts on “Oracle GUI Clients

  1. Hi,
    did you manage to install SQL Developer on ubuntu 10?

    thanks.

  2. Yes it installed on 7.10 but I was unable to test it because we use Rainbow iKeys to connect to Oracle via VPN and those don’t work on Linux. Also it is a PITA to get Cisco VPN client working on Ubuntu anyway.

    I couldn’t install Oracle on the machine itself because of some issue with the amount of Swap space. Then I got involved in several other projects and never bothered to try it on Linux again.

Leave a Reply