Installing Oracle SQL Developer on Ubuntu


Update: As I switched to Linux Mint, I ran into an permission problem. To have it working, follow the procedure available at http://community.linuxmint.com/tutorial/view/938, which provides additional steps.


On my current project, we use Oracle database. The best free tool I have found so far to work with the database as a Java developer is Oracle SQL Developer.

Oracle does not provide a package for Debian based distros. I tried to run the tool from the generic archive but it failed to run because it seems to be aiming at another environment with respect to the Swing look and feel that it failed to load.  After some googling, I found that there is a package to make a package (sqldeveloper-package)out of the archive to make it installable as such.

Here is how to use it.

Download Oracle SQL Developer

As the download requires that one have an Oracle account, I download it from the browser at the following address: http://www.oracle.com/technetwork/developer-tools/sql-developer/sqldev-ea-download-486950.html

Install Java

See my post Install Sun JDK 6 on Ubuntu 11.10

Install the sqldeveloper-package and its dependencies

$ sudo apt-get install sqldeveloper-package debhelper

 Install dos2unix

$ sudo apt-get install tofrodos

It is necessary to create the following symlinks for the tool to work:

$ sudo ln -s fromdos dos2unix
$ sudo ln -s todos unix2dos

Make the deb package

It seems that the -b switch can be used to indicate where to generate the .deb but it does not seem to work (Or I did not spend enough time trying to get it to work). The tool will generate the .deb in the working directory.

$ cd ~/Downloads
$ make-sqldeveloper-package ~/Downloads/sqldeveloper-3.1.06.44-no-jre.zip

Install the package

$ sudo dpkg -i sqldeveloper_3.1.06.44+0.2.3-1_all.deb

The tool is now available in Applications->Programming->Sql Developer

About these ads

8 Responses to Installing Oracle SQL Developer on Ubuntu

  1. Tushar Kumar says:

    Good article

  2. sim says:

    Useful tutorial — thanks. Slight typo: “dbhelper” should read “debhelper”. For some reason I didn’t need to do the symlinks step.

  3. Phil says:

    Install the “alien” package, then alien –scripts -i /tmp/sqldeveloper-3.2.10.09.57-1.noarch.rpm
    Worked right away :)
    PS: Remember to install the JDK (same method) before.

    • Stephan says:

      Thanks for the suggestion. I did not know about that package. However, the documentation of that package says

      “This is not the recommended way to install software packages in Ubuntu. If at all possible, install packages from Ubuntu’s repositories using Add/Remove, apt-get, ”

      How reliable is that tool?

  4. frank says:

    error:
    ~/Descargas$ make-sqldeveloper-package ~/Descargas/sqldeveloper-3.1.06.82-no-jre.zip
    chmod: falta un operando después de «755»
    Pruebe `chmod –help’ para más información.

    any ideas?

  5. Pingback: Confluence: Engineering

  6. HariKrishna says:

    Good Article.. Worked

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

Follow

Get every new post delivered to your Inbox.

Join 163 other followers

%d bloggers like this: