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
Install Linux UbuntuInstall Java JDKInstall Oracle SQL DeveloperConfigure Path to JavaCreate Unity LauncherTroubleshooting
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.