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
 
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
 
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
 
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
 
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
 
vcoopman profile image
Vicente Coopman •

Thanks you!! great guide

Collapse
 
sivabalakrishnan profile image
Sivabalakrishnan M •

Thank you for such a clean documentation.

Collapse
 
bajo_akisanya_sgc818 profile image
Bajo Akisanya •

Thank you for a very precise and easy to follow guide. Everything works as expected.

Collapse
 
aarocax profile image
aarocax •

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

Collapse
 
herikson profile image
Herikson •

Thank You so much!

Collapse
 
iampujan profile image
Pujan Thapa •

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

Collapse
 
zeid_zen profile image
Zaid Zein alabdeen •

Thanks for such a precise description!

Collapse
 
rgarcia profile image
Robert D. Garcia •

Muchas gracias, excelente post!

Collapse
 
bayni11 profile image
bayni11 • • Edited

can you please tell me how to unistall it
thank you

Collapse
 
siddharthadhar profile image
Siddhartha Dhar •

Very helpful.. Thanks

Collapse
 
vcoopman profile image
Vicente Coopman •

top level guide. Thanks!!

Collapse
 
ladinasedera profile image
Ladina Sedera Andria •

Thank you so much !
That's great work !

Collapse
 
kiransai profile image
kirAn-sAi •

I became a fan of you man.

Collapse
 
rrenan7 profile image
Renan Rocha •

Thanks man, that saved me, now i can study

Collapse
 
bleriotnoguia profile image
Blériot Noguia •

Thanks for such precise description!

Collapse
 
muthukumark98 profile image
MuthuKumar •

Nice content thank you very much

Collapse
 
akeamazan profile image
Kokou Elolo AMEGAYIBO •

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

Collapse
 
achaconecs profile image
Alberto Chacon •

Thanks so much, very useful!

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
 
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
 
cisu profile image
Adrian •

It works! Thanks for this :)

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
 
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
 
muthukumark98 profile image
MuthuKumar •

Nice content 👍😄

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
 
newtfrank profile image
Newton •

Really awesome guide, thanks