1. Overview

SQL Developer is a free-to-use IDE (Integrated Development Environment) that enables us to perform operations using SQL in Oracle databases. It makes use of the JDK (Java Development Kit) and is available on Windows, Linux, and Mac.

In this tutorial, we’ll go through the step-by-step process of installing SQL Developer on Linux.

Notably, we’re going to perform this operation on Ubuntu. However, the same process applies to other distributions as well.

2. Downloading Prerequisites

In this section, we’ll see how to download the prerequisites for SQL Developer installation:

  • JDK
  • SQL Developer

Since SQL Developer uses JDK, we also have to install the latter on the machine to successfully run the SQL Developer application.

2.1. Downloading JDK

To download JDK, we go to the official Java downloads page. Then, we need to download the package that’s appropriate for our distro. In this case, we’ll go with the jdk-21_linux-x64_bin.deb package:

Downloading JDK

Once the download is complete, let’s go ahead and download SQL Developer on the system.

2.2. Downloading SQL Developer

To download SQL Developer, we go to the official SQL Developer downloads page. Then, we download the package that’s supported on our distro. In this case, let’s go with the one that’s listed under Other Platforms:

Downloading SQL Developer

So, we’ve successfully downloaded the prerequisites and now it’s time to move on to the next section.

3. Installation

We’ll go through the process of installing SQL Developer on the machine. Before that, let’s install JDK on the system to ensure a smooth SQL Developer installation process.

3.1. Installing JDK

Firstly, let’s navigate to the directory where the downloaded JDK package is stored, i.e., /usr:

$ cd /usr

Before installing JDK, let’s note the name of the package. In this case, the package name is jdk-21_linux-x64_bin.deb.

Next, let’s install JDK on the machine:

$ sudo dpkg -i jdk-21_linux-x64_bin.deb

The dpkg command extracts the contents of the specified .deb package to the current directory. Then, the -i option, short for –install, installs JDK on the system.

After installing JDK, we note its path for future use. It’s usually stored in /usr/lib/jvm.

Finally, let’s see how to install SQL Developer on the same system.

3.2. Installing SQL Developer

We again start by navigating to the directory where the downloaded SQL Developer package is stored, i.e., /usr:

$ cd /usr

After that, we note the package name for installation purposes, sqldeveloper-23.1.1.345.2114-no-jre.zip in this case.

Let’s now use the unzip command to extract the contents of the specified .zip package to the current directory:

$ sudo unzip sqldeveloper-23.1.1.345.2114-no-jre.zip

Upon extracting, let’s go to the newly extracted directory named sqldeveloper, which contains all the components required to run SQL Developer:

$ cd sqldeveloper

The final step is to execute the sqldeveloper.sh file located in the sqldeveloper directory:

$ ./sqldeveloper.sh

Now, we should get a prompt asking us to enter the full path of a JDK installation. Since we already noted the same for the JDK installation on the system, we can type it in the terminal:

Default JDK not found
Type the full pathname of a JDK installation (or Ctrl-C to quit), the path will
be stored in /home/23.1.1/product.conf
/usr/lib/jvm/jdk-21-oracle-x64

As we can see above, the full path is /usr/lib/jvm/jdk-21-oracle-x64 in this case.

After hitting Return, the SQL Developer application should show up on the screen.

4. Conclusion

In this article, we discussed how we can install SQL Developer on a Linux machine.

We not only went through the step-by-step SQL Developer installation process but also learned how to install JDK, a necessary component for running the SQL Developer application.

Comments are closed on this article!