M1 Mac: Are you running an M1 Mac? If so, you'll likely get errors when trying to install or connect to the database in the virtual machine. This is because the VirtualBox and/or the image does not support the M1 CPUs in the newer Mac computers. The other option for setting up Oracle is using Docker, but that also does not work with M1. I created a video recently on how to set up a free Oracle Cloud account which will work on M1 (as long as your IDE, such as SQL Developer, will work). You can watch that video here: ua-cam.com/video/3RJ5jMi8YUQ/v-deo.html This is the only way to get Oracle to work on M1 Macs as far as I know, until the Docker images or VM images are updated.
Thanks! Really clear and easy. And I have to recognize that I had wasted two days of my like trying this on my own. The video is gold for me! Now, to learn SQL in your Udemy course!
Thank you for the hard work putting together this video! It worked perfectly. I did receive a Legacy System Extension warning about the Oracle America,Inc extension that might not be compatible with a future Mac OS. I'm on Monterey. We all may have to switch to Docker? I'll cross that bridge when we get to it. I saw your Docker video and this was so much easier.
Thanks for the comment! Glad you got it working. As far as I know using a VM will still work in the future. There’s an issue where they don’t quite work on the new M1 Macs but that will get solved soon I think.
Glad you like the video! I may have been talking a little quieter than normal, as I record my videos early in the morning when others are sleeping but increase the volume during editing. Hope it's not too hard to hear.
How do we get admin privileges to create user and grant because I cannot seem to change the role and enter the same password provided in the video. Error observed while trying to select connect option.
@@DatabaseStar When I try to create a user, it gives this error "ORA-01031: insufficient privileges 01031. 00000 - "insufficient privileges" *Cause: An attempt was made to perform a database operation without the necessary privileges. *Action: Ask your database administrator or designated security administrator to grant you the necessary privileges ". And if I try to change to any other role on properties, the connection gives me another error like this saying "Cannot connect to database, username/password wrong"
Hi, I have a question: I have just imported and set-up the DeveloperDays Oracle VM. However, when I try to run it by double-clicking that VM, I then see endless commands running on screen - these appear to console commands that are running by default and don't seem to stop. And I never see the Linux Desktop. Please help!
Hi, that's interesting. I remember when running that VM there was a lot of commands that appear, but eventually saw the Linux desktop. I don't know why the desktop would not be appearing. What operating system is your computer running? If it's one of the new Macs (M1 or M2 processor) then it may be the reason.
Thanks for the video. What do you do when you get the following error when trying to connect to SQL:? “Test Failed : IO Error: The Network Adapter could not establish the connection”.
No problem1 That one could be because the VM is not running or not completely started, or the Service Name/SID or database name is incorrect. It could also be some kind of network issue between the VM and the host, but those are less likely with the new VMs.
Hello, I have to install oracle 11g and SQL developer for class. I looked on all sited, but i haven't found one that talks about oracle 11g for MAC. can you please let me know what i need to download ? is Oracle Developer VM another name for oracle 11g ? Thank you
You can follow these steps to install the Oracle Database that Oracle provides using their VM, which I think is either 19c or 20c. Alternatively, you can use a program called Parallels (or VirtualBox) to run Windows, then install Oracle 11g on that. However, I would question the need to install 11g specifically, as 11g is a very old version and I believe it's been discontinued. All of the basics in 11g also apply to recent versions such as 19c and 20c, so try those instead.
Yeah that’s right, the new M1 Mac does not support Virtualbox or even Docker images yet. The only solution I’ve found is using Oracle Free Cloud tier. Or maybe using a VM in Parallels but I’m not sure if that works either.
Why is that after i try tu push start green button in oracle vm virtuam box manager, its an error pop up saying that "Kernel driver not installed" pls help.
looks like virtual machine can't run on the new macbooks. just got my new macbook yesterday. Any new recommendations? "The installer has detected an unsupported architecture. VirtualBox only runs on the amd64 architecture."
Kernel driver not installed (rc=-1908) Make sure the kernel module has been loaded successfully. where: suplibOsInit what: 3 VERR_VM_DRIVER_NOT_INSTALLED (-1908) - The support driver is not installed. On linux, open returned ENOENT.
Ah yes I have since found out from the comments here that it doesn't work with the new MacBooks. Docker is an alternative, but the images need to be built to work on the new MacBook which has not been done yet.
I don't have a connect button on my screen (its invisible), only test. I have downloaded SQL Developer again and the connect button is still not there. Do you have a solution for this?
What operating system are you using? Did you download it from the Oracle website? Is there a menu option for Connect? I've always seen the connect button so unsure why it's missing.
Are you running the M1 Mac? If so, then there are known issues with virtual machines and Oracle (I've added more info to a pinned comment). If you're not on an M1 Mac, then it should work, and I'm not sure why it's not...
Hmm I’ve heard of some recent issues with SQL Developer on newer versions of macOS. I’ve had recent issues that I haven’t fixed. Is there anything helpful on Google to solve your issue?
Yes you should be able to do both. When you set up the connection, you'll probably have different connection details so you know which one you are connecting to.
at 7:10 I get "Kernel driver not installed (rc=-1908) Make sure the kernel module has been loaded successfully" Until that moment its all exactly the same as shown at your video. I am running BigSur. Any advice how to mitigate the issue will be highly appreciated. Thanks in advance.
Hmm, that's a tricky one. I'm not sure what that error means. It may have something to do with how the VM runs on Big Sur and that Big Sur is the latest OS. I would suggest looking on Google if you haven't already.
Thanks for video, I am getting ORA-28040: No maching authentication protocol While connecting Java app with Oracle DB. Can you plz help how to resolve this?
When I download vmbox for mac it says "Unsupported hardware architecture detected! The installer has detected an unsupported architecture. VirtualBox only runs on the amd64 architecture."
@@DatabaseStar Yes, I realized it is not possible with new M1 chips. What do you think about parallels? Is it worth to run oracle db on parralels windows? Not found better solution for this yet.
Hello, Thank you for creating this and the other videos you have on your channel, they are very helpful. I do have a question about connecting to a database though. When you connect as you have advised in the video, the database that is produced has preset tables, is this standard for databases in oracle? I need to complete a project in which I have designed and will code a database, and I am trying to see if these preset tables (assign,countries, departments, etc...) can be removed. Thanks!
Hey, thanks for the comment and glad you like the video! No, those tables will not be in the database. I had created these as part of some other work I did. When you set up a database like in this video it should be empty.
@@DatabaseStar Sorry, I wasn't clear, those tables DO appear on my newly created connection database. They are assign, countries, departments, employees, etc...
Oh I see. Perhaps they do come with the database then and they weren’t created by me! They could be part of the standard schema or data that comes with the database as you have seen. I think you can remove them - you could try and see if it works.
Everything work, expect i keep getting the error 12514. I try looking in the Virtualbox Oracle Linux folders but I can't find TNSnames anywhere any solutions? I did it exactly how your video did. The error occur in Mac Oracle sql connection and in the virtual box Oracle as well.
Hmm I've never seen that before. What does Google say? If that doesn't work you can try using Docker: I have another video on my channel for that here ua-cam.com/video/OTglm9fVCL4/v-deo.html&lc=Ugy1xijEtU8TeLr7ZEp4AaABAg
thanks a lot for the video but I keep havin the same response many times ERROR THE NETWORK COULND NOT ESTABILISH CONNECTION , ps. Im on mac if it matters thanks again
I'm not sure how to do it on the new M1 MacBooks. I've heard (and seen other comments on this video) that this process doesn't work, and I'm not sure what the solution is
Thanks for letting me know they don’t work on the brand new Macs. I have heard something about that. However it’s not a misleading title: it worked as of 2020 and still works on all Macs except the ones you mentioned, until the VM software is improved. I’ll add a pinned comment for others coming to this video.
I don’t think it does at the moment unfortunately, as the images need to be updated to work on them. Other comments have errors when running on M1 chips. I don’t know if there is a newer image that works yet.
@@DatabaseStar Hi. i had tried your suggestion and for few days it was working perfectly fine but all of a sudden 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 Vendor code 12514
@@DatabaseStar Hi sir, after clicking connect for Oracle DB Developer on the VM, it says : Failed to open a session for the virtual machine Oracle DB Developer VM1. Details: The virtual machine 'ORACLE DB Developer VM1' has terminated unexpectedly during startup with exit code 1 (0x1). Result code: NS_ERROR_FAILURE (0x80004005) Component: MachineWrap Interface: IMachine{85632c68-b5bb-4316}
I filled name, username , password as u did bt getting error as: invalid username/password; login denied When connecting . I given these... Enter Name : VirtualBox Oracle Password : oracle
I feel the audio is little feeble that I need to use my earphones to listen clearly... I generally don’t face this problem for other videos in UA-cam... Thank you
Are you running this on an M1 Mac? Which version of MacOS are you on? I've seen in other recent comments that there are issues with running it on M1 Macs.
M1 Mac:
Are you running an M1 Mac? If so, you'll likely get errors when trying to install or connect to the database in the virtual machine. This is because the VirtualBox and/or the image does not support the M1 CPUs in the newer Mac computers. The other option for setting up Oracle is using Docker, but that also does not work with M1.
I created a video recently on how to set up a free Oracle Cloud account which will work on M1 (as long as your IDE, such as SQL Developer, will work). You can watch that video here: ua-cam.com/video/3RJ5jMi8YUQ/v-deo.html
This is the only way to get Oracle to work on M1 Macs as far as I know, until the Docker images or VM images are updated.
Thanks! Really clear and easy. And I have to recognize that I had wasted two days of my like trying this on my own. The video is gold for me! Now, to learn SQL in your Udemy course!
Awesome, glad you like the video!
Awesome. This video has helped me a lot. Thanks, really appreciate your effort.
Glad it helped!
thanks, still working in 2023.
Good to know!
Thanks heaps.. It worked as expected.. cheers mate
Glad it helped!
Thank you for the hard work putting together this video! It worked perfectly. I did receive a Legacy System Extension warning about the Oracle America,Inc extension that might not be compatible with a future Mac OS. I'm on Monterey. We all may have to switch to Docker? I'll cross that bridge when we get to it. I saw your Docker video and this was so much easier.
Thanks for the comment! Glad you got it working. As far as I know using a VM will still work in the future. There’s an issue where they don’t quite work on the new M1 Macs but that will get solved soon I think.
can you provide me with a link
dude is someone sleep in your room why're you whispering ? but great video very helpful thank you so much❤️
Glad you like the video! I may have been talking a little quieter than normal, as I record my videos early in the morning when others are sleeping but increase the volume during editing. Hope it's not too hard to hear.
@@DatabaseStar its perfect I was just joking 😂❤️
It works on Windows 10 Home too. Thanks, very useful tutorial
You're welcome!
Thanks sir for making this video..
No problem!
Finally it works! Thank you so much !!
You're welcome!
How do we get admin privileges to create user and grant because I cannot seem to change the role and enter the same password provided in the video. Error observed while trying to select connect option.
Oh, what error message are you getting? The account provided should have DBA privileges.
@@DatabaseStar When I try to create a user, it gives this error "ORA-01031: insufficient privileges
01031. 00000 - "insufficient privileges"
*Cause: An attempt was made to perform a database operation without
the necessary privileges.
*Action: Ask your database administrator or designated security
administrator to grant you the necessary privileges
". And if I try to change to any other role on properties, the connection gives me another error like this saying "Cannot connect to database, username/password wrong"
Hi, I have a question: I have just imported and set-up the DeveloperDays Oracle VM. However, when I try to run it by double-clicking that VM, I then see endless commands running on screen - these appear to console commands that are running by default and don't seem to stop. And I never see the Linux Desktop. Please help!
Hi, that's interesting. I remember when running that VM there was a lot of commands that appear, but eventually saw the Linux desktop. I don't know why the desktop would not be appearing. What operating system is your computer running? If it's one of the new Macs (M1 or M2 processor) then it may be the reason.
Thanks for the video. What do you do when you get the following error when trying to connect to SQL:? “Test Failed : IO Error: The Network Adapter could not establish the connection”.
No problem1 That one could be because the VM is not running or not completely started, or the Service Name/SID or database name is incorrect. It could also be some kind of network issue between the VM and the host, but those are less likely with the new VMs.
Next , how can I data dump import ? Any video please
You can right click on the database I think and select Import to load some data into the database r
Hello, I have to install oracle 11g and SQL developer for class. I looked on all sited, but i haven't found one that talks about oracle 11g for MAC. can you please let me know what i need to download ? is Oracle Developer VM another name for oracle 11g ? Thank you
You can follow these steps to install the Oracle Database that Oracle provides using their VM, which I think is either 19c or 20c. Alternatively, you can use a program called Parallels (or VirtualBox) to run Windows, then install Oracle 11g on that.
However, I would question the need to install 11g specifically, as 11g is a very old version and I believe it's been discontinued. All of the basics in 11g also apply to recent versions such as 19c and 20c, so try those instead.
This was a smooth. Thanks
Glad you liked it!
Thank you very much for uploading very good video.
Glad you like it!
Virtual box does not support the MacBook air m1 2020. Please let me know of any other suggestions
Yeah that’s right, the new M1 Mac does not support Virtualbox or even Docker images yet. The only solution I’ve found is using Oracle Free Cloud tier. Or maybe using a VM in Parallels but I’m not sure if that works either.
Why is that after i try tu push start green button in oracle vm virtuam box manager, its an error pop up saying that "Kernel driver not installed" pls help.
Hmm I’ve never seen that error before. What MacOS version are you running? Have you seen any other solutions on Google?
looks like virtual machine can't run on the new macbooks. just got my new macbook yesterday. Any new recommendations?
"The installer has detected an unsupported architecture. VirtualBox only runs on the amd64 architecture."
Kernel driver not installed (rc=-1908)
Make sure the kernel module has been loaded successfully.
where: suplibOsInit what: 3 VERR_VM_DRIVER_NOT_INSTALLED (-1908) - The support driver is not installed. On linux, open returned ENOENT.
Ah yes I have since found out from the comments here that it doesn't work with the new MacBooks. Docker is an alternative, but the images need to be built to work on the new MacBook which has not been done yet.
I don't have a connect button on my screen (its invisible), only test. I have downloaded SQL Developer again and the connect button is still not there. Do you have a solution for this?
What operating system are you using? Did you download it from the Oracle website? Is there a menu option for Connect? I've always seen the connect button so unsure why it's missing.
awesome awesome awesome. it was worth to watch your video. successful!!!!!!
Thanks, glad you like it!
it's not working on my macbook pro. it showing failed to import application. please tell me how to fixed it
Are you running the M1 Mac? If so, then there are known issues with virtual machines and Oracle (I've added more info to a pinned comment). If you're not on an M1 Mac, then it should work, and I'm not sure why it's not...
when i try to connect it displays error 12514 and i change to SID it is still error, how to fix that? and thank you
I would suggest Googling the error message, you'll find a few posts and Stack Overflow questions with some possible solutions.
When I try using the SQL Developer app it doesn’t let me and says that I can’t open it because it’s not in its classic environment.
Hmm I’ve heard of some recent issues with SQL Developer on newer versions of macOS. I’ve had recent issues that I haven’t fixed. Is there anything helpful on Google to solve your issue?
All went good except SQL developer step. I can't open SQL developer and I have downloaded jdk-8u291-macosx-x64 .dmg What should I do?
Are you running Big Sur? I’ve heard of a recent issue with opening it on big sur. If so I don’t know the solution but I think its available on Google.
Thanks a lot!very helpful.
Glad it was helpful!
Can I install Oracle Express Edition 21c after installing VirtualBox ??? Will the combination work ??
Yes you should be able to do both. When you set up the connection, you'll probably have different connection details so you know which one you are connecting to.
I got "Kernel driver not installed (rc=-1908)"error when i clicked on START arrow. Help?
I've never seen that before. I would suggest Googling the error: perhaps Stack Overflow or somewhere else has a solution
at 7:10 I get "Kernel driver not installed (rc=-1908) Make sure the kernel module has been loaded successfully"
Until that moment its all exactly the same as shown at your video. I am running BigSur. Any advice how to mitigate the issue will be highly appreciated. Thanks in advance.
Hmm, that's a tricky one. I'm not sure what that error means. It may have something to do with how the VM runs on Big Sur and that Big Sur is the latest OS. I would suggest looking on Google if you haven't already.
i have this problem as well... but i dont how to settle it...
hello) I have same problem now. Did you solve it?) Can you help me
Did you solve this problem?
Did anyone fixed this error??
I have an error 12514 but i put everything like in the video.
I would suggest Googling the error message, you'll find a few posts and Stack Overflow questions with some possible solutions.
Thanks for video, I am getting ORA-28040: No maching authentication protocol
While connecting Java app with Oracle DB. Can you plz help how to resolve this?
I’m not sure what this would be. Have you found anything on Google?
When I download vmbox for mac it says "Unsupported hardware architecture detected! The installer has detected an unsupported architecture. VirtualBox only runs on the amd64 architecture."
Are you running the new M1 Mac? If so that may be the cause. There are other comments here from others who are having the same issue I think.
@@DatabaseStar Yes, I realized it is not possible with new M1 chips. What do you think about parallels? Is it worth to run oracle db on parralels windows? Not found better solution for this yet.
Hello, Thank you for creating this and the other videos you have on your channel, they are very helpful. I do have a question about connecting to a database though. When you connect as you have advised in the video, the database that is produced has preset tables, is this standard for databases in oracle? I need to complete a project in which I have designed and will code a database, and I am trying to see if these preset tables (assign,countries, departments, etc...) can be removed. Thanks!
Hey, thanks for the comment and glad you like the video! No, those tables will not be in the database. I had created these as part of some other work I did. When you set up a database like in this video it should be empty.
@@DatabaseStar Sorry, I wasn't clear, those tables DO appear on my newly created connection database. They are assign, countries, departments, employees, etc...
Oh I see. Perhaps they do come with the database then and they weren’t created by me! They could be part of the standard schema or data that comes with the database as you have seen. I think you can remove them - you could try and see if it works.
Everything work, expect i keep getting the error 12514. I try looking in the Virtualbox Oracle Linux folders but I can't find TNSnames anywhere any solutions? I did it exactly how your video did. The error occur in Mac Oracle sql connection and in the virtual box Oracle as well.
did you find a solution mate?
Yeah it can be hard to find tns names. Did you check the service is running? Have you fixed the problem since?
I have issue in m1 mac when i hit green start button it shows some error plz reply with solution its urgent
What error are you getting?
@@DatabaseStar its getting error like some ports are missing.
I can't run the VM because I had an error ( kernel driver not installed ) ? what to do
Hmm I've never seen that before. What does Google say? If that doesn't work you can try using Docker: I have another video on my channel for that here ua-cam.com/video/OTglm9fVCL4/v-deo.html&lc=Ugy1xijEtU8TeLr7ZEp4AaABAg
Thank you for this video but, it shows an Error when importing .OVA file
No problem! What error are you getting?
does this work in macbooks with m1 chip? i heared that virtual box doesn't work with them
I’m not sure but I’ve heard people have problems with the M1 MacBook. I have a recent video on using Docker so perhaps that can work?
@@DatabaseStar I am sure there is no solution for docker as well, but if I am wrong please give me some info.
thanks a lot for the video but I keep havin the same response many times ERROR THE NETWORK COULND NOT ESTABILISH CONNECTION , ps. Im on mac if it matters thanks again
Are your connection details correct? Is the virtual machine running?
@@DatabaseStar vm was not running , thanks alot , you are amazing 🙌 !
Iam unable to install virtual box, I tried for my macbook air m1
Yeah, several other people commented with the same issue as it doesn’t yet work on the new Macs.
Hi can you help to install oracle in macbook air m1 2021
I'm not sure how to do it on the new M1 MacBooks. I've heard (and seen other comments on this video) that this process doesn't work, and I'm not sure what the solution is
Can you make a video for that error in start (4:18) I can't understand that in your blog
Good idea!
Thank you so much!!!!
You're welcome!
I never get to the linux desktop part, stays on the black screen
Oh I would suggest looking at the Oracle forums or Stack Overflow.
@@DatabaseStar Got It donde tried a diferentes version of the vm
thanks sir, after downloading developerdays.ova IDK why i got the file in .txt format :(( can u help?
Could you download the file again? Or rename it to .ova?
@@DatabaseStar thank you so much!
Thanks you very much 🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻
You're welcome!
Misleading title: This does NOT work in 2020 as M1 Macs use Apple silicon which do not execute x86 VMs.
Thanks for letting me know they don’t work on the brand new Macs. I have heard something about that.
However it’s not a misleading title: it worked as of 2020 and still works on all Macs except the ones you mentioned, until the VM software is improved.
I’ll add a pinned comment for others coming to this video.
Will this work on the M1 chip?
I don’t think it does at the moment unfortunately, as the images need to be updated to work on them. Other comments have errors when running on M1 chips. I don’t know if there is a newer image that works yet.
Im getting an error when im downloading the oracle vm
What error are you getting?
Everything is fine but a terminal is not appearing . Its just plain black. .
Could you try restarting the virtual machine?
@@DatabaseStar Hi. i had tried your suggestion and for few days it was working perfectly fine but all of a sudden 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
Vendor code 12514
Hi Sir, does this work on the M1 MacBook Air?
I'm not sure, it would depend if the Virtual Machine software has made any updates to ensure it still works.
@@DatabaseStar Hi sir,
after clicking connect for Oracle DB Developer on the VM, it says :
Failed to open a session for the virtual machine Oracle DB Developer VM1.
Details:
The virtual machine 'ORACLE DB Developer VM1' has terminated unexpectedly during startup with exit code 1 (0x1).
Result code: NS_ERROR_FAILURE (0x80004005)
Component: MachineWrap
Interface: IMachine{85632c68-b5bb-4316}
Thanks for responding man, appreciate it
@@mikechng6695 hey were you able to resolve the issue? I am facing the same problem on my m1 Mac :(
@@samviddasari4168 Hey samvid. Sadly no, i have returned the macbook and bought a windows laptop G14 Zephyrus. Works like a charm now
Anyone got it working for M1 MacBook Air?
What issues are you having?
I love you good sir
Haha thanks!
is it work for m1?
I think it should work, the concept would not have changed
I filled name, username , password as u did bt getting error as: invalid username/password; login denied
When connecting .
I given these...
Enter Name : VirtualBox Oracle
Password : oracle
Is the Virtual Machine running? Is the SID correct? Which username did you use?
@@DatabaseStar username : hr
If it's the same as what Oracle mentions in their documentation, it should work.
How do I setup sys user on a Mac?
The SYS user should come automatically with the database.
doesnt work
What issue are you having with setting this up?
POOR AUDIO QUALITY
Hi Krishna, could you let me know what’s poor about it?
I feel the audio is little feeble that I need to use my earphones to listen clearly... I generally don’t face this problem for other videos in UA-cam... Thank you
Thanks for the feedback. Since making this video I’ve tried to improve the audio quality on recent videos 🙂
NS_ERROR_INVALID_ARG
Never mind, I had two VMs in the folder, had to throw one in the trash
Glad you resolved it!
Failed to import appliance /Users/kapilchavhan/Downloads/DeveloperDaysVM2019-05-31_20.ova.
Result Code: NS_ERROR_INVALID_ARG (0x80070057)
I would suggest Googling this error message, I'm not sure why it's happening.
Hello, I have an error, “could not import configuration”, please can you help me, what should I do?
Are you running this on an M1 Mac? Which version of MacOS are you on? I've seen in other recent comments that there are issues with running it on M1 Macs.
Thank you for your video!
You are welcome!
Hello sir
I have error in after importing orcale vm file in virtual box
What error are you getting? Are you running an M1 or M2 Mac?
Thank you very much !!
No problem!
I did all the things. when I click on start after installing oracle vm it shows error.😔
Oh, what error does it show?
on clicking agree after import of VM .ova file into VB ERROR saying this comes, what to do??? please help me
Failed to import appliance .
Hmm... do you get any other information along with it? Was the download successful?