I’ve installed Ubuntu to my laptop (another try to live with Linux), and now trying to organize useful stuff. I wanted to install Oracle SQL Developer and couldn’t find an up-to-date document about it, so decided to write one (which will be use most straight forward steps).

First we download Oracle SQL Developer from Oracle website. You know Ubuntu uses Debian’s package manager: APT. So we should download the zip file (distributed for “Other Platforms”) instead of RPM file.

After the download completed, just extract it to a directory. Your home directory would be fine. To extract, you can use the archive manager (integrated to file manager): after moving the file to your home directory, right click over the file and select extract. Or you can just use “unzip” command.

You should see a new directory called “sqldeveloper”. When you enter into the directory, you’ll see a file named “sqldeveloper.sh”. Although the sqldeveloper.exe file looks like the right one (with its shiny icon), we’ll use the “shell” script version :)

makeitexecutable

Right click on the file name, select “properties” and make it executable or you can just use “chmod +x sqldeveloper.sh” on terminal. If you do not have JDK (java development kit) installed on your system (most users just have JRE/java runtime environment), install jdk:

Then go to jvm folder and check if jdk is installed successfully and learn the exact path of jdk:

Somehow I have also java-7, but I’ll use java 6 because Oracle SQL Developer is compatible with java 6. So the jdk path will be “/usr/lib/jvm/java-6-openjdk-amd64″.

You probably prefer to run Oracle SQL Developer by clicking on its icon, so I’ll create a desktop icon for it. It’s easier to do it using terminal. Open terminal and run the vi editor:

Enter the following lines (do not forget to fix the paths – I marked them on the below script):

Save it (:wq) and then it’s ready to run?! Well, not yet! Because Oracle SQL Developer will ask us to enter the correct path of the jdk. It will ask it twice. On first run, it won’t be able to find a directory to store the jdk settings. Although it’ll create that directory, you need to re-run the SQL Developer and enter the path of jdk again, then it’ll save the settings successfully. Probably this is just a bug and will be fixed on future versions. After SQL Developer stops asking the java path, you may modify the desktop file and remove the terminal=true line. So it will not open a terminal window whenever you click it. I prefer to keep it so I can also see the error/alert messages produced by Oracle SQL Developer.

5 Responses to “How to Install Oracle SQL Developer on Ubuntu”

  1. Hi Gokhan,
    Good post thanks for sharing…I explain my experience about.
    I installed Ubuntu 12.04 and Oracle SQLdeveloper 3.2.20.09 and I had to install Oracle Java 1.7.0_25-b15 (Java 7 update 25), because with OpenJava, I don’t remember now exactly the last version, not working
    For example when I tried to right-click on a procedure and after press OK button in Sqldeveloper, nothing happened.
    After there were some other features in Debugger that did not work well, but since I installed java 7 all these problems are gone.

    HTH

    Ciao

    Alberto

  2. Hi Gokhan,
    I have a “good “news for my last Java update….

    here the details …if you want to laugh

    http://albertofrosi.blogspot.it/2013/10/java7-update40-sql-developer-ubuntu.html

    HTH

    Ciao

    Alberto

  3. How do you run this when you have it installed per your instructions?  at the prompt I type:

    >> jdc:~/Apps/sqldeveloper$ sqldeveloper
    sqldeveloper: command not found

    • Gokhan Atil says:

      John, if you want to launch the SQL Developer on command line, you need to run “sqldeveloper.sh”. Don’t forget to make it executable (explained in the post):

      chmod +x sqldeveloper.sh
      ./sqldeveloper.sh

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">