How to install SQL Developer on Ubuntu 14.04?
I installed SQL Developer with these steps:
(See the comments—this might not be necessary)
Download and re-install newest Ubuntu 14.04 LTS from Ubuntu website.Install Java:
Java Version JDK 7:
sudo apt-get install openjdk-7-jdk openjdk-7-jre icedtea-7-plugin sudo update-alternatives --config java
Java Version JDK 8 (in some installations this is a requirement instead of 1.7):
sudo add-apt-repository ppa:webupd8team/java sudo apt-get update sudo apt-get install oracle-java8-installer sudo update-alternatives --config java
Download SQL Developer from Oracle website (I chose Other Platforms download).
Extract file to
/opt
:sudo unzip sqldeveloper-*-no-jre.zip -d /opt/ sudo chmod +x /opt/sqldeveloper/sqldeveloper.sh
Linking over an in-path launcher for Oracle SQL Developer:
sudo ln -s /opt/sqldeveloper/sqldeveloper.sh /usr/local/bin/sqldeveloper
Edit
/opt/sqldeveloper/sqldeveloper.sh
and replace it's content to:#!/bin/bash unset -v GNOME_DESKTOP_SESSION_ID cd /opt/sqldeveloper/sqldeveloper/bin ./sqldeveloper "$@"
or (to prevent error:
./sqldeveloper: Permission denied
)#!/bin/bash unset -v GNOME_DESKTOP_SESSION_ID cd /opt/sqldeveloper/sqldeveloper/bin && bash sqldeveloper $*
Run SQL Developer:
sqldeveloper
Note: When you run Sql Developer at the first time, you need to specify the path of JDK's folder. In my computer, JDK stored at /usr/lib/jvm/java-1.7.0-openjdk-amd64 For Java 8 and Ubuntu 16+ /usr/lib/jvm/java-8-oracle
Finally, create desktop application for easy to use:
cd /usr/share/applications/ sudo vim sqldeveloper.desktop
add this lines:
[Desktop Entry] Exec=sqldeveloper Terminal=false StartupNotify=true Categories=GNOME;Oracle; Type=Application Icon=/opt/sqldeveloper/icon.png Name=Oracle SQL Developer
then type:
sudo update-desktop-database
Here's how I did it on Ubuntu, I think this is the easiest way and will give you a package that you can easily reuse later (but you can't redistribute according to OTN license):
- Downlod the sql developer package from here.
Install the sql developer package as the following.
sudo apt-get install sqldeveloper-package debhelper openjdk-7-jdk openjdk-7-jre icedtea-7-plugin
Now all what you need to do is to run the command (you might have a different version)
make-sqldeveloper-package sqldeveloper-4.1.3.20.78-no-jre.zip
- This will generate a debian package that you can use to install sql developer.
Now install the resulting .deb package using the command (Your deb might have a different version too):
sudo dpkg -i sqldeveloper_4.1.3.20.78+0.2.4-1_all.deb
You're now done with the installation. in my case it needed the new java 8 then you will need to run the following commands.
sudo add-apt-repository ppa:webupd8team/java sudo apt-get update sudo apt-get install oracle-java8-installer
Finally you need to provide the java path for oracle sql developer at the first run in my case it was at
/usr/lib/jvm/default-java/
.
Install Java 6. (It didn't work for me with Java 1.7):
sudo add-apt-repository ppa:webupd8team/java sudo apt-get update sudo apt-get install oracle-java6-installer
Download the SQL Developer from here and choose Other platforms. (You'll need an account in order to download it). Open the Downloads directory:
cd ~/Downloads
and extract the file to
/opt
:sudo unzip sqldeveloper-*-no-jre.zip -d /opt/
Make the launch script executable:
sudo chmod +x /opt/sqldeveloper/sqldeveloper.sh
Open sqldeveloper:
sudo /opt/sqldeveloper/sqldeveloper.sh
The first time you'll be asked to enter the jvm location. In my case (and probably yours if you have followed the first step), the location is:
/usr/lib/jvm/java-6-oracle
.