How To Install Oracle SQL Developer on Rocky Linux 8

In this short tutorial, we will learn how to install Oracle SQL Developer on Rocky Linux 8 operating system. We will use Oracle SQL Developer version 21.2.1.

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

Prerequisites

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

As mentioned section above, if SQL Developer requires Java installed on the system. We will verify it by submitting command line :

$ java -version

Output :

[ramansah@otodiginet ~]$ java -version
openjdk version "11.0.12" 2021-07-20 LTS
OpenJDK Runtime Environment 18.9 (build 11.0.12+7-LTS)
OpenJDK 64-Bit Server VM 18.9 (build 11.0.12+7-LTS, mixed mode, sharing)

If there were no Java installed on the system, then we need to install it first.

There are two options to install Oracle SQL Developer on Rocky Linux 8, namely :  using source file and using rpm file.

1. Using Source File

In this option, the installation steps will be described as shown below :

  1. Download SQL Developer Source
  2. Extract Source File
  3. Running SQL Developer

1.1. Download SQL Developer Source

The first step in installing Oracle SQL Developer is to download the source of Oracle SQL Developer from Oracle official website. The source file will be located on https://www.oracle.com/tools/downloads/sqldev-downloads.html and select ‘Other Platforms’ option to be downloaded. Before starting download, we will be asked to fill the Oracle account.

1.2. Extract Source File

At this step, we will extract the source file, by clicking the right button of mouse. Once file is extracted move it to our preferred location

1.3. Running SQL Developer

After extracting was completed, then we run the SQL Developer buy submitting command line :

bash ./sqldeveloper.sh

2. Using rpm File

To install SQL Develper on Rocly Linux 8 sytem by using rpm file,it will  be described as shown below :

  1. Download SQL Developer rpm file
  2. Install Oracle SQL Developer using rpm source file
  3. Configure and Running SQL Developer

2.1. Download SQL Developer rpm file

The first step in installing Oracle SQL Developer is to download the source of Oracle SQL Developer from Oracle official website. The source file will be located on https://www.oracle.com/tools/downloads/sqldev-downloads.html and select ‘Linux RPM’ option to be downloaded. Before starting download, we will be asked to fill the Oracle account.

[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

2.2. Install Oracle SQL Developer

At this step, we will install Oracle SQL Developer by using rpm file :

$ rpm -Uhv sqldeveloper-21.2.1-204.1703.noarch.rpm

Output :

[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%]

2.3.  Configureing And Starting SQL Developer

At this step, we will set up the Java Home which will be used by SQL Developer. The file is located at produc.conf.

Output :

[ramansah@otodiginet ~]$ cd /home/ramansah/.sqldeveloper/21.2.1
[ramansah@otodiginet 21.2.1]$ ls -ltr *.conf
-rw-rw-r-- 1 ramansah ramansah 2798 Sep 10 13:52 product.conf
[ramansah@otodiginet 21.2.1]$ vi product.conf 
[ramansah@otodiginet 21.2.1]$ 
=========
# SetJavaHome /path/jdk
SetJavaHome /usr/lib/jvm/java-11-openjdk-11.0.12.0.7-0.el8_4.x86_64/bin/

Staring Oracle SQL Developer, by submitting command line :

$ ./sqldeveloper.sh

Output :

[ramansah@otodiginet sqldeveloper]$ ./sqldeveloper.sh

Oracle SQL Developer
Copyright (c) 2005, 2020, Oracle and/or its affiliates. All rights reserved.

The JDK '/usr/lib/jvm/java-11-openjdk-11.0.12.0.7-0.el8_4.x86_64/bin/' is not a valid JDK.
The JDK was specified by a SetJavaHome directive in /home/ramansah/.sqldeveloper/21.2.1/product.conf

Type the full pathname of a JDK installation (or Ctrl-C to quit), the path will be stored in /home/ramansah/.sqldeveloper/21.2.1/product.conf
/usr/lib/jvm/java-11-openjdk-11.0.12.0.7-0.el8_4.x86_64/ 
Warning: Nashorn engine is planned to be removed from a future JDK release

 

Oracle SQL Developer v21.

Conclusion

In this short tutorial, we have learned how to install Oracle SQL Develoer on Rocky Linux 8 operating system. I hope this tutorial will be helpful.

(Visited 128 times, 1 visits today)

Comments

No comments yet. Why don’t you start the discussion?

Leave a Reply

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