Install Oracle database on Docker and connect with SQL Developer

In this tutorial I will show how to run Oracle database on Docker container and connect to it using SQL Developer.

Below useful commands use in the tutorial:

1. Log into Docker hub (in order to access oracle repository)
docker login
2. Download image
docker pull store/oracle/database-enterprise:12.2.0.1
3. Run image
docker run -d -p 1521:1521 --name oracle store/oracle/database-enterprise:12.2.0.1
4. Connect to container
docker exec -it oracle bash -c "source /home/oracle/.bashrc; sqlplus /nolog"

5. Copy below script to open SQL shell

connect sys as sysdba;
-- Here enter the password as 'Oradoc_db1'
alter session set "_ORACLE_SCRIPT"=true;
create user dummy identified by dummy;
GRANT ALL PRIVILEGES TO dummy;

4. Configure SQL Developer

Username: dummy
Password: dummy
Hostname: localhost
Port: 1521
Service name: ORCLCDB.localdomain

Bardzo Ci dziękuje za ten tutorial. Na każdej platformie borykałem się z problemami z Oraclem dopiero uruchomienie go przez Docker umożilwiło mi skończenie bazy danych i oddanie projektu na studia :)

[sergiosohgp]

Omg what a great video. You saved me and a lot of other people, continue with these simple tutorials, they are very helpful. Thanks

[arthuravila]

Simple and helpful! This video saved my life twice. Thanks mate!!

[prodrigu]

Hi. Thank you very much for this video, it has been very useful for me. I am just entering the world of "Docker" and I find it great. Congratulations and keep making videos of this quality! Greetings from Santiago de Chile.

[lucascamino]

Thanks for sharing these configuration lines. They were so helpful to make things work!

[AgailSanchez]

Thanks a lot for this tutorial, the best way to estudy for oracle certification very easy to install and use!

[themansonbrother]

Thank god! At last I've done it! Thank you!

[ascar]

Thanks mate, it was the clearest video. Thanks you!

[carlosvaldez-idem]

Thanks you save my day. Keep helping the community you are the best

[luissucuc]

Im very tired 2:20 a.m. This video save me. Thank you

[issaimai]

Very helpful tutorial. Worked really well. Thanks

[marcelmarceli]

great video, extremely helpful and to the point of the matter! Thanks!

[vasaviinf]

Awesome...simple and elegant...Excellent ;)

[MrRuilova]

I never comment in youtube but you deserve more comments. Thanks!

[alesana]

Thank you! Great video dude :D very useful

[jaydeshpande]

Thanks !! saved me lot of time, especially on hosts and port mapping issues.

[ordinaryboram]

you so much !! Thanks for your kind tutorial, I've finally installed my Docker connecting with SQL Developer !!!! Have a nice day !

[fatnbaldvlogger]

docker hub is now showing the oracle database image anymore. Any idea?