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 It seems like the official Oracle images don't show immediately in the search results. You can try the direct link here: hub.docker.com/_/oracle-database-enterprise-edition 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. Or, you can try gvenzl's images on Docker Hub: hub.docker.com/r/gvenzl/oracle-xe
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.
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!
Thanks a lot !!! I was facing an error in testing the connection when I used the SID as ORCLCDB, but changing it to xe as resolved the issue and I was able to replicate the same as you are showing.. Thank you !!
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 (CONNECTION_ID=tJCFkMuRQhClzrDLT8IYEA==)" Any help will be much appreciated! Thanks again!
Hi, glad you like the video. Yeah I’ve seen other comments with M1 Mac issues. In short it doesn’t work on them yet but it should soon. The error is due to the unhealthy status you mentioned. It’s because the database is not running. I think we will have to wait for the Docker images to be rebuilt to work on M1 macs.
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
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.
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.
Ah using the M1 Mac could be the cause. In the Pinned Comment I've mentioned that this Docker image does not work on the new M1 Macs, and I don't think a newer image has been released yet.
Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection (CONNECTION_ID=dc4EPuOQRxacr80vWEEmdg==) Getting this error in while making new connection, please help
@@DatabaseStar Thank you so much this video helped me a lot, I did one some mistake while doing it that's why i was getting the error, now it is connected 😊
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 (CONNECTION_ID=pP3tiQJ0Q6q5yxSaOUVJyA==)" Do you have an idea why it is happening? I am using Mac with M1 chip
Hey, there are some other comments on here about Docker on M1. Apparently the image doesn’t work on the new Macs yet, but I’ve got an older one which is why this video works. There may be an updated image that works on M1 macs, but if not we may have to wait for it. Otherwise that error may mean the Docker container is not running, which you can check with “docker ps”.
Thanks! I haven't used it enough to notice any difference in options. However my main computer is a Mac, so I can't run Oracle natively on the OS (it's only available for Windows and Linux). My other option was using a Virtual Machine with Windows on it, which was much slower than Docker.
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. The link is here: container-registry.oracle.com/ords/f?p=113:1:101127284426769:::1:P1_BUSINESS_AREA:3&cs=3HFiPnPXvx0EKYwu8Ec4s4iYEPD8IaKSIseyGZpMbeCUjZ5hjX6uynnD6xPtwzQqtTK5f3yXvwArh8WtEYdDasQ If that doesn't work, go to container-registry.oracle.com/ords/f?p=113:10:::::: Then go to Database, then Standard, and copy the image from that page.
Hello @Database Star when i connect with the SID i find in my docker image details, my test connection fails, but when i use the SID you gave in this video it works, why is that?
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
Good questions! I'm not sure how to update the default environment variables. And I've wondered the same about where the data is stored. I've just started with Docker so I'm not sure about either. But I can research it and create videos on them in the future.
@@DatabaseStar After some researches, I've discovered it! Oracle data is in "/opt/oracle/oradata" folder, you can create a volume for it mapping the volume folder: volume-name:/opt/oracle/oradata.
Good question. I think you would need to install them separately. I’ve never used sqlcl and haven’t used sql plus on a Mac so don’t know how easy this would be.
Thanks for pointing it out. I've noticed the image comes and goes and other comments say there are issues. There are two options I think: using Gerald Venzl's version, or from the Oracle Container Registry. I added a comment to the video about this, and I think I'll make a new video on using the Oracle Container Registry to set this up.
Yeah, it's because Oracle has since removed the image from Docker Hub. Check out the pinned comment and the description. I've got a video here on how to use their registry to get the image: ruclips.net/video/56dSXI2PbCQ/видео.html
Hi, can I ask you, how to create new user or is it possible? I have healthy oracle database in docker according to your instruction and now I am login as SYS in sqldeveloper. But when I run command: "CREATE USER new_user IDENTIFIED BY user_password" it shows error instead creating new user. Should I login as another user than SYS, or what should I do to create new user? Thanks :)
@@DatabaseStar hi, thanks... I already found solution... it is these for rows ;) ALTER SESSION SET "_ORACLE_SCRIPT"=TRUE; CREATE USER IDENTIFIED BY ; GRANT CREATE SESSION TO ; GRANT DBA TO ;
Hello Database star, i'm aiming to become an expert in just the field of mysql database development but cannot afford oracles learning subscription fees. can you tell me where/how i can learn everything there is to know about mysql database creation and maintenance free or relatively cheaply. Also, do i stand any chance of a job in database development without formal certificates even if i become an expert in mysql? thanks
Hey, I think you're in the right place to learn for free. There are a lot of channels and videos on RUclips where you can learn about MySQL. I have a couple of videos but there are many others with more information. Yes, I think you can get a job in database development without a formal education. There are many self-taught developers in the industry so it's definitely possible!
Yeah I think Oracle have removed it from docker hub and added it to their own container repository. I have another video on how to use that on my channel.
I cannot login in docker , I get this error: 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.
Could you please help me to create a volume for persisting data? Because if I create a standard oracle user, this user is lost if I stop and start docker. I need some help on how to use the docker compose and create the .yml file. Your help is valuable!
Glad you like the video. What's a dumping file? Do you mean an SQL file of a database? It depends on the format of the file, but you should be able to open it and run it.
@@DatabaseStar the scenario is like this: i have a local oracle database installed in my system, now since I know docker (don't laugh, i know I'm late knowing about docker), I want to move the existing schema to docker, to do that, I can't do it by import the sql file. because it's too huge to store it in .sql file. So all I want to do is dump the database using expdp command and import it with impdp command. To do the impdp, I need a directory that mounted to the docker, so I can map a record in dba_directories to that mounted directory. How can I do that? I use windows as host.. Thank you so much
Ah I understand. Good question. I'm new to Docker as well, and I'm not sure how to do that. It's something I'd like to know, though, because finding and accessing the mounted folder would be useful. I plan on making a video about this in the future, but for now, I'm not sure how it's done.
@@DatabaseStar i gave you home works.. LOL.. i think i need to subscribe your channel while i'm searching for it too.. maybe you can make a better video about it, once it live i will spread it to my colleague..
Hi I m seeing this error: An error was encountered performing the requested operation: ORA-01017: invalid username/password; logon denied 01017. 00000 - "invalid username/password; logon denied" *Cause: *Action: Vendor code 1017
An error was encountered performing the requested operation: IO Error: The Network Adapter could not establish the connection (CONNECTION_ID=5Nbz34N8Qs6yrzWnK2Cstg==) Vendor code 17002
Is your container running? If you run "docker ps", does the Oracle container show starting or running as the status? Could you try some of the other solutions mentioned in the comments here?
I am getting this error "Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection (CONNECTION_ID=cXIcM5J/SLu968J8xRtnqA==)" . Have checked listener port hostname etc. all seems correct. For some servers connections working fine but for some, getting this error. Would be grateful if someone could help me out.
@@DatabaseStar Yes details are correct. But i found that internet is not working in container. even nslookup not working in container. same is working on host server.
Ah, the password is available on the page on Docker Hub where the details of the Oracle image are found. The image has a password set for the database, and we can just use that.
Thanks a Lot. Guys make sure you have a port number specified. So do we need any license to access it or for the developer version it's free? Hope you reply soon. Waiting for you ACK. #Database Star @Database Star
Status: Failure -Test failed: ORA-01017: invalid username/password; logon denied I have followed all your steps, This is an error I am facing while setting up, any suggestion is helpful.
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 This error shown after test
Have you used the same connection details as shown in the video or the description? If you want to connect to the pluggable database, you should select Service Name and use ORCLPDB1.localdomain.
@@DatabaseStar I am having this issue as well. It also says my container is unhealthy. Could it be because I am doing all this on M1 processor? It did show a warning about that when I ran the docker image.
Unfortunately it doesn’t work on the new M1 macs. This is because the image has not been created to work with them even though Docker can run. I believe the solution is to wait for the image creator to rebuild it (if they haven’t already).
Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection, getting this error while doing the connection from sql developer
"Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection (CONNECTION_ID=9DqQc946Sz27CN8qcycWyA==)" I am getting this error while create a connection
Yeah I’ve seen that it doesn’t work on the M1 chip. The pinned comment explains more. But unfortunately there is no docker image or VM that you can use for M1 yet, as far as I know :(
@@DatabaseStar yes, I managed to have it locally using lima vm with ubuntu and installing docker on that ubuntu. I've come accros a lot on suggestions to use Ubuntu with UTM. I would give this also a try.
Ah yeah I have heard it was removed then replaced so seems like it was removed again. I think Gerald Venzl has a Docker image that can be used. You can Google for the image name.
Hello Database star, Thank you for the video. Unfortunately, I am getting this error An error was encountered performing the requested operation: Listener refused the connection with the following error: ORA-12514, TNS:listener does not currently know of service requested in connect descriptor (CONNECTION_ID=DUvhB5/qQTSHon6HF3NrdA==) Vendor code 12514 Can you please help me with this?
The other error I get when I try to connect Container Database is 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=6wjEvSm4SjyyObrP1lrXEA==)
Hmm that’s an odd one. Is the container running? Have you entered the right host name and service name? This is a common issue connecting to Oracle databases.
Hi Shakira, I got this error today actually. I couldn't work out why, but I waited about a minute or so and tried again, and the connection worked. Perhaps there is something in the background inside the container that needs to start up before it will accept connections.
How can I connect remotely With Docker Image Installed Oracle Database ? What is the I.P Address and what is the TNSORANAMES.ora file of this Database ?
i got this error Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection (CONNECTION_ID=k+d0YojcTjWXAp27XETfoQ==)
I think there are some other comments with the same issue. Could you check the port number used? Or wait a minute until the service has started? I thinks that’s what others have done.
@@DatabaseStar by a miracle it is working now. I got the error on SQL Dev , VSCODE with oracle sql tools plugin and I even tried DBEaver same thing so after hours of searching and trying to find out where is the problem nothing seemed to work. Today I found out that i was forgetting to hit the "docker start " command I was furious man.
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
It seems like the official Oracle images don't show immediately in the search results. You can try the direct link here: hub.docker.com/_/oracle-database-enterprise-edition
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.
Or, you can try gvenzl's images on Docker Hub: hub.docker.com/r/gvenzl/oracle-xe
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.
Wow, thanks, glad you like the video and found it useful!
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!
Thanks for the tip!
Finally a video about DBs, Oracle and Docker narrated with an accent that I can hear and understand. Thank you! ❤
Thanks! Glad you enjoyed it!
Thank you so much for your tutorial. That was by far the best one found on the internet.
Thanks! I’ve always wanted to try Oracle on Docker but most of the tutorials I found were not good or incomplete. So I created my own here 🙂
Thanks a lot !!! I was facing an error in testing the connection when I used the SID as ORCLCDB, but changing it to xe as resolved the issue and I was able to replicate the same as you are showing.. Thank you !!
No problem, glad the video helped you get the connection working.
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
(CONNECTION_ID=tJCFkMuRQhClzrDLT8IYEA==)"
Any help will be much appreciated! Thanks again!
Help sirrr!!
Hi, glad you like the video. Yeah I’ve seen other comments with M1 Mac issues. In short it doesn’t work on them yet but it should soon.
The error is due to the unhealthy status you mentioned. It’s because the database is not running.
I think we will have to wait for the Docker images to be rebuilt to work on M1 macs.
Also have this problem on Windows
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
Hi Kartik, a few other people have issues with this on the M1 MacBook. In short, the Oracle image not yet supported on the M1 computers.
:( I cry inside when I see this video! Almost change my MAC to WINDOW :( Thanks alot
Thanks! Glad you like it!
Many thanks for this excellent video! Have just worked through all the steps. Good work!
Thanks, glad you like it!
Thank you so much, I installed on my Mac and I didn't have problems. :)
Glad it helped!
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.
Thanks for the feedback! How is the Oracle version setup different to what is shown in this video?
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.
Ah using the M1 Mac could be the cause. In the Pinned Comment I've mentioned that this Docker image does not work on the new M1 Macs, and I don't think a newer image has been released yet.
@@DatabaseStarthank you for clarifying this and thanks a lot for you tutorials. I guess i have no choice but to intall windows via utm.
Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection (CONNECTION_ID=dc4EPuOQRxacr80vWEEmdg==)
Getting this error in while making new connection, please help
What connection details did you use? That error usually means the database is not running or the details entered could not be found.
@@DatabaseStar i used exact same details which you mentioned
@@DatabaseStar Thank you so much this video helped me a lot, I did one some mistake while doing it that's why i was getting the error, now it is connected 😊
Glad you got it working!
@@TanushreeGorai Can you please let me know wat you did, I am facing the same issue
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
(CONNECTION_ID=pP3tiQJ0Q6q5yxSaOUVJyA==)" Do you have an idea why it is happening? I am using Mac with M1 chip
Hey, there are some other comments on here about Docker on M1. Apparently the image doesn’t work on the new Macs yet, but I’ve got an older one which is why this video works.
There may be an updated image that works on M1 macs, but if not we may have to wait for it.
Otherwise that error may mean the Docker container is not running, which you can check with “docker ps”.
Great video! How much of a loss in performance do you get running Oracle via a container versus running it natively on the OS?
Thanks! I haven't used it enough to notice any difference in options. However my main computer is a Mac, so I can't run Oracle natively on the OS (it's only available for Windows and Linux). My other option was using a Virtual Machine with Windows on it, which was much slower than Docker.
@@DatabaseStar thank you!
Thank you for the video. Excellent video. Currently Oracle Database Enterprise Edition is no longer available. So how we can proceed further ?
Ah yeah I’ve heard it’s been removed. I think oracle has their own registry, I’ll find the link and add it to the description or as a comment.
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.
The link is here: container-registry.oracle.com/ords/f?p=113:1:101127284426769:::1:P1_BUSINESS_AREA:3&cs=3HFiPnPXvx0EKYwu8Ec4s4iYEPD8IaKSIseyGZpMbeCUjZ5hjX6uynnD6xPtwzQqtTK5f3yXvwArh8WtEYdDasQ
If that doesn't work, go to container-registry.oracle.com/ords/f?p=113:10::::::
Then go to Database, then Standard, and copy the image from that page.
Hello @Database Star when i connect with the SID i find in my docker image details, my test connection fails, but when i use the SID you gave in this video it works, why is that?
Hi, I think it's because the docker image that was released and available for download is set up with a specific SID.
@@DatabaseStar thanks so much i get it now, i guess that SID is set on default. Thank you.
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
Good questions! I'm not sure how to update the default environment variables. And I've wondered the same about where the data is stored. I've just started with Docker so I'm not sure about either. But I can research it and create videos on them in the future.
@@DatabaseStar I see... guess I'll have to wait them haha thanks anyways
@@DatabaseStar After some researches, I've discovered it! Oracle data is in "/opt/oracle/oradata" folder, you can create a volume for it mapping the volume folder: volume-name:/opt/oracle/oradata.
Great video! What if you want to use sqlplus/sqlcl ? Do these need to be installed separately on your Mac?
Good question. I think you would need to install them separately. I’ve never used sqlcl and haven’t used sql plus on a Mac so don’t know how easy this would be.
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?
Thanks for pointing it out. I've noticed the image comes and goes and other comments say there are issues.
There are two options I think: using Gerald Venzl's version, or from the Oracle Container Registry. I added a comment to the video about this, and I think I'll make a new video on using the Oracle Container Registry to set this up.
Hi
I am unable to get the option Oracle Database Enterprise Edition in the search list. Any idea of the reason?
Yeah, it's because Oracle has since removed the image from Docker Hub. Check out the pinned comment and the description. I've got a video here on how to use their registry to get the image: ruclips.net/video/56dSXI2PbCQ/видео.html
Hi, can I ask you, how to create new user or is it possible? I have healthy oracle database in docker according to your instruction and now I am login as SYS in sqldeveloper. But when I run command: "CREATE USER new_user IDENTIFIED BY user_password" it shows error instead creating new user. Should I login as another user than SYS, or what should I do to create new user?
Thanks :)
It should be possible! What error message are you getting? It could be a permission issue or something to do with Oracle PDB feature.
@@DatabaseStar hi, thanks... I already found solution... it is these for rows ;)
ALTER SESSION SET "_ORACLE_SCRIPT"=TRUE;
CREATE USER IDENTIFIED BY ;
GRANT CREATE SESSION TO ;
GRANT DBA TO ;
Hello Database star, i'm aiming to become an expert in just the field of mysql database development but cannot afford oracles learning subscription fees. can you tell me where/how i can learn everything there is to know about mysql database creation and maintenance free or relatively cheaply. Also, do i stand any chance of a job in database development without formal certificates even if i become an expert in mysql? thanks
Hey, I think you're in the right place to learn for free. There are a lot of channels and videos on RUclips where you can learn about MySQL. I have a couple of videos but there are many others with more information.
Yes, I think you can get a job in database development without a formal education. There are many self-taught developers in the industry so it's definitely possible!
Plz make more videos Sir they're helping a lot ty
Love from india ❤️
Glad you like the videos!
Oracle Database Enterprise Edition is no longer available, thanks
Yeah I think Oracle have removed it from docker hub and added it to their own container repository. I have another video on how to use that on my channel.
Thank you very much, you have helped me a lot. I like and new sub. Greetings from Chile
Thanks, glad you like the videos!
I cannot login in docker , I get this error:
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.
Hmm that's a strange one. I'm not sure how to resolve that one. You might have to look on Google (you may have already tried this)
Could you please help me to create a volume for persisting data? Because if I create a standard oracle user, this user is lost if I stop and start docker. I need some help on how to use the docker compose and create the .yml file. Your help is valuable!
Sure, I created a video recently on how to persist data using Docker. You can check it out here: ruclips.net/video/-pzptvcJNh0/видео.html
@@DatabaseStar Thanks a lot for your prompt reply!
thank you so much.. but I have a questions. let's say I need to import a dumping file, can you explain me how to do that? thank you
Glad you like the video. What's a dumping file? Do you mean an SQL file of a database? It depends on the format of the file, but you should be able to open it and run it.
@@DatabaseStar the scenario is like this: i have a local oracle database installed in my system, now since I know docker (don't laugh, i know I'm late knowing about docker), I want to move the existing schema to docker, to do that, I can't do it by import the sql file. because it's too huge to store it in .sql file.
So all I want to do is dump the database using expdp command and import it with impdp command. To do the impdp, I need a directory that mounted to the docker, so I can map a record in dba_directories to that mounted directory. How can I do that?
I use windows as host.. Thank you so much
maybe the question can be simplified to: How can I mount windows directory to docker?
Ah I understand. Good question. I'm new to Docker as well, and I'm not sure how to do that. It's something I'd like to know, though, because finding and accessing the mounted folder would be useful.
I plan on making a video about this in the future, but for now, I'm not sure how it's done.
@@DatabaseStar i gave you home works.. LOL.. i think i need to subscribe your channel while i'm searching for it too.. maybe you can make a better video about it, once it live i will spread it to my colleague..
Great video! Can you please make a video on how to install Oracle Database on Apple MacOS M1 and initiate Oracle APEX
Good idea, using Oracle on an M1 Mac is a common request. However I don't have an M1 so it would be hard for me to create. I can look into it though.
Hi I m seeing this error: An error was encountered performing the requested operation:
ORA-01017: invalid username/password; logon denied
01017. 00000 - "invalid username/password; logon denied"
*Cause:
*Action:
Vendor code 1017
Hmm have you entered the same connection details mentioned in the video? Is the password case sensitive?
An error was encountered performing the requested operation:
IO Error: The Network Adapter could not establish the connection (CONNECTION_ID=5Nbz34N8Qs6yrzWnK2Cstg==)
Vendor code 17002
Is your container running? If you run "docker ps", does the Oracle container show starting or running as the status? Could you try some of the other solutions mentioned in the comments here?
I am getting this error "Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection (CONNECTION_ID=cXIcM5J/SLu968J8xRtnqA==)" . Have checked listener port hostname etc. all seems correct. For some servers connections working fine but for some, getting this error. Would be grateful if someone could help me out.
That’s odd. If you’re sure the connection details are correct there’s not a lot more I would suggest…
@@DatabaseStar Yes details are correct. But i found that internet is not working in container. even nslookup not working in container. same is working on host server.
Good tutorial. But how did you get the password for the coonection I couldn't understand that moment?
Ah, the password is available on the page on Docker Hub where the details of the Oracle image are found. The image has a password set for the database, and we can just use that.
Great tutorails
Thanks, glad you like it!
Thanks a Lot.
Guys make sure you have a port number specified.
So do we need any license to access it or for the developer version it's free?
Hope you reply soon. Waiting for you ACK.
#Database Star @Database Star
I believe it’s free, maybe for non commercial use, but you can check the license on the download page on Docker Hub.
Status: Failure -Test failed: ORA-01017: invalid username/password; logon denied
I have followed all your steps, This is an error I am facing while setting up, any suggestion is helpful.
I had solved this problem, by just restarting my container.
Good to know it has been resolved.
Great!! it works!
Great!
Do I need to create volume for permanent data like hr schema?
Yes, you'll need to use a mount volume. I'm not sure how to set that up, but I'll look into it and create a video on it soon.
@@DatabaseStar Thanks , you are great.
I tried this on Datagrip and it said that the username and password combination was wrong :(
What error message did you get? Was it the same password you used when you created the image?
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
This error shown after test
Have you used the same connection details as shown in the video or the description? If you want to connect to the pluggable database, you should select Service Name and use ORCLPDB1.localdomain.
@@DatabaseStar I am having this issue as well. It also says my container is unhealthy. Could it be because I am doing all this on M1 processor? It did show a warning about that when I ran the docker image.
@@DatabaseStar yes same as you given
@@jjb.7414 I'm too using in m1
@@DatabaseStar first it show starting after 2 minutes it shown unhealthy
Hi , can this be used on M1 mac? Is it compatible?
Unfortunately it doesn’t work on the new M1 macs. This is because the image has not been created to work with them even though Docker can run. I believe the solution is to wait for the image creator to rebuild it (if they haven’t already).
Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection, getting this error while doing the connection from sql developer
Is the container running? Are the details in your connection correct?
"Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection (CONNECTION_ID=9DqQc946Sz27CN8qcycWyA==)" I am getting this error while create a connection
Is the container running? Have you specified the right server and connection details?
@@DatabaseStar i have resolved my issue regarding my connection, well i had not specified any port on container
@@mr.nobody119 How did you specify the port number.
can I use pl/sql with this setup?
Yea you can. Oracle includes the ability to run PL/SQL on the database.
@@DatabaseStar thank you so much sir
how many gbs takes the download?
I'm not sure, I think it was something like 8GB but it should show when you download it.
when i search for oracle database it doesnt show,first result is oracle linux
It should show in the list somewhere. Perhaps Oracle Linux is more popular on Docker hub.
@@DatabaseStar so ive been able to do all that ,when i typed docker ps.it shows unhealthy
You should try do that on M1 chip.
Yeah I’ve seen that it doesn’t work on the M1 chip. The pinned comment explains more. But unfortunately there is no docker image or VM that you can use for M1 yet, as far as I know :(
@@DatabaseStar yes, I managed to have it locally using lima vm with ubuntu and installing docker on that ubuntu. I've come accros a lot on suggestions to use Ubuntu with UTM. I would give this also a try.
Thanks
You're welcome
the file you show is gone in website
Ah yeah I have heard it was removed then replaced so seems like it was removed again. I think Gerald Venzl has a Docker image that can be used. You can Google for the image name.
Or there may be one on Oracles docker register instead of Docker Hub.
Hello Database star,
Thank you for the video. Unfortunately, I am getting this error
An error was encountered performing the requested operation:
Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
(CONNECTION_ID=DUvhB5/qQTSHon6HF3NrdA==)
Vendor code 12514
Can you please help me with this?
The other error I get when I try to connect Container Database is
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=6wjEvSm4SjyyObrP1lrXEA==)
Hmm that’s an odd one. Is the container running? Have you entered the right host name and service name? This is a common issue connecting to Oracle databases.
Hi Shakira, I got this error today actually. I couldn't work out why, but I waited about a minute or so and tried again, and the connection worked. Perhaps there is something in the background inside the container that needs to start up before it will accept connections.
@@DatabaseStar I still get the same error as @shakira
after trying this way
it's not working
What issue are you having?
DBCA
What do you mean?
How can I connect remotely With Docker Image Installed Oracle Database ?
What is the I.P Address and what is the TNSORANAMES.ora file of this Database ?
Good question, I'm not sure how you would do that actually.
@@DatabaseStar Well, I guess, Your next task is to find the answer to my question in order to be called " Database Star ".
i got this error Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection (CONNECTION_ID=k+d0YojcTjWXAp27XETfoQ==)
I think there are some other comments with the same issue. Could you check the port number used? Or wait a minute until the service has started? I thinks that’s what others have done.
Status : Failure -Test failed: IO Error: Got minus one from a read call, connect lapse 7 ms., Authentication lapse 0 ms. I am getting this error
Where are you seeing this error? In the terminal/command line, or SQL Developer, or another IDE?
@@DatabaseStar by a miracle it is working now. I got the error on SQL Dev , VSCODE with oracle sql tools plugin and I even tried DBEaver same thing so after hours of searching and trying to find out where is the problem nothing seemed to work. Today I found out that i was forgetting to hit the "docker start " command I was furious man.
Glad you got it working! Docker is fairly new to me and many others so I’m glad you could get it working too.