DEV Community

How to Install Oracle SQL Developer on Ubuntu 20.04

Ishak Antony Darmawan on July 26, 2020

This is a fairly straightforward guide to install Oracle SQL Developer on Ubuntu 20.04 Gathering Files Prerequisite Oracle ...
Collapse
 
marflage profile image
Marflage • Edited

Thank you so much for this post. I wanted to run SQL Developer on Ubuntu 20.04 but I didn't know that .deb packages were listed under Other Platforms for Linux. I was bummed by the .rpm files. Now, I also want to connect to Oracle Database locally. Could you make another article for that? Thanks and thanks.

Collapse
 
pichetraful profile image
Piche Traful

Thanks for this, at first I downloaded a linux version and it didn't work. After that I removed that version, btw I could not do it with the ubuntu software upgrade tool so did a delete java from the GUI, and downloaded the debian one. The install took place but could not find the /usr/lib/jvm with the GUI. If you use mlocate it is there. So I just passed that path when I started pl/sql dev. Now, it works....!

Collapse
 
jhonathanalfonso profile image
JhonathanAlfonso

Hello Ishak, thanks for sharing your knowledge. Are there some way to change the jdk. I use the jdk 15 but it not working properly. The sqldeveloper crash than of a time when is connected to an amazon database.

Collapse
 
racer84 profile image
Racer84

Thanks for such precise description!

Collapse
 
racer84 profile image
Racer84

Small issue: when running sqldeveloper from desktop shortcut, error occurs while connecting to DB:
Status : Failure -Test failed: no ocijdbc21 in java.library.path: [/usr/java/packages/lib, /usr/lib64, /lib64, /lib, /usr/lib]

Collapse
 
gmanno profile image
gmanno

I was having the same problem. I solved by specifying within the sqldeveloper the folder where tnsnames.ora is located

Collapse
 
adityalochan profile image
aditya lochan • Edited

Facing this issue when stating sql developer :

A fatal error has been detected by the Java Runtime Environment:
SIGBUS (0x7) at pc=0xxxxxx, pid=xxxxx, tid=xxxx

JRE version: Java(TM) SE Runtime Environment 18.9 (11.0.11+9) (build 11.0.11+9-LTS-194)
Java VM: Java HotSpot(TM) 64-Bit Server VM 18.9 (11.0.11+9-LTS-194, mixed mode, tiered, compressed oops, g1 gc, linux-amd64)
Problematic frame:
C [ld-linux-x86-64.so.2+0xxxxxx]
Core dump will be written. Default location: Core dumps may be processed with "/usr/share/apport/apport %p %s %c %d %P %E" (or dumping to /opt/sqldeveloper/sqldeveloper/bin/core.46471)

Collapse
 
stevens profile image
Constantin

I followed your tutorial on jdk and sqldeveloper, which works well, thank you very much, but I can't program the PLSQL, and I'm asked to connect to the oracle database.

Could you provide me with a tutorial on how to install an oracle database on ubuntu?

Thank you very much

Collapse
 
muthukumark98 profile image
MuthuKumar

Nice content thank you very much

Collapse
 
bleriotnoguia profile image
Blériot Noguia

Thanks for such precise description!

Collapse
 
rrenan7 profile image
Renan Rocha

Thanks man, that saved me, now i can study

Collapse
 
kiransai profile image
kirAn-sAi

I became a fan of you man.

Collapse
 
ladinasedera profile image
Ladina Sedera Andria

Thank you so much !
That's great work !

Collapse
 
bayni11 profile image
bayni11 • Edited

can you please tell me how to unistall it
thank you

Collapse
 
vcoopman profile image
Vicente Coopman

top level guide. Thanks!!

Collapse
 
siddharthadhar profile image
Siddhartha Dhar

Very helpful.. Thanks

Collapse
 
sivabalakrishnan profile image
Sivabalakrishnan M

Thank you for such a clean documentation.

Collapse
 
vcoopman profile image
Vicente Coopman

Thanks you!! great guide

Collapse
 
rgarcia profile image
Robert D. Garcia

Muchas gracias, excelente post!

Collapse
 
zeid_zen profile image
Zeid Zein alabdeen

Thanks for such a precise description!

Collapse
 
iampujan profile image
Pujan Thapa

Thanks for writing in detail. No confusion of installation after reading this. Keep writing.

Collapse
 
herikson profile image
Herikson

Thank You so much!

Collapse
 
aarocax profile image
aarocax

Thank you very much, it is the first time I install it at first time. So good

Collapse
 
akeamazan profile image
Kokou Elolo AMEGAYIBO

thank you for sharing this post. it help me so much.

Collapse
 
newtfrank profile image
Newton

Really awesome guide, thanks

Collapse
 
ixenoverse profile image
Sadia Tabassum

And after installing, you can't connect the database and also tsnames.ora file will not generate so its just a waste of time.

Collapse
 
bsjankowski profile image
bsjankowski • Edited

Hello Ishak, issue: error occurs while connecting to DB:
status failure - test failed io error the network adapter could not establish the connection

Collapse
 
bishnu47 profile image
Bishnu Das

facing same issue

Collapse
 
muthukumark98 profile image
MuthuKumar

Nice content 👍😄

Collapse
 
mikibardaji profile image
Miquel Angel

Hi thanks for your post.
But when I start the oracle developer, I need an user. It's exists an predefined user with and password?

Collapse
 
achaconecs profile image
Alberto Chacon

Thanks so much, very useful!

Collapse
 
bsjankowski profile image
bsjankowski

Hi Ishak, thsanks for guide to install Oracle SQL Developer, I would like create connection for sql developer in ubuntu but can't create.. Thanks

Collapse
 
phani0518 profile image
SESHA SAI PHANI CHANDRA MUVVALA

Hi Ishak When i am trying to install oracle developer unable to install can you please help me with that

Collapse
 
phani0518 profile image
SESHA SAI PHANI CHANDRA MUVVALA

i am trying to install as you mentioned above during installation time it was showing error during installation process can you please assist regarding this Ishak

Collapse
 
cisu profile image
Adrian

It works! Thanks for this :)