How to Set Up Oracle Database with Docker (Official Container Image)

If you want to use Oracle database in a Docker container, you’ll need an image file. Other database vendors have images on the Docker Hub website, but recently Oracle have removed their image and added it to their own container registry.

In this video, you’ll learn how to use the image in Oracle’s container registry. You’ll see how to download and install Docker, how to find the Oracle database image, how to download the image and run it on the command line, and how to connect to the database image using SQL Developer.

Timestamps:
00:00 Oracle Container Registry
01:10 Download Docker
02:24 Find the image on the registry
04:19 Create the environment file
04:46 Login using Terminal and download image
06:13 Run image
08:21 Connect using SQL Developer
09:27 Run a simple SQL query

/// LINKS:

Commands used:

[DatabaseStar]

Update: it seems like the Standard repository has been removed from this registry for some reason. You may be able to use either the express or enterprise versions. I haven't tested either of them but I will create a video on this in the future.

[jnnfnt]

This video came at a perfect time! I appreciate that you updated the previous Oracle + Docker video. Thank you!

[shutterassault]

This was very helpful. First video on setting up Oracle on Docker for Windows that actually worked for me!

[almaraya]

Thanks for this helpful video. It totally saved my day. Question: When do I use both listener and http port? I asked because you did only use one of them. Do I just need one? Thanks

[alitc]

You were right, it works now, thanks a lot for your help. An incredible video.

[locktharcillo]

ty couldn't found the official oracle db in docker hub! very good tutorial

[Loqrin]

This might help some out there.
When trying to connect to the database, I received this error:
"the network adapter could not establish the connection"

Instead of using the port 1521, I used the port 1527.
When I did "docker ps" I could see two ports:
0.0.0.0:1527->1521.
As well as in the docker desktop GUI, it showed for the container the ports "1527, 5507".
So I tried that and it worked for me.

[alitc]

Great Video, I have done exactly what was said in the Video but my connection from SQL Developer "Testing Connection" never ends. It runs and runs and... Do you know what to do?

[lefique]

Perfect explanatory video . I have an error message "docker deamon is not running .system cannot find the file specified

[pkilpo]

I got TLS error from oracle default repository. I used another mirror where Frankfurt worked for me. Mirrors are listed on oracle repository page.

[weijiephua]

Thanks, could u do a video regards to CDB vs PDB? Having trouble creating users

[felipehenriquez]

Hello! Nice video. Thank you for sharing this. I have a little question: where I can find the service name for connect with VScode (I've been struggling with this for days 😅)

[bcassilhas]

I created an image succesfully as it is active on "docker ps", but when i open SQL DEVELOPER, the "connections" menu is disabled (the green "+" is not appearing aswell). Do you know what it is?

[niveditha]

Thank you for thr video.
But it is version 12.1
How to use for versions 12.2 or higher?
Please reply

[KenjiVdusc]

Since I am new to the whole docker thing, i wonder tho - i set it up on a headless linux machine - so far so good - however, since i dont have only the shell, how would i access it? And configure it for network access - since it does not seem to work out of the box (The Network Adapter could not establish the connection)

[ashribadmohanty]

Is there any other way to install oracle database on Apple M1 apart from the Cloud account? I am having problems while creating the Oracle cloud account. Please help!

[singlaarun]

I cant see any details for environment file listed on the express version or the free version. How I do i get hold of the env file or create one?

[hansbaumberger]

I want to use the image in a docker-compose.yml file. What would be the ORACLE_USER, and ORACLE_DB_HOST ??

[marieclairemichelledelacru]

Question in the new instructions it does not have any environment file but now I do not know which are the default username, password and domain ... what can I do ? I can not connect because I do not know what to write

[lwvjfsm]

Hi, how can i add a volume so that the data is not lost after restarting the container?