How to Set Up Oracle Database with Docker (Official Container Image)
Vložit
- čas přidán 4. 08. 2024
- 📝 Get your FREE cheat sheet of Docker commands: www.databasestar.com/docker-d...
🎓 Learn and become confident in SQL: databasestar.mykajabi.com/sql...
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.
If you’re on an M1 Mac, then unfortunately this image won’t work, as it’s not built to be compatible with these newer CPUs. If you want to get Oracle running on your M1 Mac, the only way I know how at the moment is to use Oracle’s Free Cloud service. I’ve got a tutorial video on how to set that up here: • How to Set Up an Oracl...
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:
Oracle environment file (the ora_db_env.dat file mentioned in this video): dbshostedfiles.s3.us-west-2.a...
Commands used:
docker pull container-registry.oracle.com/database/standard:latest
docker run -d --env-file ./Documents/ora_db_env.dat -p 1521:1521 --name oracle-std --shm-size="8g" container-registry.oracle.com/database/standard - Věda a technologie
![Docker Crash Course for Absolute Beginners [NEW]](http://i.ytimg.com/vi/pg19Z8LL06w/mqdefault.jpg)
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.
Great - that would be really helpful. I tried it but its really slows down my windows machine. Would you go through the hardware requirements as well and ideally as docker-compose file. Also exaplain how to setup an initial schema with schema user and other app user for the schema
There is a FREE version available now
This video came at a perfect time! I appreciate that you updated the previous Oracle + Docker video. Thank you!
Awesome! Glad it was helpful for you.
This was very helpful. First video on setting up Oracle on Docker for Windows that actually worked for me!
Thanks, glad it was useful!
You were right, it works now, thanks a lot for your help. An incredible video.
You're welcome!
Your explanation is very good
Thanks!
Brilliant video thanks Ben.
Thanks!
ty couldn't found the official oracle db in docker hub! very good tutorial
Thanks, glad you like it!
perfectly helpful.. thank you!
Glad it was helpful!
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
Glad you like the video! I'm not sure when you would use both - for this video, I just took the connection details on the Oracle container page and used them here, and it seemed to work.
Thank you so much !
You’re welcome!
It is very helpful.
Glad you think so!
great video!!!
Thank you!!
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?
Oh I've never seen that before actually!
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?
Hmm that’s odd. Sometimes I need to click on the screen for it to be updated. Perhaps that will help. Otherwise I’m not sure, it could be a question for Oracle.
Awesome. Thanks
You're welcome!
I got TLS error from oracle default repository. I used another mirror where Frankfurt worked for me. Mirrors are listed on oracle repository page.
Good to know!
I want to use the image in a docker-compose.yml file. What would be the ORACLE_USER, and ORACLE_DB_HOST ??
Hmm I'm not sure, I don't have a lot of experience using docker-compose files unfortunately.
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?
I can't see it either, but I have a link to an env file I used in the video description.
Thanks, could u do a video regards to CDB vs PDB? Having trouble creating users
Good idea! I got this confused for so long when it was introduced so I can create a video on it.
@@DatabaseStar Appreciate thanks! looking forward
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.
Thanks for the tip!
Thank you for thr video.
But it is version 12.1
How to use for versions 12.2 or higher?
Please reply
This is dependent on the version that Oracle provides. If they only have 12.1 here then that's the version we need to use :(
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!
M1 that’s a no go zone…
Not that I know of, unfortunately! Oracle's support of Macs has been pretty poor, including the M1 computers which have been out for a couple of years.
I've seen articles of people using different tools and settings but I'm not familiar with them or how robust they are.
Hi , how can i add a volume so that the data is not lost after restarting the container?
Hey, I've created a video here to explain how to do that: czcams.com/video/-pzptvcJNh0/video.html
Perfect explanatory video . I have an error message "docker deamon is not running .system cannot find the file specified
Thanks! Is the Docker application running? Sometimes I get this when I haven't opened the Docker application (in the user interface).
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 😅)
Could you use the SID of OraDoc to connect in VS Code (the same one shown in this video in SQL Developer)?
I’m facing the same issue, followed your video on Oracle tools for VSCode and this video for creating the db inside a docker but I can’t find a way to connect the docker container using VSCode. I hope you could help us. TIA 😅
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
Yeah it seems to have changed a bit since I made this video. I’m working on a video now with the updated process which should be published in a week or two.
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)
Hmm good question. I'm not sure what a "headless linux machine" is and how you would access it without the shell. I'm still learning Docker myself so I'm not sure how to resolve this issue.
@@DatabaseStar Headless in meaning, no display-output, i remote SSH-into it. However, accessing it externally seems to work theoretically (using DataGrip), if i use the ip of the docker-host.
Problem is now,
ORA-01017: invalid username/password; logon denied
The password set in the ora_Db_env.dat-file does not work for the SYS-User or any other i could think of (SYSADM, SYSDBA, …).
A problem is, that there is no SQL-PLUS available within the docker shell, so i can't natively navigate through the DB.
@@DatabaseStar Got it set up - seemingly, the setup i had it run on was a bit picky about which user starts the container. While not failing to create the container, it somehow refused to do all the things (logs of the setup indicated some weird behaviour).
Re-"installing" it as bare root (not sudo) somehow gave it the right permissions. My guess would be, that some kind of background-service inherits the callers rights/roles and probably loses the sudo-attribute.
You are the best okay
Thanks!
Hello. Does that process still not work on mac m1?
As far as I know it still doesn't work. I don't know if Oracle has released updated images.
while trying to connect from sql developer , getting io error. network adapter could not establish connection
Aah. Is the database running? Is the SID entered correctly in the connection window?
Same issue, it seems correct, but i try to connect from a network-client not from the local machine itself
M1 compatibility has been added now!
Oh wow! That’s great. Is this for all database images or just one of the new ones?
How can I connect to eclipse ?
You could use the same connection details used in this video to connect from Eclipse to the database.
I got the following error in SQL Developer when trying to test connection:
Status : Failure -Test failed: IO Error: Got minus one from a read call, connect lapse 17 ms., Authentication lapse 0 ms.
MacOS 10.12 Docker Community Edition 17.03. Docker is running,
Hmm I’m not sure what that error means or what the solution could be unfortunately. Could you restart the Docker image? Or check the port numbers on Docker match those in sql developer? Otherwise hopefully Google can help.
@@DatabaseStar thanks for the reply, I really appreciate it. However after many failed attempts, I've tried another workaround using virtual box and it worked
I'm getting the following error Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection (CONNECTION_ID=ruVolIKOTp61CIqPkElRKw==)
Now, I have both the downloaded and extracted oracle db image and it is taking 8gb of space. Is there a way I can delete the downloaded file while keeping the extracted file?
I think there are some commands to remove the image and/or the container. I'm not sure what they are off the top of my head, but should be available on the docker website.
@@DatabaseStar thank you. How can I resolve the error?
I don't remember the exact solution but I do remember some people having this error and commenting in this video or my other Oracle Docker video. Is the container running? Is the port the same in the IDE and in the container?
Sir, please help me.. How to install Oracle 19c on mac? I have Macbook Air 128 gb 2017, mojave, 8 gb ram, intel i5 processor. Sir if you have any video regarding oracle 19c installation on mac, then please put the link of that video in my comment. and suggest me how to install. Thank you Sir.
I don't have anything for 19c specifically, as it's a few versions older. You could either try a Virtual Machine (the VirtualBox files that can be downloaded from the Oracle website), or a Docker image. Why do you need to use 19c? Can you use the newer versions instead?
first time it was connected but lator when i open again vs code and try to connect it shows error
Oh what error did you get?
When I go to Oracle Container Registry there is no longer a configuration file. I'm referring to the code you copy and then pasted on a new file and included in your command --env-file ./Documents/ora_db_env.dat. Could you share the contents of that file or what would be the right process now that is not available?
Thanks for letting me know! I've added a link to that file in the Description, and it's here as well: dbshostedfiles.s3.us-west-2.amazonaws.com/dbs/ora_db_env.dat
I did configuration with docker in Linux and windows. When I try to connect with db in both responses, got this:
cx_Oracle.DatabaseError: ORA-12505: TNS:listener does not currently know of SID given in connect descriptor
Hmm that's odd. The only issue I can think of is that the connection details don't match what is expected for the Oracle image.
@@DatabaseStar I think same but I followed the same steps of your video. When I try to connect with SQL developer goes that error. Also, I checked environment variables with docker inspect and looks well, nothing wrong. I did a telnet with direction and port of DB and reached successfully. I don't know how to check inside the docker if the DB is well configured, you know how to make a SQL statement inside docker to check if DB is working normal?
Standard has been removed. what should we use instead
That's odd. I'm not sure why. I've asked around on Twitter. For now, you could try the Express Edition.
@@DatabaseStar Yes I am using Express Edition, on got it working. Its been removed, but no reason why.
ORA-12505: TNS:listener does not currently know of SID given in connect descriptor
Whcih SID are you using? Is the docker container running?
😐Listener refused the connection with the following error : ORA-12505, TNS: listener does not currently know SID given in connect descriptor.
Have you put the right details in? Might be something Google can answer
Hello Sir,
I tried to connect sql developer to docker but i cant connect i have use macbook pro m2 , i have to try allso virtulbox but i cant to connect sql developer plz help me sir
any other option is available for connect sql developer to orcale database in mac m2 os plz help me
Hey, I have the same MacBook and have the same issue. The only way I know of is to use the Oracle Free Cloud. I have a video on how to set this up on my channel.
I have recently read there may be a virtual box image, or use Docker with a service called Colima, but I haven’t tried either one.
Thanks 🎉 🎉 can you add on apex+ords ?
I assume you can, but I've got no experience with that.
This video is great. Never the less, I got an error I wish someone could help me.
The oracle-std image is up and running in Docker, but i get the following error message:
An error was encountered performing the requested operation:
IO Error: Got minus one from a read call, connect lapse 2 ms., Authentication lapse 0 ms.
Vendor code 17002
Ah I haven't seen that error before, but I think there are other comments with the same issue.
I have the following error:
Status : Failure -Test failed: IO Error: Got minus one from a read call, connect lapse 2 ms., Authentication lapse 0 ms.
I remember seeing that when I was testing it but don't remember how I fixed it. Is the Docker container running? Are the connection details correct?
@@DatabaseStar Thank you for your response. Yes in Docker I get that everything is fine and even already removed and re-run Docker (docker run ...) and also try to change the port, also run the same that comes out in Oracle and nothing. In stackoverflow I think I got something about logging in again, but still success. I do not understand :( in case something, I'm on Windows 11
@@edissongabriellopezsalaman9716 I get the same error, but in Mac, I try to use ORCL in DB_SID, I tested, get an other error, then put back OraDoc and it works.
Sorry for my English. 😁
@@carlosmanuelalvaradoandrad3801 It didn't work :c thanks anyway
I got the same error pressing Test creating the connection, I just then pressed Save and Cancel to close the window, then reopened the saved connection's Properties and this time it worked. I'm on on Windows 11.
Very useful video. I stuck while docker run with environment file. WARNING: The requested image's platform (linux/amd64) does not match the detected host platform (linux/arm64/v8) and no specific platform was requested
Oh Seems like it ran after adding --platform linux/amd64
Good to know you got it running. I would have assumed it was because you're running the new Mac CPUs but if you got it working then it's OK.
when ı try to login using terminal and download image, ı get a error like password required.
what's ur advice? thanks in advance
Have you tried entering the password? In the process in this video you need an account on the Oracle website.
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
(CONNECTION_ID=YlC/dMqzQTeyZiKcGz4uIQ==)
I had this error while trying to create a new connection. All I did before succeed so idk where is the problem. thanks for your help sir
I am guessing that perhaps the docker container is not running. I think other commenters may have had this issue. But I'm not sure.
hey laura, please check my answer to the comment above.
it show me ""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
(CONNECTION_ID=qfKEBaibRGWTyeAj8HxXKA==) when i try to connect it with sqldeveloper
That’s strange. Is the container running and still in the starting status?
I faced same issue. Did you solve it? (I followed exactly the same procedure as in this video)
2023-08-07 21:31:37 The Oracle base remains unchanged with value /opt/oracle
2023-08-07 21:31:37 #####################################
2023-08-07 21:31:37 ########### E R R O R ###############
2023-08-07 21:31:37 DATABASE SETUP WAS NOT SUCCESSFUL!
2023-08-07 21:31:37 Please check output for further info!
2023-08-07 21:31:37 ########### E R R O R ###############
2023-08-07 21:31:37 #####################################
2023-08-07 21:31:37 The following output is now a tail of the alert.log:
2023-08-07 21:31:37
2023-08-07 21:31:37 XDB initialized.
2023-08-07 21:31:37 ALTER PLUGGABLE DATABASE FREEPDB1 SAVE STATE
2023-08-07 21:31:37 Completed: ALTER PLUGGABLE DATABASE FREEPDB1 SAVE STATE
2023-08-07 21:31:37 2023-08-02T07:04:05.971617+00:00
2023-08-07 21:31:37 ALTER SYSTEM SET control_files='/opt/oracle/oradata/FREE/control01.ctl' SCOPE=SPFILE;
2023-08-07 21:31:37 2023-08-02T07:04:06.004362+00:00
2023-08-07 21:31:37 ALTER SYSTEM SET local_listener='' SCOPE=BOTH;
2023-08-07 21:31:37 ALTER PLUGGABLE DATABASE FREEPDB1 SAVE STATE
2023-08-07 21:31:37 Completed: ALTER PLUGGABLE DATABASE FREEPDB1 SAVE STATE
Informative 😍 , but Oracle have updated the web-site.
Thanks! Yeah they update it pretty often from what I've seen.
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
(CONNECTION_ID=ArNNLkqnS2Or6wLziWLZ9g==)
Are you using the connection details provided by Oracle on their page?
It's a very useful video, that I followed step by step. However I tried to connect the Database and this is the result:
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
(CONNECTION_ID=xhWCYUQoTZaLcUwDOFk9Yg==)
Although I have read and followed the other comments about it and the related solutions, I can't fix it
Please help me: It's very important
Is the status of the container showing as running? Sometimes I got this error when it was started but not yet running.
@@DatabaseStar i have the same problem, the container is running and after 1 hour the console printed only:
Starting Oracle Net Listener.
Oracle Net Listener started.
Starting Oracle Database instance XE.
Oracle Database instance XE started.
The Oracle base remains unchanged with value /opt/oracle
#########################
DATABASE IS READY TO USE!
#########################
The following output is now a tail of the alert.log:
XEPDB1(3):Undo initialization finished serial:0 start:1187306 end:1187466 diff:160 ms (0.2 seconds)
XEPDB1(3):Database Characterset for XEPDB1 is AL32UTF8
XEPDB1(3):SUPLOG: Set PDB SUPLOG SGA at PDB OPEN, old 0x18, new 0x0 (no suplog)
2023-04-01T17:43:52.526667+00:00
XEPDB1(3):Opening pdb with Resource Manager plan: DEFAULT_PLAN
Pluggable database XEPDB1 opened read write
Starting background process CJQ0
2023-04-01T17:43:52.871300+00:00
CJQ0 started with pid=57, OS id=514
Completed: ALTER DATABASE OPEN
2023-04-01T17:51:54.281393+00:00
XEPDB1(3):Resize operation completed for file# 10, fname /opt/oracle/oradata/XE/XEPDB1/sysaux01.dbf, old size 337920K, new size 348160K
2023-04-01T18:01:54.350322+00:00
Resize operation completed for file# 3, fname /opt/oracle/oradata/XE/sysaux01.dbf, old size 573440K, new size 593920K
2023-04-01T18:01:54.356564+00:00
XEPDB1(3):Resize operation completed for file# 10, fname /opt/oracle/oradata/XE/XEPDB1/sysaux01.dbf, old size 348160K, new size 358400K
2023-04-01T18:14:59.810152+00:00
XEPDB1(3):TABLE SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P360 (45016) VALUES LESS THAN (TO_DATE(' 2023-04-02 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
XEPDB1(3):TABLE SYS.WRI$_OPTSTAT_HISTGRM_HISTORY: ADDED INTERVAL PARTITION SYS_P363 (45016) VALUES LESS THAN (TO_DATE(' 2023-04-02 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2023-04-01T18:55:46.341732+00:00
Warning: VKTM detected a forward time drift.
Please see the VKTM trace file for more details:
/opt/oracle/diag/rdbms/xe/XE/trace/XE_vktm_43.trc
Thank you for the incredible video.
Unfortunately, I can't connect to the Docker container on my Mac. I get the following error whenever I try to connect with SQL Developer (The Docker Container is running):
"An error occurred while performing the requested operation:
I/O error: The Network Adapter could not establish the connection.
Vendor code 17002".
Would you have any idea or approach how I could solve the problem.
Google could not help me at this point.
Hmm... are you using the same connection details in this video? Are you using an M1 Mac? If it's an M1 Mac, then I don't think the Docker containers are compatible with them yet.
@@DatabaseStar I use the same connection settings as described in the video. My Macbook has an i5 chip. I have not found a solution yet. I can't tell if the listener is listening because the command "lsnrctl state" doesn't work.
Thanks for the video man. I despise oracle, they make everything so complicated....
No problem, glad it was helpful!
Bro, Oracle's documentation is totally camel shit. It never said anything you just taught. Like going to the registry, or having to login via docker >:(. Im glad i found your video
Yeah the documentation is pretty hard to follow sometimes. Glad you liked this video.
thanks but please share the env file.
Which env file are you referring to?
What a pain. Container running with environment variables set from the .dat file, connection doesn't work. No way to debug.
Yeah it is a bit of a hassle with this Oracle setup. Docker containers with other databases are a bit easier to set up.
Why doesn't your connection work? What error are you getting?
you chose standard version but now standard version is not there
same here😥
Ah yes I think Oracle occasionally changes the images that appear. I’ll be creating a newer video on this soon. And I can look up what the best image is and add it to the description of this video.
This video is sick. Unfortunately, I got error with docker run. I get the following error: docker: poorly formatted environment: variable '\cocoatextscaling0\cocoaplatform0{\fonttbl\f0\fnil\fcharset0 Menlo-Regular;}' contains whitespaces.
See 'docker run --help'. 😂
Thanks! I'm not sure what that means or how to resolve it unfortunately.
You might be using textEdit. Please use Atom and save the env file.
@@kurmi_santosh thanks, you are very helpful.
M1 Mac 0:35
Good to know!
Oracle sure makes it difficult to do something simple.
They sure do!
@@DatabaseStar I was spinning up different database containers that took all of 10 minutes until I got to ....dark ominous music...Oracle
Ok ok, I admit, I'm completely spoiled. I can recall installing Oracle using 14 or 15 floppy disks in the correct order.
Like
Thanks!
ORA-12537: TNS Connection Closed
Does this happen when you connect or when you try to run a query or some other time?
i cant understand ...
What part of it is hard to understand? Happy to help explain it.
Still, Apple chip isn't supported by Oracle, what a joke!
I know, it’s been years and other databases support it, but not Oracle
Thumb down for using the Macintosh OS. Nobody uses that in the business!
Hah! I’ve seen about a 50/50 split between MacOS and Windows in the last few years for developers!
Thanks for this video. I got the error :
Statut : échec -Echec du test : Erreur d'E/S: The Network Adapter could not establish the connection
I didn't write "my.local.domain" but the ip address of my machine on my network because my docker is not on my localhost.
//// EDIT ////
Solved: I have entered the IP address of my remote machine in my hosts file so that I can use my.domain.local and it works.
Glad to hear you got it working
You did for the docker part since doker is supposed to generate ips by components but these are not linked in the network bridge?
it is showing this error after entering password Password:
error during connect: In the default daemon configuration on Windows, the docker client must be run with elevated privileges to connect.: Post "%2F%2F.%2Fpipe%2Fdocker_engine/v1.24/auth": open //./pipe/docker_engine: The system cannot find the file specified.
Please help
IN windows
Hmm I’m not sure what that means. Perhaps you need admin rights on your computer to run Docker? Do you have an admin account or admin rights?
@@DatabaseStar I Dont have admin account or admin rights. Sir
Ah, that may be the issues. But I'm not sure. You could Google the error to see if others have the same problem and solution.
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
(CONNECTION_ID=rezHgpboQvSiDty4ZgAnCw==)
Is the database running?