9

Install Oracle SQL Developer on Ubuntu/Debian

 2 years ago
source link: https://gist.github.com/bmaupin/ad02e5b4a17abfc662d61664bced2773
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
neoserver,ios ssh client

Install Oracle SQL Developer on Ubuntu/Debian · GitHub

Instantly share code, notes, and snippets.

Install Oracle SQL Developer on Ubuntu/Debian
  1. Install alien and OpenJDK 11

    sudo apt install alien openjdk-11-jdk
    
  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

  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

sudo alien -i sqldeveloper-*.rpm fails

dh_usrlocal: error: debian/sqldeveloper/usr/local/bin/sqldeveloper is not a directory make: *** [debian/rules:7: binary] Error 25

Debian 11, sqldeveloper-21.4.0-346.2239.noarch.rpm

Copy link

Author

bmaupin commented on Dec 14, 2021

@Grelo4ka I just noticed that I wrote "Ubuntu/Debian" in the description of this gist. I guess I assumed it would work for Debian since Ubuntu is based on Debian, but I've not tested it on Debian. I should probably remove that :)

On the other hand, it looks like Ubuntu 20.04 is based on Debian 11? So maybe that's not the problem:

$ lsb_release -a
No LSB modules are available.
Distributor ID:	Ubuntu
Description:	Ubuntu 20.04.3 LTS
Release:	20.04
Codename:	focal
$ cat /etc/debian_version
bullseye/sid

I used these steps successfully last week to install SQL Developer 21.2.1 on Ubuntu 20.04; I guess you could try installing an older version of SQL Developer to see if it works.

If you figure out the problem with the newer versions feel free to leave a comment and I can update this gist.

Good luck!

I am also facing same error while installing sqldeveloper-21.4.0-346.2239.noarch.rpm on debian 11.

 error: debian/sqldeveloper/usr/local/bin/sqldeveloper is not a directory
make: *** [debian/rules:7: binary] Error 25

I have also tried to install sqldeveloper-19.1.0-094.2042.noarch but it also gives same error.

Copy link

lobtx commented on Jan 28

edited

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

Copy link

lobtx commented on Jan 28

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment


About Joyk


Aggregate valuable and interesting links.
Joyk means Joy of geeK