I am trying to install SQL Developer on Ubuntu 14.04. I have followed some tutorials but none of them worked. So I am asking you if you know how to install SQL Developer.
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.
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
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
/opt/sqldeveloper/sqldeveloper.shand 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:
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
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)
- 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_22.214.171.124.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
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:
and extract the file to
sudo unzip sqldeveloper-*-no-jre.zip -d /opt/
Make the launch script executable:
sudo chmod +x /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:
I installed version 17.4 on Ubuntu 16.04 GNOME like so.
- Verify installation of OpenJDK 8 and location at
/usr/lib/jvm/java-8-openjdk-amd64If absent, install with
sudo apt install openjdk-8-jdk. Newer versions of Java may work as well.
- Accept license agreement and download "Other Platforms" version
- Unzip in my home directory
- Run from the commandline
~/sqldeveloper/sqldeveloper.shonce to add location of Java. Enter
Create the desktop icon for future access from my GUI menu.
# /home/USERNAME/.local/share/applications/sqldeveloper.desktop [Desktop Entry] Name=Oracle SQL Developer GenericName=SQL Developer X-GNOME-FullName=Oracle SQL Developer Comment= A free integrated development environment that simplifies the development and management of Oracle Database Keywords=sql;developer;oracle;db;database Exec=/home/USERNAME/sqldeveloper/sqldeveloper.sh Terminal=false Type=Application StartupNotify=true Icon=/home/USERNAME/sqldeveloper/icon.png Categories=Admin X-AppStream-Ignore=true
Make the desktop file executable
chmod +x /home/USERNAME/.local/share/applications/sqldeveloper.desktop
I installed oracle sqldeveloper in ubuntu 17.10 using the following method:
- Accept license agreement and download oracle linux rpm: http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html
sudo apt-get install alien
Install the rpm using alien:
sudo alien -i sqldeveloper-126.96.36.1999.0537-1.noarch.rpm
Run sql developer by using the following command in the terminal
Make sure to change the version of your rpm. For this to be successful you have to have oracle java 8 or above installed in your machine.
protected by Community♦ Sep 26 '14 at 23:15
Thank you for your interest in this question.
Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).
Would you like to answer one of these unanswered questions instead?