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: 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!

 

 

History

 

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.

 


Preface

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:

 

Terminal

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.

 

Terminal

cd ~/Downloads
filename=sqldeveloper-3.1.05.97-no-jre.zip
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.

 

Terminal

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:

 

Terminal

cd $HOME/Applications/sqldeveloper

 

Cut and past the following into the terminal window:

 

Terminal

cat > sqldeveloper.desktop <<EOF
[Desktop Entry]
Exec=$HOME/Applications/sqldeveloper/sqldeveloper.sh %U
Terminal=false
StartupNotify=true
Categories=GNOME;Oracle;
Type=Application
Icon=$HOME/Applications/sqldeveloper/icon.png
Name=Oracle SQL Developer
EOF

 

Continue as following:

 

Terminal

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.

Terminal

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

 

or switch it off:

 

Terminal

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

 


Kind regards and best of luck!

Dude.