This guide provides a quick and easy outline of how to install Oracle SQL Developer on Linux. It covers the prerequisites to install the software, the steps to download and extract the installation file, and the process to complete the installation. By following these steps, you can efficiently install Oracle SQL Developer and use it to work with SQL databases.
Oracle SQL Developer is a popular integrated development environment (IDE) for working with SQL databases. Suppose you are a developer or database administrator working on a Linux machine. In that case, you should install SQL Developer to help you work more efficiently and effectively with SQL databases.
What is an SQL Developer?
An SQL Developer is a software tool that enables developers and database administrators to create, edit, execute, and manage SQL (Structured Query Language) code for relational databases. SQL is the language used to communicate with databases, and it is used to perform tasks such as retrieving data, creating and modifying database objects, and managing database security.
SQL Developers typically provide a graphical user interface (GUI) that makes it easy to write, execute, and optimize SQL queries. Its tools can also provide various features and functionalities such as debugging, profiling, version control, code completion, schema visualization, and database administration.
Features of SQL Developer
- Simple download and installation process.
- Provides a no-cost development platform.
- Facilitates easy resolution of data modeling problems.
- Comes equipped with a comprehensive SQL Integrated Development Environment (IDE).
- Enables end-to-end development of your application with a full suite of tools and features.
Prerequisite to Install SQL Developer on Linux
Before installing Oracle SQL Developer on Linux, a few prerequisites need to be met. Here are the main requirements:
1. Java Runtime Environment (JRE): SQL Developer is a Java-based application requiring a JRE installed on your Linux machine. You must install a compatible version of JRE before installing SQL Developer.
2. Sufficient memory and disk space: SQL Developer requires 2GB of RAM and 500MB of free disk space to be installed and run properly. Ensure that your Linux machine meets these requirements.
3. Oracle account: You will need an Oracle account to download the SQL Developer installation file. You can create an account for free on the Oracle website.
How to Install Oracle SQL Developer on Linux
Once you have met these prerequisites, you can download and install SQL Developer on your Linux machine. By following the steps outlined in this guide, you should be able to install SQL Developer on your Linux machine quickly and easily, enabling you to work more effectively with SQL databases.
Oracle SQL Developer 22.2.1 release requires Oracle Java 11. To install Java 11 on your Ubuntu, you can run this terminal command: sudo apt-get install default-jre
Once you have installed Java JRE 11, you can follow the following steps to download and install the SQL Developer on Ubuntu.
1. Visit Oracle’s website to download the SQL Developer RPM package.
2. The file will be downloaded on the Downloads directory. You need to extract it. For that, visit the downloads directory and double-click on the downloaded file. It should open the extraction option.
3. Click on the Extract button to extract it.
4. You will get a window to select the location. Here, keep everything to default. Then click on the Extract button and wait for the process to complete.
5. After you have extracted the file, open the Terminal. For that, use Ctrl + Alt + T and navigate to the directory where you have extracted the file. You can use cd [followed by the directory name] to change the directory. For reference, you can check the below screenshot.
6. Once you are in the directory location, run this terminal command to launch SQL Developer
./sqldeveloper.sh
Now, you are ready to use SQL Developer our Ubuntu system. Please note that SQL Developer is supported on various Linux distributions, including Ubuntu, Fedora, and Red Hat Enterprise Linux, among others. You can use the same methods to install it.
Note
If you are having an error while running SQL Developer. That means you have multiple Java installed on your system, you can switch your Java version to Java 11.
Conclusion
That’s it; this is how you can install SQL Developer on your Linux system. Installing SQL Developer in Linux is essential for database administrators and developers who need to work with SQL databases.
