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 have the same question!– PhatHVMay 4, 2014 at 17:17
-
Finally, I can install SQL Developer. See my answer.– PhatHVMay 5, 2014 at 7:06
-
What tutorials? How did they "not work"? Please show us what you did and what the result is.– terdonMay 5, 2014 at 9:22
-
This one worked for me: oracle-noob.blogspot.com/2014/01/…– Eric WilsonJul 15, 2014 at 18:21
-
when I am trying to perform last step i.e., run sqldeveloper below error gk@gk-desktop:/usr/local/bin$ ./sqldeveloper ./sqldeveloper: line 3: ./sqldeveloper: Permission denied Any solution to over come?– girishkumarJul 20, 2014 at 18:51
5 Answers
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
-
12"Download and re-install newest Ubuntu 14.04 LTS from Ubuntu website" why do I need to remove my operating system to install a package?– RinzwindMay 5, 2014 at 7:09
-
1@PhatHV When i run sqldeveloper in terminal I get /usr/local/bin/sqldeveloper: line 2: cd: /usr/local/bin/sqldeveloper/bin: Not a directory May 7, 2014 at 7:51
-
1I tried many other tutorial like you. But I gave you what steps I did to make my SQL Developer works (I installed it on my machine at office and it works perfect until now). I thinks you should check the content of this file "/opt/sqldeveloper/sqldeveloper.sh" and paste it here.– PhatHVMay 7, 2014 at 10:41
-
2
-
2
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/
.
-
Please note on Ubuntu the latest version of
sqldeveloper-package
is broken; failing withdebuild: fatal error at line 1124: dpkg-buildpackage -rfakeroot -us -uc binary failed
This can be fixed withsudo sed -i '/DEBUILD/s/n b/n --no-tgz-check -- b/' /usr/bin/make-sqldeveloper-package
– RqomeyFeb 19, 2018 at 12:09
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-amd64
If absent, install withsudo 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.sh
once to add location of Java. Enter/usr/lib/jvm/java-8-openjdk-amd64
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
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
.
-
Is this working for you? or did you install Sql developer from following your accepted answer or your own answer? because I want to install Sql developer for myself. thanks– αғsнιηAug 26, 2014 at 4:40
-
-
Instead of the 4. step, you can add the /opt/sqldeveloper/sqldeveloper/bin to the PATH in the /etc/environment. Then you can use the sqldeveloper command from the terminal. Nov 17, 2015 at 23:39
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
Install alien:
sudo apt-get install alien
Install the rpm using alien:
sudo alien -i sqldeveloper-17.3.1.279.0537-1.noarch.rpm
Run sql developer by using the following command in the terminal
sqldeveloper
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.