How to Set Up Oracle Database with Docker

Docker is a product that allows developers to create containers, which are self-contained areas on a computer for running applications. They can be used for databases, which is great if you can't install it normally (e.g. you use a Mac).

This video shows you how to set up an Oracle database on Docker. It uses an existing Oracle docker image on the Docker Hub website.

You'll learn how to download and install Docker, find the right Oracle image, download the image, run it, and connect to it in SQL Developer.

The connection details for this image mentioned in the video are below.

Container Database:

Username: SYS
Role: SYSDBA
Password: Oradoc_db1
Host: localhost
SID: ORCLCDB

Pluggable Database:

Username: SYS
Role: SYSDBA
Password: Oradoc_db1
Host: localhost

Timestamps:
00:00 Introduction
00:27 Download Docker
01:12 Run Docker
02:09 Docker Hub signup
02:53 Search on Docker Hub for image
03:36 Oracle Docker image page
04:18 Terminal - docker login
05:51 Run Docker image
07:22 Docker is running
07:37 Start SQL Developer
08:08 Container Database connection
08:40 Pluggable Database connection
09:11 Simple query
09:35 Stop Docker container

Docker Image Missing: it seems the Oracle docker image has been removed from Docker Hub. Oracle has their own "container registry" where you can find the Docker image for the Oracle database.
Then go to Database, then Standard, and copy the image from that page.

[DatabaseStar]

Two issues noticed: M1 MacBook, and official image not shown easily.

M1 MacBook:
Are you running an M1 MacBook? At the moment, the Oracle Docker image is not supported on the M1 computers (the Docker application is). So, if you follow this video (which was recorded on a non-M1 MacBook), you'll get issues and won't be able to run or connect to Oracle.
There are many commenters below with the same issue.
The solution? I think the only one is to wait for an updated Oracle Docker image. Alternatively you could create a cloud-based Oracle database - but that's not using Docker on your computer so it's different.

Official images disappeared
There are a couple of alternatives such as GitHub Oracle repo for docker images, or their container registry, which I can do a video about in the future.

[nickaird]

Many thanks for this excellent video! Have just worked through all the steps. Good work!

[namnguyentuong]

:( I cry inside when I see this video! Almost change my MAC to WINDOW :( Thanks alot

[shcxatter]

I cannot express how much I love you right now, I was trying to run a dockerized oracle db from testcontainers for 2 days straight, and this video is just godsend, thank you! Also I like the style of your tutorials, you don't gloss over the details, instead you show everything from start to finish, that's the way it should be.

[crackbackmagicman]

If you're using Docker with gvenzl/oracle-xe (Oracle Database Express Edition image) in a combination with Oracle SQL Developer environment, make sure to use 'xe' as the SID. Thanks for the video!

[gianpaolozanconato]

Oracle Database Enterprise Edition is no longer available, thanks

[virendramohite]

An error was encountered performing the requested operation:

IO Error: The Network Adapter could not establish the connection

Vendor code 17002

[nathanmeira]

Thank you so much for your tutorial. That was by far the best one found on the internet.

[stofficials]

Hello! Thank you for the greta in-depth tuotorial! Unfortunately I am attempting to run this on m1 Macbook pro and the oracle docker container says "unhealthy". If i ignore this and continue, later on in the SQL i get the following error: "Status : Failure -Test failed: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor


Any help will be much appreciated! Thanks again!

[abhishekrayasam]

Great video! Can you please make a video on how to install Oracle Database on Apple MacOS M1 and initiate Oracle APEX

[guilhermevieira]

Great video! I was wondering how can I update the default environment variables for DB, USER, and PASSWORD? And also, where does oracle store the data so I can create a volume for it? I'm currently using docker-compose

[TanushreeGorai]

Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection

Getting this error in while making new connection, please help

[kartikkt]

Hi Database Star, I just followed the step you mentioned over the video but Still I am getting error TNS lost contact and docker image status is also unhealthy. could you please suggest? I am doing this in my apple macbook M1

[okorochavivian]

Thank you for the video, please can you do another video on how to set up Oracle database with docker because the Oracle database in this video is old version, there is now update now, those options is no longer there. And secondly for those that are use macOs monetary. Thank you.

[nikkilpandurrangpatil]

Thank you for the video. Excellent video. Currently Oracle Database Enterprise Edition is no longer available. So how we can proceed further ?

[ansfidine]

i got this error Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection

[akosp-h]

When I try to connect to my newly created connection or for imported connections I get this error: "Status : Failure -Test failed: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
Do you have an idea why it is happening? I am using Mac with M1 chip

[jafetgranados]

Image is marked as deprecated and docker hub does not allow to download it. Any other idea how can we get it or maybe how to create it by ourselves?

[sunitap]

Hi
I am unable to get the option Oracle Database Enterprise Edition in the search list. Any idea of the reason?

[iwishawesomeness]

Hey I'm getting an error saying "listener refused the connection with the following error: ORA-12505, TNS: listener does not know of SID given in connect descriptor"

I did follow the instructions in the video. But the status of oracle keeps showing "unhealthy" for some reason.

I'm using a M1 Mac for reference.
Please help me with this . Thanks a lot for your tutorials.