4 Replies Latest reply: Aug 13, 2013 9:19 PM by Dude! Branched to a new discussion. RSS

    Oracle SQL Developer 3.x on Linux Ubuntu 11.10 how-to


      Author: Dude

      Please note:


      This information is presented under the terms of using the Oracle Web sites: http://www.oracle.com/us/legal/terms/index.html. You may use it for the purpose of reference, presentation or education, provided it is not redistributed under a different name or author, and available for free and not for profit. Any other use will require my explicit permission. This information is presented in the hope that it will be helpful. Use at your own risk.


      Should you experience problems with these instructions, please feel free to add a note with the link to your own discussion. However, please do not use this thread to troubleshoot or explain your issues. Thanks!





      26-Oct-2011: First release.
      30-Nov-2011: Cosmetic changes.
      14-Aug-2013: Correcting formatting issues due to forum update. Some text changes.

      05-Sep-2013:  Correcting line endings to avoid cut and paste issues with blank lines (Firefox).

                                  Adding note about installing on 32-bit (i386) OS.



      This document outlines step by step instructions how to install Oracle SQL-Developer 3.x on Ubuntu 11.10 and has been tested using Oracle SQL-Developer 3 (Production) and 3.1 (Early Adapter).



      Topics overview

      1. Install Linux Ubuntu
      2. Install Java JDK
      3. Install Oracle SQL Developer
      4. Configure Path to Java
      5. Create Unity Launcher
      6. Troubleshooting

      1. Install Linux Ubuntu


      The following assumes you have installed Ubuntu 11.10 Desktop Edition for 32-bit or 64-bit, or upgraded from a previous version. You can download Ubuntu for free at: http://www.ubuntu.com/download/ubuntu and install it using the default settings provided.

      Note: You should apply the latest OS patch-sets by clicking the power button icon in the upper right hand corner of the screen and selecting "Software Up To date & Check" or "Updates available..."

      2. Install Java JDK

      Oracle SQL Developer requires Java SDK. Open a Terminal command prompt (Ctrl-Alt-t) and enter the following:



      sudo apt-get install openjdk-6-jdk


      3. Install Oracle SQL Developer

      Download Oracle SQL Developer for other platforms from http://otn.oracle.com/developer-tools/sql-developer/downloads.

      Then enter the following commands:

      Note: You may need to change filename according to the current available version.



      cd ~/Downloads
      unzip $filename -d $HOME/Applications
      rm $file
      chmod 750 $HOME/Applications/sqldeveloper/sqldeveloper.sh


      4. Configure Path to Java

      SQL-Developer needs to know how to find your Java Developer Kit:


      Note: You need to specify /usr/lib/jvm/java-6-openjdk-i386 on 32-bit OS installations.



      cd $HOME
      mkdir -p .sqldeveloper
      cd $HOME/.sqldeveloper
      echo "/usr/lib/jvm/java-6-openjdk" > jdk


      5. Create Unity Launcher

      Cut & paste the following into a terminal command prompt in order to register the SQL Developer Launcher:



      cd $HOME/Applications/sqldeveloper


      Cut and past the following into the terminal window:



      cat > sqldeveloper.desktop <<EOF
      [Desktop Entry]
      Exec=$HOME/Applications/sqldeveloper/sqldeveloper.sh %U
      Name=Oracle SQL Developer


      Continue as following:



      sudo cp sqldeveloper.desktop /usr/share/applications
      sudo update-desktop-database


      You can create a SQL Developer Launcher icon on your Desktop by selecting the Ubuntu Logo icon, located at the top of the Unity dock, then type "sql" in the search field and drag the found icon to your desktop.

      6. Troubleshooting

      The following allows to activate or deactivate terminal output in order to troubleshoot SQL Developer.


      sed -i 's/Terminal=false/Terminal=true/g' ~/Desktop/sqldeveloper.desktop


      or switch it off:



      sed -i 's/Terminal=false/Terminal=false/g' ~/Desktop/sqldeveloper.desktop


      Kind regards and best of luck!