-
Install alien, OpenJDK 11, and OpenJFX
sudo apt install alien openjdk-11-jdk openjfx
-
Download SQL Developer >= 19.2
https://www.oracle.com/tools/downloads/sqldev-downloads.html- Download the Linux RPM
-
Install SQL Developer
sudo alien -i sqldeveloper-*.rpm
-
Open SQL developer in the terminal to set the path to the JDK
$ /usr/local/bin/sqldeveloper Type the full pathname of a JDK installation (or Ctrl-C to quit), the path will be stored in /home/user/.sqldeveloper/19.4.0/product.conf /usr/lib/jvm/java-11-openjdk-amd64/
-
(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
-
-
Install Java
-
Download the latest .deb for Coretto Java 8 here: https://docs.aws.amazon.com/corretto/latest/corretto-8-ug/downloads-list.html
(This is needed because SQL Developer only supports Java 8 with JavaFX, and Amazon Coretto is the only free version of Java 8 that includes JavaFX)
-
Install the package
sudo dpkg -i java-1.8.0-amazon-corretto-jdk*.deb
-
-
Install alien
sudo apt install alien
-
Download SQL Developer https://www.oracle.com/tools/downloads/sqldev-downloads.html
- Download the Linux RPM
-
Install SQL Developer
sudo alien -i sqldeveloper-*.rpm
-
Open SQL developer in the terminal to set the path to the JDK
$ /usr/local/bin/sqldeveloper Type the full pathname of a JDK installation (or Ctrl-C to quit), the path will be stored in /home/user/.sqldeveloper/19.1.0/product.conf /usr/lib/jvm/java-1.8.0-amazon-corretto
-
(Optional) Create a desktop entry
(See above)
-
(Optional) Disable unnecessary features
(See above)