Installing SQL Developer (Client Side)
In this article, I am going to show how to Installing SQL Developer (Client Side). In our previous article, we installed the WinSCP application. Now we are going to install the SQL Developer on the client side. The Client-side indicates the local computer. We already have the SQL developer installed on our server machine. We can check that using the below process.
Go to Linux machine and connect as oracle user. Open terminal and run command “sqldeveloper”.
By running this command, a new popup will appear. Click No here and wait until the home page appears.
This is the home page of SQL developer in our Linux machine. The SQL Developer is the primary tool to write the SQL statements for the PL/SQL developers.
Now we knew that we have the SQL developer in the Linux machine. We will try to install the SQL developer on the local computer. After installing the SQL developer, we will try to check the connection between the SQL developer and the database.
Download and Installation Process of SQL Developer in Local Computer:
Step1: Go to the internet browser and search for download oracle SQL developer.
Step2: Open the official website of oracle to download SQL developer. This is the trusted website to download oracle items.
Step3: There will be many versions but you need to download the windows 64-bit version of SQL developer. It also contains JDK 11 (Java Development Kit)
Click download and you will be redirected to the oracle page. You need to enter the oracle credentials to download the SQL developer.
Step4: Once the download is completed copy this zip file and paste it into any other drive whether there is good enough space. Once you paste the zip file unzip this file. It will take some time to extract all the files.
Step5: Once the download is completed open the SQL developer folder. Right-click on the SQL developer application and create a shortcut to this application as below.
Step6: Once the shortcut is created. Double click on the SQL developer and it will take some time to open initially, and below is the interface of the SQL developer.
As of now, we have installed the most important software which is required. So, next, we will try to do some connections and try to start and stop the listener and try to figure out all the errors which occur in the database.
In the next article, I am going to discuss Multiple Ways to Connect as sys User in Oracle. Here, in this article, I try to explain Installing SQL Developer (Client Side) and I hope you enjoy this Installing SQL Developer (Client Side) article.
About the Author: Pranaya Rout
Pranaya Rout has published more than 3,000 articles in his 11-year career. Pranaya Rout has very good experience with Microsoft Technologies, Including C#, VB, ASP.NET MVC, ASP.NET Web API, EF, EF Core, ADO.NET, LINQ, SQL Server, MYSQL, Oracle, ASP.NET Core, Cloud Computing, Microservices, Design Patterns and still learning new technologies.