How to install SQL Developer on Ubuntu!

How to install SQL Developer on Ubuntu!

Written by Adam. R on Sep 13th, 2021 ・ Views ・ Report Post

Adam. R Visit User Profile

What is SQL Developer?

SQL Developer provides powerful editors for working with SQL, PL/SQL, Stored Java Procedures, and XML. Run queries, generate execution plans, export data to the desired format (XML, Excel, HTML, PDF, etc.), execute, debug, test, and document your database programs, and much more with SQL Developer.

Prerequisite(s)

  • JDK 8/11

Downloading Prerequisite

Oracle JDK 8/11

  1. Go to download Oracle JDK page

  2. I will use Oracle JDK 11 because it has a .deb installation file which can be easily installed using dpkg jdk download.png

  3. Download Oracle JDK 11 for Debian package (at the time of this post, the version is 11.0.8), you will be prompted to sign in using oracle account to download, you will be prompted to sign in using oracle account to download jdk 11 .deb.png

Oracle SQL Developer

  1. Go to [download Oracle SQL Developer page](download Oracle SQL Developer page)
  2. Download Oracle SQL Developer for Other Platforms (at the time of this post, the version is 20.2) sql dev install other platform.png

Prerequisite Completed

download folder sql dev.jfif

Installation

Install Oracle JDK 11 and Oracle SQL Developer

Oracle JDK 11

  1. Open your terminal, go to directory where your prerequisite files are located (in my case it's in ~/Downloads)
  2. Install Oracle JDK 11 by using command:
sudo dpkg -i [YOUR_ORACLE_JDK_PACKAGE.deb], in my case it's sudo dpkg -i jdk-11.0.8_linux-x64_bin.deb
  1. Verify your installation by listing the directory of /usr/lib/jvm

Oracle SQL Developer

  1. Open your terminal, go to /opt directory. This is where i will store the sqldeveloper application, you can choose other directory, but this my preference (and i read also that /opt is for 3rd party apps that we cannot install via apt package manager)
  2. Unzip Oracle SQL Developer with command
sudo unzip [YOUR_SQL_DEVELOPER_FILE_WITH_LOCATION].zip,

By default the unzip program will extract the zip file into the current directory, since we are in /opt now, we don't need to specify target directory. 3. Locate your Oracle JDK installation under /usr/lib/jvm, we'll need this location to tell Oracle SQL Developer where our Oracle JDK is located. In my case it's /usr/lib/jvm/jdk-11.0.8 4. Go inside the sqldeveloper directory 5. You can see that sqldeveloper.sh has executable permission so that we can run it by doing ./sqldeveloper.sh or sh sqldeveloper.sh in the current directory. 6. You will see Oracle SQL Developer starting sql dev starting.jfif

🤩 Our Amazing Sponsors 👇
DigitalOcean View Website
DigitalOcean offers a simple and reliable cloud hosting solution that enables developers to get their website or application up and running quickly.
Laravel News View Website
Laravel News keeps you up to date with everything Laravel. Everything from framework news to new community packages, Laravel tutorials, and more.
Genesis View Website
A Laravel Starter Kit that includes Authentication, User Dashboard, Edit Profile, and a set of UI Components.

That’s it, you have successfully installed SQL Developer on your Ubuntu Device and you can start using it!

If you found this usful then please comment and follow me! Also check out my website where I also post everything from here

Comments (0)