Install Oracle SQL Developer on Ubuntu (and Debian?)

install-oracle-sql-developer.md

1. Install alien and OpenJDK 11

   sudo apt install alien openjdk-11-jdk
   

   ⚠ For Debian, this may require alien >= 8.95.5. See this comment for more information.

2. Download SQL Developer >= 19.2
   https://www.oracle.com/tools/downloads/sqldev-downloads.html

   • Download the Linux RPM

3. Install SQL Developer

   Note: This might take several minutes

   sudo alien -i sqldeveloper-*.rpm
   

4. (Optional) Disable the welcome page

   • If the welcome page shows, just scroll to the bottom and uncheck Show on startup
   • Otherwise, see here: https://stackoverflow.com/a/56484279/399105

5. (Optional) Create a desktop entry

   echo "[Desktop Entry]
   Type=Application
   Name=Oracle SQL Developer
   Exec=sqldeveloper
   Icon=/opt/sqldeveloper/icon.png
   Terminal=false" >> ~/.local/share/applications/sqldeveloper.desktop
   

6. (Optional) Disable unnecessary features

   1. Tools > Features

   2. Uncheck everything that's not needed

      For example, for minimal non-DBA development tasks, the following features are sufficient and everything else (including Database Migrations and Version Control) can be unchecked:

      - Oracle SQL Developer - Schema Browser
      - Oracle SQL Developer - Snippet
      - Oracle SQL Developer - SSH Support
      - Oracle SQL Developer - XML Schema
      

   3. Apply Changes

Hi every one,

I am facing quite the same issue trying to install sqldeveloper-21.4.2-018.1706.noarch.rpm. It fails with both alien or rpm commands.
Here is the trace:

warning: RPM v3 packages are deprecated: sqldeveloper-21.4.2-018.1706.noarch
Package build failed. Here's the log:
dh binary
dh_update_autotools_config
dh_autoreconf
create-stamp debian/debhelper-build-stamp
dh_testroot
dh_prep
debian/rules override_dh_auto_install
make[1] : on entre dans le répertoire « /home/xxx/sqldev/sqldeveloper-21.4.2 »
mkdir -p debian/sqldeveloper
# Copy the packages's files.
find . -maxdepth 1 -mindepth 1 -not -name debian -print0 |
sed -e s#'./'##g |
xargs -0 -r -i cp -a ./{} debian/sqldeveloper/{}
make[1] : on quitte le répertoire « /home/xxx/sqldev/sqldeveloper-21.4.2 »
dh_installdocs
dh_installchangelogs
dh_perl
dh_usrlocal
dh_usrlocal: error: debian/sqldeveloper/usr/local/bin/sqldeveloper is not a directory
make: *** [debian/rules:7 : binary] Erreur 25

Did someone figured out how to deal with it ?

I am on Debian 11.

Cheers

Well, just extract the package and run opt/sqldeveloper/sqldeveloper.sh works fine ;)

@lobtx Wtf, i don't understand how the solution was so easy .I was 40 min search the solution

@AgustinArroyos me too !!!

guys my friend helped me and the more easy option was install using "wine".

@Grelo4ka @Nishant0073 @lobtx @AgustinArroyos @Cavalari0100

I'm still using these steps to this day to install SQL Developer on the latest Ubuntu LTS (22.04). So it seems this bug must be specific to Debian.

I did some searching, and it sounds like Debian has something called dh_userlocal (dh = "Debian helper?") that kicks in when packages try to install files under /usr/local:

• dh_usrlocal: ... is not a directory
• Why is dh_usrlocal throwing a build error?

As best as I can tell, this causes issues with alien as per this bug: Bug#992188: alien: Fails to create packages that place files in /usr/local

If that's the case, then it appears to have been fixed in alien v8.95.5, based on the changelog: https://debian.pkgs.org/sid/debian-main-amd64/alien_8.95.6_all.deb.html

So for anyone else running into this issue on Debian, you may want to upgrade alien first. I'll add a note to the steps in case this fixes it.

For today, the debian bullseye version is 8.95.4 and fails.
I believe that the version 8.96.6 is only available in sid repository.

What I done was:

apt remove --purge alien
wget --quiet -O /tmp/alien.deb http://ftp.de.debian.org/debian/pool/main/a/alien/alien_8.95.6_all.deb
dpkg -i /tmp/alien.deb

Then, use alien to convert to deb package

Thanks for discussion. While the solution proposed by @lobtx works fine, @sgtcortez is right and updating alien package to version 8.95.6 allows to convert the .rpm package do .deb without encountering the dh_usrlocal: error bug. Happy database modeling