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 :
- Download SQL Developer Source
- Extract Source File
- 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 :
- Download SQL Developer rpm file
- Install Oracle SQL Developer using rpm source file
- 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
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.
