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.
@ttc744 Жыл бұрын
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
@2012oyt Жыл бұрын
There is a FREE version available now
@jnnfnt082 жыл бұрын
This video came at a perfect time! I appreciate that you updated the previous Oracle + Docker video. Thank you!
@DatabaseStar2 жыл бұрын
Awesome! Glad it was helpful for you.
@shutterassault12 жыл бұрын
This was very helpful. First video on setting up Oracle on Docker for Windows that actually worked for me!
@DatabaseStar2 жыл бұрын
Thanks, glad it was useful!
@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.
@DatabaseStar Жыл бұрын
Thanks for the tip!
@OthmaneLarhzal10 күн бұрын
I'm trying to pull the image, but it says that I'm unauthorized, even though I'm logged in and have accepted the license agreement
@DatabaseStar10 күн бұрын
Oh that's strange. Perhaps one of the parameters is wrong, or something has changed on the Oracle repository since creating this video, and the "unauthorized" is a generic error message.
@guipingren5449 Жыл бұрын
ORA-12505: TNS:listener does not currently know of SID given in connect descriptor
@DatabaseStar Жыл бұрын
Whcih SID are you using? Is the docker container running?
@cuttanoleonardo4099 Жыл бұрын
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
@DatabaseStar Жыл бұрын
Is the status of the container showing as running? Sometimes I got this error when it was started but not yet running.
@Maruko____ Жыл бұрын
@@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
@pkilpo2 жыл бұрын
I got TLS error from oracle default repository. I used another mirror where Frankfurt worked for me. Mirrors are listed on oracle repository page.
@DatabaseStar2 жыл бұрын
Good to know!
@hansbaumberger4234 Жыл бұрын
I want to use the image in a docker-compose.yml file. What would be the ORACLE_USER, and ORACLE_DB_HOST ??
@DatabaseStar Жыл бұрын
Hmm I'm not sure, I don't have a lot of experience using docker-compose files unfortunately.
@user-ll5qj9tj5c2 ай бұрын
first time it was connected but lator when i open again vs code and try to connect it shows error
@DatabaseStar2 ай бұрын
Oh what error did you get?
@edissongabriellopezsalaman97162 жыл бұрын
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.
@DatabaseStar2 жыл бұрын
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?
@edissongabriellopezsalaman97162 жыл бұрын
@@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
@carlosmanuelalvaradoandrad38012 жыл бұрын
@@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. 😁
@edissongabriellopezsalaman97162 жыл бұрын
@@carlosmanuelalvaradoandrad3801 It didn't work :c thanks anyway
@pavlosharov90272 жыл бұрын
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.
@almaraya2889 Жыл бұрын
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
@DatabaseStar Жыл бұрын
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.
@marieclairemichelledelacru48534 ай бұрын
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
@DatabaseStar4 ай бұрын
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.
@singlaarun19796 ай бұрын
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?
@DatabaseStar6 ай бұрын
I can't see it either, but I have a link to an env file I used in the video description.
@laurallinares4456 Жыл бұрын
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
@DatabaseStar Жыл бұрын
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.
@ihorvolkov5600 Жыл бұрын
hey laura, please check my answer to the comment above.
@alitc3002 жыл бұрын
You were right, it works now, thanks a lot for your help. An incredible video.
@DatabaseStar2 жыл бұрын
You're welcome!
@bhanukafernando4017Ай бұрын
do you have a mac m1???
@locktharcillo Жыл бұрын
ty couldn't found the official oracle db in docker hub! very good tutorial
@DatabaseStar Жыл бұрын
Thanks, glad you like it!
@alitc3002 жыл бұрын
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?
@DatabaseStar2 жыл бұрын
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.
@rmcavalhoo Жыл бұрын
Your explanation is very good
@DatabaseStar Жыл бұрын
Thanks!
@bcassilhas2 жыл бұрын
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?
@DatabaseStar2 жыл бұрын
Oh I've never seen that before actually!
@lefique181 Жыл бұрын
Perfect explanatory video . I have an error message "docker deamon is not running .system cannot find the file specified
@DatabaseStar Жыл бұрын
Thanks! Is the Docker application running? Sometimes I get this when I haven't opened the Docker application (in the user interface).
@felipehenriquez1896 Жыл бұрын
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 😅)
@DatabaseStar Жыл бұрын
Could you use the SID of OraDoc to connect in VS Code (the same one shown in this video in SQL Developer)?
@alexsal6069 Жыл бұрын
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 😅
@user-lw3vj1fs5m11 ай бұрын
Hi , how can i add a volume so that the data is not lost after restarting the container?
@DatabaseStar11 ай бұрын
Hey, I've created a video here to explain how to do that: kzbin.info/www/bejne/Y6HdoaesmK-BnpI
@stephenunsure2943 Жыл бұрын
Brilliant video thanks Ben.
@DatabaseStar Жыл бұрын
Thanks!
@ashribadmohanty4366 Жыл бұрын
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!
@bakyayita Жыл бұрын
M1 that’s a no go zone…
@DatabaseStar Жыл бұрын
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.
@siddharthmehta422311 ай бұрын
😐Listener refused the connection with the following error : ORA-12505, TNS: listener does not currently know SID given in connect descriptor.
@DatabaseStar11 ай бұрын
Have you put the right details in? Might be something Google can answer
@judiTOMBO Жыл бұрын
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
@DatabaseStar Жыл бұрын
That’s strange. Is the container running and still in the starting status?
@baskhuubatpurev1307 Жыл бұрын
I faced same issue. Did you solve it? (I followed exactly the same procedure as in this video)
@baskhuubatpurev1307 Жыл бұрын
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
@niveditha55782 жыл бұрын
Thank you for thr video. But it is version 12.1 How to use for versions 12.2 or higher? Please reply
@DatabaseStar2 жыл бұрын
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 :(
@weijiephua41922 жыл бұрын
Thanks, could u do a video regards to CDB vs PDB? Having trouble creating users
@DatabaseStar2 жыл бұрын
Good idea! I got this confused for so long when it was introduced so I can create a video on it.
@weijiephua41922 жыл бұрын
@@DatabaseStar Appreciate thanks! looking forward
@edhahaz6 ай бұрын
What a pain. Container running with environment variables set from the .dat file, connection doesn't work. No way to debug.
@DatabaseStar6 ай бұрын
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?
@dreaminginrgb6165 Жыл бұрын
while trying to connect from sql developer , getting io error. network adapter could not establish connection
@DatabaseStar Жыл бұрын
Aah. Is the database running? Is the SID entered correctly in the connection window?
@KenjiVdusc Жыл бұрын
Same issue, it seems correct, but i try to connect from a network-client not from the local machine itself
@josuepimentel2488 Жыл бұрын
perfectly helpful.. thank you!
@DatabaseStar Жыл бұрын
Glad it was helpful!
@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)
@DatabaseStar Жыл бұрын
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.
@KenjiVdusc Жыл бұрын
@@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.
@KenjiVdusc Жыл бұрын
@@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.
@megajoe811 Жыл бұрын
M1 compatibility has been added now!
@DatabaseStar Жыл бұрын
Oh wow! That’s great. Is this for all database images or just one of the new ones?
@negi.priyanka Жыл бұрын
Hello. Does that process still not work on mac m1?
@DatabaseStar Жыл бұрын
As far as I know it still doesn't work. I don't know if Oracle has released updated images.
@sameerkurhade643611 ай бұрын
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
@sameerkurhade643611 ай бұрын
any other option is available for connect sql developer to orcale database in mac m2 os plz help me
@DatabaseStar11 ай бұрын
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.
@tonycavanagh1929 Жыл бұрын
Standard has been removed. what should we use instead
@DatabaseStar Жыл бұрын
That's odd. I'm not sure why. I've asked around on Twitter. For now, you could try the Express Edition.
@tonycavanagh1929 Жыл бұрын
@@DatabaseStar Yes I am using Express Edition, on got it working. Its been removed, but no reason why.
@ryanstephanus2 жыл бұрын
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,
@DatabaseStar2 жыл бұрын
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.
@ryanstephanus2 жыл бұрын
@@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
@miguelramalho8563 Жыл бұрын
great video!!!
@DatabaseStar Жыл бұрын
Thank you!!
@jonattansalcedo6924 Жыл бұрын
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?
@DatabaseStar Жыл бұрын
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
@greatsunday4780 Жыл бұрын
It is very helpful.
@DatabaseStar Жыл бұрын
Glad you think so!
@hadjerjoo6744 Жыл бұрын
Thank you so much !
@DatabaseStar Жыл бұрын
You’re welcome!
@HamidShehzad-bs8dw4 ай бұрын
you chose standard version but now standard version is not there
@abdelmouncifmoussaoui28784 ай бұрын
same here😥
@DatabaseStar4 ай бұрын
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.
@dev.daniels Жыл бұрын
How can I connect to eclipse ?
@DatabaseStar Жыл бұрын
You could use the same connection details used in this video to connect from Eclipse to the database.
@meghnadsaha24695 ай бұрын
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==)
@DatabaseStar5 ай бұрын
Is the database running?
@souravshome26022 жыл бұрын
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.
@DatabaseStar Жыл бұрын
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?
@dogancanaslan82632 жыл бұрын
when ı try to login using terminal and download image, ı get a error like password required.
@dogancanaslan82632 жыл бұрын
what's ur advice? thanks in advance
@DatabaseStar2 жыл бұрын
Have you tried entering the password? In the process in this video you need an account on the Oracle website.
@parambharti7095 Жыл бұрын
Awesome. Thanks
@DatabaseStar Жыл бұрын
You're welcome!
@sourabhjambale132 жыл бұрын
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?
@DatabaseStar2 жыл бұрын
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.
@sourabhjambale132 жыл бұрын
@@DatabaseStar thank you. How can I resolve the error?
@DatabaseStar2 жыл бұрын
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?
@junioretso96 Жыл бұрын
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
@DatabaseStar Жыл бұрын
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.
@junioretso96 Жыл бұрын
@@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?
@educationtatva Жыл бұрын
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
@educationtatva Жыл бұрын
Oh Seems like it ran after adding --platform linux/amd64
@DatabaseStar Жыл бұрын
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.
@jephtahogyefoacquah55242 жыл бұрын
You are the best okay
@DatabaseStar2 жыл бұрын
Thanks!
@bakyayita Жыл бұрын
Thanks 🎉 🎉 can you add on apex+ords ?
@DatabaseStar Жыл бұрын
I assume you can, but I've got no experience with that.
@Sotelord2 жыл бұрын
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
@DatabaseStar2 жыл бұрын
Ah I haven't seen that error before, but I think there are other comments with the same issue.
@georgejetson9801 Жыл бұрын
Oracle sure makes it difficult to do something simple.
@DatabaseStar Жыл бұрын
They sure do!
@georgejetson9801 Жыл бұрын
@@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.
@vincentadams3807 Жыл бұрын
Thanks for the video man. I despise oracle, they make everything so complicated....
@DatabaseStar Жыл бұрын
No problem, glad it was helpful!
@pratikgaurav653 Жыл бұрын
Informative 😍 , but Oracle have updated the web-site.
@DatabaseStar Жыл бұрын
Thanks! Yeah they update it pretty often from what I've seen.
@gorakhnathupadhyaygarry Жыл бұрын
thanks but please share the env file.
@DatabaseStar Жыл бұрын
Which env file are you referring to?
@Jeromegilgen2 жыл бұрын
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.
@DatabaseStar2 жыл бұрын
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.
@Jeromegilgen2 жыл бұрын
@@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.
@leedy8135Ай бұрын
i cant understand ...
@DatabaseStarАй бұрын
What part of it is hard to understand? Happy to help explain it.
@javizamudio7688 Жыл бұрын
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
@DatabaseStar Жыл бұрын
Yeah the documentation is pretty hard to follow sometimes. Glad you liked this video.
@yingyingz9724 Жыл бұрын
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'. 😂
@DatabaseStar Жыл бұрын
Thanks! I'm not sure what that means or how to resolve it unfortunately.
@kurmi_santosh Жыл бұрын
You might be using textEdit. Please use Atom and save the env file.
@greatsunday4780 Жыл бұрын
@@kurmi_santosh thanks, you are very helpful.
@wildhandb Жыл бұрын
ORA-12537: TNS Connection Closed
@DatabaseStar Жыл бұрын
Does this happen when you connect or when you try to run a query or some other time?
@qixia102 жыл бұрын
M1 Mac 0:35
@DatabaseStar2 жыл бұрын
Good to know!
@pranshuc Жыл бұрын
Still, Apple chip isn't supported by Oracle, what a joke!
@DatabaseStar Жыл бұрын
I know, it’s been years and other databases support it, but not Oracle
@MohsenTaheri846 ай бұрын
Like
@DatabaseStar6 ай бұрын
Thanks!
@retropaganda84423 ай бұрын
Thumb down for using the Macintosh OS. Nobody uses that in the business!
@DatabaseStar3 ай бұрын
Hah! I’ve seen about a 50/50 split between MacOS and Windows in the last few years for developers!
@georgel36893 күн бұрын
Oracle database is really piece of sh*t
@DatabaseStar22 сағат бұрын
Yeah it can be hard to set up
@theobloquet392 жыл бұрын
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.
@DatabaseStar2 жыл бұрын
Glad to hear you got it working
@shinnize2 жыл бұрын
You did for the docker part since doker is supposed to generate ips by components but these are not linked in the network bridge?
@pratikbarbudhe40412 жыл бұрын
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.
@pratikbarbudhe40412 жыл бұрын
Please help
@pratikbarbudhe40412 жыл бұрын
IN windows
@DatabaseStar2 жыл бұрын
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?
@pratikbarbudhe40412 жыл бұрын
@@DatabaseStar I Dont have admin account or admin rights. Sir
@DatabaseStar2 жыл бұрын
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.
@alexandrabindiu2724 Жыл бұрын
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==)
@DatabaseStar Жыл бұрын
Are you using the connection details provided by Oracle on their page?