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

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

Dude! Guru
Currently Being Moderated

Author: Dude

Please note:


This information is presented under the terms of using the Oracle Web sites: 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: 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

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/


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/ %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!