October 21, 2021
How to install Oracle SQL Developer on Rocky Linux

How To Install Oracle SQL Developer On Rocky Linux 8

On this article we will learn how to install Oracle SQL Developer Version 21.2.1.204.1703 which was released on August 11, 2021 on Rocky Linux 8 (Desktop) version.

Introduction

If we are a developer or Oracle DBA administrator, we must be familiar with this database tools, namely: Oracle SQL Developer. Oracle SQL Developer is a free, integrated development environment that simplifies the development and management of Oracle Database in both traditional and Cloud deployments. SQL Developer offers complete end-to-end development of PL/SQL applications, a worksheet for running queries and scripts, a DBA console for managing the database, a reports interface, a complete data modeling solution, and a migration platform for moving your 3rd party databases to Oracle. On this article we will learn how to install SQL Developer on Rocky Linux 8.



SQL Developer Core Features :

  • Supports Oracle Database, versions 11gR2, 12c, 18c, 19c, 20c
  • Supports Oracle Database in the Oracle Cloud and On-Premises
  • Query, load, and extract data
  • Easy installation, no Oracle Client required

Oracle SQL Developer Installation On Rocky Linux 8

SQL Developer installation will consist of several stages, namely:

  1. Prerequisites
  2. Download Oracle SQL Developer Source
  3. Extract Source File
  4. Configure and Run SQL Developer

Prerequisite

  • Rocky Linux 8 system
  • Java 8 or 11 installed on the system
  • Root or ordinary user with sudo privilege

When the article is creating, we have three Java version on the system : Java 8, Java 11 and Java 16. The latest Oracle SQL Developer (version 21.2.1) will only run on Java 8 or Java 11, even though we have a higher version of Java, namely Java 16.

[ramansah@otodiginet ~]$ sudo alternatives --config java
[sudo] password for ramansah: 

There are 4 programs which provide 'java'.

  Selection    Command
-----------------------------------------------
   1           java-1.8.0-openjdk.x86_64 (/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.302.b08-0.el8_4.x86_64/jre/bin/java)
   2           java-11-openjdk.x86_64 (/usr/lib/jvm/java-11-openjdk-11.0.12.0.7-0.el8_4.x86_64/bin/java)
*  3           /usr/java/jdk-16.0.2/bin/java
 + 4           /opt/jdk-16.0.2/bin/java

Download Oracle SQL Developer

The next step is to download the source of Oracle SQL Developer from Oracle official website. The URL will be on https://www.oracle.com/tools/downloads/sqldev-downloads.html and select Linux RPM option to be downloaded. But before download is continue we will be asked to fill the Oracle account.

Oracle SQL Developer Download official website
Oracle SQL Developer Download official website

We will download the SQL Developer source file for Linux RPM distribution (Redhat, CentOS, Rocky Linux, Alamalinu).

Extract SQL Developer File

Once, the download was completed, the default directory will be on /home/<username>/Downloads. Before extracting the file, we will create a new directory under /opt and name it as sqldeveloper. Then we extract the rpm file by typing the command line : sudo rpm -Uhv sqldeveloper-21.2.1-204.1703.noarch.rpm. The task series will be :

  1. cd /home/ramansah/Downloads/ (Change ramansah to be yours)
  2. sudo mkdir /opt/sqldeveloper/
  3. sudo rpm -Uhv sqldeveloper-21.2.1-204.1703.noarch.rpm
ramansah@otodiginet ~]$ cd /home/ramansah/Downloads/
[ramansah@otodiginet Downloads]$ ls -ltr
total 346564
-rw-rw-r-- 1 ramansah ramansah 354879020 Sep  9 14:57 sqldeveloper-21.2.1-204.1703.noarch.rpm
[ramansah@otodiginet Downloads]$ sudo rpm -Uhv sqldeveloper-21.2.1-204.1703.noarch.rpm
Verifying...                          ################################# [100%]
Preparing...                          ################################# [100%]
Updating / installing...
   1:sqldeveloper-21.2.1-204.1703     ################################# [100%]
Extract Oracle SQL Developer rpm file
Extract Oracle SQL Developer rpm file

We will have an executable file with name sqldeveloper.sh which can be called from command line or from GUI.

Configure and Run Oracle SQL Developer

We will call ./sqldeveloper.sh file to run the SQL Developer application on Rocky Linux 8 desktop environment.

As mentioned before, if my system had three Java version, and SQL Developer raised the message if the application is not compatible with Java 16. Then we have to switch it to Java 11.1 or less. The configuration file for setting Java environment on Oracle SQL Developer will be located on /home/<username>/.sqldeveloper/21.2.1/product.conf. Change it to Java 11.1 which was installed on the system.

Then we rerun the command line ./sqldeveloper.sh the application will be running properly on the system.

Oracel SQL Developer Version 21.2.1 running on Rocky Linux 8
Oracel SQL Developer Version 21.2.1 running on Rocky Linux 8

Conclusion

The installation of Oracle SQL Developer version 21.2.1 on Rocky Linux 8 desktop was successfully done. The application requires Java version 8 or 11. I hope this article will be useful for anyone who need information about SQL Developer installation on Linux environment.

Share this article via :

One thought on “How To Install Oracle SQL Developer On Rocky Linux 8

Leave a Reply

Your email address will not be published. Required fields are marked *