9

How to install sql developer on lubuntu 18.04

I tried the below link from Oracle (served as installation notes when you download sql developer) but that dint work.

https://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/sqldev-install-linux-1969676.html

Error:

Error:

Oracle now provides .rpm files instead of .zip and all the answers on this site help you with the .zip but not .rpm

Amar Singh
  • 113

4 Answers4

8

The easiest way to install the Oracle SQL Developer program in all currently supported versions of Ubuntu is to install sqldeveloper-package from the default Ubuntu repositories. sqldeveloper-package makes it possible to build a Debian package of Oracle SQL Developer. This utility will require you to download the architecture independent archive from https://www.oracle.com/technetwork/developer-tools/sql-developer, identified as "Oracle SQL Developer for other platforms", "Oracle SQL Developer for Multiple Platforms" or "Oracle SQL Developer for Linux and Unix" (depending on which version you are building), to create the Debian package from.

To install sqldeveloper-package open the terminal and type:

sudo apt install sqldeveloper-package

After installing, you can use it to build sqldeveloper by typing:

make-sqldeveloper-package /path/to/arch-ind-sqldeveloper-archive

This puts the build package in an autogenerated folder. Use 

sudo make-sqldeveloper-package --install /path/to/arch-ind-sqldeveloper-archive

to directly install it on your system. You can get an overview of all commandline options with:

make-sqldeveloper-package --help

For running sqldeveloper you can connect to and use any JDK 1.8 (e.g. openjdk-8-jdk) or above.

Buurman
  • 113
karel
  • 122,292
  • 133
  • 301
  • 332
6
sudo apt-get install alien openjfx

Then:

  1. Follow the link https://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html
  2. Click "Accept license agreement" that looks like a radio button
  3. Next to "Linux RPM", click "Download" (If there is no "Linux RPM", try the previous version)
  4. Choose where you want to save the file, which will be named sqldeveloper-VERSION.noarch.rpm

  5. In terminal, cd to where you saved the RPM file

    sudo alien --scripts sqldeveloper-*.noarch.rpm
sudo dpkg -i sqldeveloper*.deb

Now you can run the program. In my case it got installed to /usr/local/bin which is in my path. The first time you run it, make sure you do so in the foreground (do not ampersand it) because it's going to ask you to type in the path to a good JDK (the path above bin, for example /usr/lib/jvm/java-8-openjdk-amd64). 

$ sqldeveloper

Et voila!

muru
  • 207,228
MartinThurn
  • 163
2

I was able to finally install SQL Developer after trying a whole bunch of things. Experts please improve this answer!

I used the Alien tool/utility/command to install SQL Developer.

the file i downloaded from oracle was

"sqldeveloper-18.2.0.183.1748-1.noarch.rpm"

i converted it .deb using Alien command

amar@amar-singh:~/Downloads$ sudo alien --scripts -d sqldeveloper-18.2.0.183.1748-1.noarch.rpm

result: sqldeveloper_18.2.0.183.1748-2_all.deb generated

do right click on the generated .deb file and select option "Software install"

this should take you to your software installer window where you can see SQL Developer being installed

once done you should now be able to run sql developer if you had previously installed JDK 8

software center

screenshot

Amar Singh
  • 113
1

I just installed SQL Developer on Ubuntu 20.04 today without either an .rpm package or make-sqldeveloper-package.

It ended up being quite straightforward:

  • Download the "Other Platforms" zip file from the Oracle download page
  • Unzip it to the place of your choice ( for example "/opt/sqldeveloper" :
    unzip sqldeveloper-*.zip -d /opt )
  • Install Java:
    sudo apt install openjdk-11-jdk
  • chmod -c +x /opt/sqldeveloper/sqldeveloper.sh (if it is not already executable)
  • That's it. Start it:
    /opt/sqldeveloper/sqldeveloper.sh

If you unzipped to another directory than /opt/, adjust the paths above.

(I basically followed this guide. If you would like to create a shortcut or add it to your path etc., see it's last chapter)

mivk
  • 5,811