Install Oracle SQL Developer on Ubuntu/Debian
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.
Install Oracle SQL Developer on Ubuntu/Debian · GitHub
Instantly share code, notes, and snippets.
-
Install alien and OpenJDK 11
sudo apt install alien openjdk-11-jdk
-
Download SQL Developer >= 19.2
https://www.oracle.com/tools/downloads/sqldev-downloads.html- Download the Linux RPM
-
Install SQL Developer
Note: This might take several minutes
sudo alien -i sqldeveloper-*.rpm
-
(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
-
(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
-
(Optional) Disable unnecessary features
-
Tools > Features
-
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
-
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
@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.
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
@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
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK