How to install and run an Oracle Database instance in a Docker container? Yes, I Know IT! Ep 18

Despite great opensource alternatives, Oracle Database skills remain in high-demand on the job market. But for many students--and even for experimented database developers--installing Oracle from scratch is a tedious task. And running an Oracle Database instance from a pre-installed virtual machine might require too many resources on your computer. Fortunately, Docker is here.

The Oracle license allows you to install and run an Oracle instance for education or testing purposes. And you can find on the official Oracle website, both the installation media and some pre-installed virtual machines images freely available. Both those solutions have drawbacks, especially when you are new to Oracle and don't have access to an overpowerful computer.

More recently, Oracle joined the Docker bandwagon by providing Docker image allowing to run an Oracle database instance in a container. I was quite seduced by that move, but unfortunately, the Oracle image was deceptively challenging to use.

Hopefully, there are great people in the Docker community. Specifically, Maksym Bilenko provides Docker images for several Oracle Database versions. Thanks to his work, you can now have an Oracle instance up and running just by typing three commands on your terminal. And this is what I explain in this video:

As always, I hope you find that useful. And don't forget to up-vote/subscribe/comment if you liked it!

---------------------------------------------------------

Music : "Howling" by Gunnar Olsen

[renatobalcazar]

The animations in the bash sentences are gold. Thanks

[marko_]

Great and easy-to-follow explanation!
PS: You are a pretty fun guy, I could listen to you the whole day :D

[NomadicBrian]

This is quite significant if you want to use an Oracle database on Linux Mint Cinnamon. That subtle debian package based system I think not supported to run directly but since docker is usable just install a Redhat version that runs in the image and done. in theory. I am setting off to do this today.

[DjMattio]

Thanks is very tedious to install this DB in Linux for a student like me this is so helpful. Thanks

[KumR]

Good Video. Once we install the Oracle DB using the image and start creating tables, what is next step ? Can we take this container and deploy (with the database objects) in another environment (machine) ?

[PterPmntaM]

good video, the password is general for any test, or u create this?

[SlimaneDeb]

the image "sath89/oracle-12c " does not exist anymore ??

[guilhermelimpo]

Hi, thank you

How can I import a expdb_full.dmp into this docker Oracle 12c?
Is It possible with instantclient installed ?

[Nishun]

Hello,

Thank you!
I was able to install Oracle SQL using Docker Container. But how do I unlock default oracle schema (user like HR, SCOTT)?

[ajayramanaa]

Hello, my Oracle 12c docker is working fine. But I want to access it through sql developer from Mac. I am getting network error... Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection. Mac to docker direct connection is working fine and I am able to run sql> through Terminal. Need to prepare a dedicated connection between docker and sql developer (on host Mac). ??

[amirsoleimani]

After starting the container, there is no log and the container does not exist when I execute 'sudo docker container ls'
is that image you use in tutorial ?

[MrJkrole]

Hello, Great video,
Could you help me with a problem?
Right after "sudo docker logs -f $CID" 2:10
My bash returns: "standard_init_linux.go:190: exec user process caused "exec format error"
What could be the problem?
I'm doing the setup on my raspberry 3B
Thank you very much.

[RajeshSamson]

How to run the same commands in a Windows Terminal?

[LuisDiaz-uuxg]

Salut
Super ta video. J'ai neanmoins une question... Tu peux faire un listener status ou bien un SELECT host_name FROM v$instance;
A la place de l'IP il y a le code du container... Comment puis je me connecter a cette instance depuis SQL DEVELOPER depuis une autre machine qui se trouve dans le meme reseau?
J'espere que tu pourras repondre. Ciao

[saradhidinavahi]

default password "oracle" is not working for sudo docker exec -it $CID sqlplus sys as sysdba.. any help

[mahfoudhachref]

Everything is working fine.

But when i close my terminal i can t reconnect on my databse only with recreating the database and reexecuting the 4 commands .

Is there any possible solution to evoid this waist of time.

[chrisv]

great job but seriously where is the gui configuration?

[-]

Connected with sql developper is the important part pfff