If you installed the SQL Developer icon on your desktop, click the icon to start your SQL Developer and move to Step 4. If you do not have the icon located on your desktop, perform the following steps to create a shortcut to launch SQL Developer 4.0 directly from your desktop.
- Starting with Oracle DB on AWS and Oracle SQL developer remotely. What you need to complete this installation. This gist was made on a Ubuntu 18.04 LTS. Default OpenJDK - installed on your local machine. Oracle SQL Developer - Linux RPM installed on your local machine. Oracle DB instance hosted on AWS using RDS.
- Before you install SQL Developer, look at the remaining sections of this guide to see if you need to know or do anything else first. The steps for installing SQL Developer depend on whether or not you will be using it on a Windows system that does not have the Sun Java SDK release 1.5 installed.
What you need to complete this installation
This gist was made on a Ubuntu 18.04 LTS.
A. Default OpenJDK - installed on your local machine
B. Oracle SQL Developer - Linux RPM installed on your local machine
C. Oracle DB instance hosted on AWS using RDS
D. Remote connection to your DB using Oracle SQL Developer
A. Install the Default OpenJDK
🔴 See command
B. Install Oracle SQL Developer - Linux RPM
Go to https://www.oracle.com/database/technologies/appdev/sql-developer.html > download
To Linux RPM click on Download.
🔴 See command
Open your Terminal, create a folder oracleSQL and move the 'sqldeveloper-19.2.1.247.2212.noarch.rpm' file you've downloaded in that folder.
🔴 See command
Install Alien
Alien converts an RPM package file into a Debian package file or Alien can install an RPM file directly.
Open a new Terminal window, and use as follows:
Go to your oracleSQL folder, and use as follows:
sudo alien <name_of_package>.rpm (e.g: I'm using sqldeveloper-19.2.1.247.2212.noarch.rpm).
Once command completed...
Your directory should now look like this ...
🔴 See executable
The executable should be located in the opt/sqldeveloper ...
🔴 See command
Launch Oracle SQL Developer
C. Connect to a database remotely
If you have an AWS, Azure or GCP account, you can connect to your database using Oracle SQL Developer.
I'm here using an Oracle RDS instance on my AWS account.
3. Create an Oracle DB instance hosted on AWS with RDS
On your AWS Management Console, go to Services > RDS.
Go to Databases > Create database > Choose Standard create > Configuration: Oracle as engine type
🔴 See configuration
Edition: choose Oracle Standard Edition Two
Version: select Oracle 12.1.0.2.v2
Templates: choose Dev/Test
DB instance identifier: ORCL-DB-Test
Master username: choose a username
Master password: choose a password
🔴 See configuration
DB instance size: choose Burstable classes > select db.t3.micro
DB instance size: select Burstable classes (includes t classes) > db.t3.small
Storage > Allocated storage: 20 GiB
Disable 'storage Auto Scaling'
🔴 See configuration
Connectivity: set Publicaly accessible to Yes
Installing Sql Developer On Parallels 2019
🔴 See configuration
Then Create database. When your DB is up and running...
4. Connect and provision your DB remotely using Oracle SQL DB
Go back to Oracle SQL Developer locally and connect to your DB credentials.
On Connections click on the 'plus' button.
Connect with the information provided upon the DB creation on RDS.
Installing Sql Developer On Parallels Download
Here you go! You are now connected to your Oracle DB remotely using Oracle SQL Developer.
In your left panel, you are connected to a database. Now you can create tables and start interracting with your DB.
Basic SQL syntax
We are here using basic SQL syntax to show how our DB works.
Installing Sql Developer On Parallels Free
You can create and provision tables in Oracle DB using PL/SQL syntax for more advanced needs.
Installing Sql Developer On Parallels Windows 10
If you enjoyed this gist, feel free to fork and share it! Thanks.
Author
- Isaac Arnault - Start with Oracle SQL Developer on Linux.