I'm so grateful for this. I have an M1 MacBook, and I tried several other guides, none of which worked. The steps in this video worked like a charm, without any hiccups whatsoever. I am just trying to learn Oracle Database so I can be competitive on the job market.
Thank You so Much Mate, I am using a MacBook with m2 chip, and it works for it. Was stuck for almost a month because nothing was working which was free. Thanks again for the help.
I got frustrated trying to setup the Oracle Cloud service and installed APEX instead so I could run some scripts from my SQL course as a refresher. When I originally did the SQL course I had an Intel based MacBook Pro and was running Oracle in a Docker container. Your video on setting up the Cloud service was a God send. I am now setup up on my M2 MacBook Air. The next challenge will be connecting to the database from Flask.
Thank you, I've been looking for this video since my Windows laptop crashed, then I noticed that docker can't run oracle DB yet..this video result me very helpfull!
I added my payment information and my card got charged as well. Still the sign up process fails with error processing transasction error. I just tried it yesterday. Any idea?
Thank you so much, sir!! I've been trying different methods to create an Oracle DB on MacBook Pro m2, like docker images with AMD architecture , then with ARM, but none of these worked, excepting this Oracle Cloud connection!
Hi thank you for this guidance brother. Could you please tell me what are the limitations of this free cloud oracle database. Limitations like, number tables or amount of data that can be inserted or number of hits per day something.
hi Database Star. Sign up 3:37 show erro: "Invalid URL You can't sign in by using the specified URL. We will automatically redirect you to the sign-in page." . Can u help me pls?
@@DatabaseStar no. although I received a successful confirmation mail from Oracle. I am able to log into my account, but then the screen shows the error "Session Expired Your session timed out. To continue working, sign in again" (not like your 3:37 seconds screen)
I have created oracle cloud account and finished all the process but while creating ATP DB I am getting this error: "Account has reached maximum limit for Always Free Autonomous Database instances.". But I am a first time user. Please can you tell what to do. Thank you.
I renamed my DB AFTER creating a default one. At first the DB connection from SQL developer did not work, I then added my IP address to the ACL, which also did not work. I then recreated the wallet with the new DB name, and everything works now.
I'm getting "Error processing transaction" even though everything seems good, I drafted the mail to the Oracle Client Service Team such that any help will be provided from their end but no response still !!?
It worked on macbook m1 but i there a sort of automatic reconnecction due to which i loose all the previous data and it occurs frequently is there any solution for that
I can't create an account cause I live in Vietnam and my region does not exist in the part Home Region. Then when I entered the address, there was an error processing transaction. I'm an undergraduate and this semester I need to learn about Oracle. Can you help me with another way to download the Oracle database on Mac M1?
Oh sorry to hear that. The only other way that I know of is to use a tool called Colima. But I’ve never used it so I don’t know how easy it is. Alternatively you could use Oracle Live SQL which is web based so you don’t need to install anything.
@@DatabaseStar Could you please find out about the Oracle Database on Visual studio Code? Does it support on Mac M1. I’ve tried many ways to use the Oracle but I don’t have enough knowledge about it. Or do you mind if I borrow your Oracle Cloud account :( I know this offer is impolite but I really need to download and use it :(
You should be able to find what you need on the Oracle Cloud dashboard/website. Perhaps there's another tutorial online about how to connect using Sprint boot (I have no experience with that).
Working perfectly thanks but when I want to give privileges to a user it's says that i cant because i don't have the privileges how do i connect to the sys ?
To download sql developer I’m pretty sure you don’t need a credit card. You’ll need a credit card for the oracle cloud database I believe. I’m not sure on how long it’s free for but it should say on the website.
I have created my free database and have been playing around with it. Is there any way you can access tnsnames and listener, pfile, etc and the practice setting up stuff like data guard, using the free OCI stuff?
Yes, it should work on a Windows laptop as well. The steps to set everything up should be the same, the only difference is that SQL Developer may look different.
Well, I could not create an account. It gives an error with the card validation. My card is a legit one, it works with other services perfectly. I created a ticket, because this solution is the best right now to use XE database with an M1 Mac. Thanks for the tutorial.
My card keeps getting declined. 10th attempt and inputting all data fields over and over, double checking it's all right and nope, won't let me in! GREAT now I have to find a new tutorial series...
Ah, if you're in SQL Developer you can expand the object browser on the left panel. It should be in Tables, and then the tables are in alphabetical order.
Risk of collection of the payment from Oracle? I assume not - they said on the signup process you won't be charged. But you may want to read more about it.
If I try to import a file.sql (is a db for practise) and I run the script, I receive error... Try to set user as dba but need permission. How can I get it? Thanks
@@DatabaseStar I'm trying to add a new user (dbuser) and I receive: ALTER SESSION SET "_ORACLE_SCRIPT" = TRUE Report error - ORA-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
Ah I think it could be to do with connecting to either a Container DB or a Pluggable DB, which is a fairly new feature in Oracle. I've written more about connection issues here, including this message: www.databasestar.com/oracle-connection-issues/ I've also written a guide to CDB and PDB if you want to know more: www.databasestar.com/oracle-pdb/
Thanks! What do you mean by "use hr by this method"? Do you mean use the Oracle HR database? If so, I have another video on my channel on loading the Oracle HR database which might help.
I keep getting error messages. SQLDeveloper couldn’t have access to my folder where the wallet was save. I keep getting this error message “I/O error the directory/users/…./download is not accessible. Please select a different directory”
I remember getting this as well. Could you try restarting SQL Developer (perhaps the folder was created after opening SQL Developer and for some reason it could not be found)? If that doesn't work, could you store it in a different folder?
Glad it was helpful. Ah I’ve just done some quick Googling and it seems it can be resolved with a JDK version change and a parameter. I don’t have an M1 so I can’t test it but there are a few good articles that show the steps.
Hello, thanks for the video. I have created my ATP database, but when I tried to connect from my SQL Developer, I got this error: Listener refused the connection with the following error: ORA-12529, TNS:connect request rejected based on current filtering rules (CONNECTION_ID=DaiNx3GxQoKa7gYAEdsmwQ==) Do you have any idead why it happen?
Hmmm, I'm not sure why that would happen. Perhaps there are some rules on the Oracle Cloud that is preventing your connection. Hopefully there are some StackOverflow answers or other pages out there with similar errors and a solution.
I am a college student from China, the school course requires learning Oracle, but I am using mac m1, I can't register oracle cloud database of Oracle, because I can't complete the payment information, I went to Taobao (an e-commerce company) Trading platform) paid on behalf of me, but I was cheated of a sum of money. I hope someone can help me, register an oracle cloud database account, thank you🙏
Oh I'm sorry you got cheated out of some money. I'm not sure how you can get an Oracle database running (unfortunately Oracle isn't that good at supporting Macs). You could try using Docker and seeing if there are any images on the Oracle Container Registry or Docker Hub that would work on M1.
@@DatabaseStar thanks your reply, I already solve my problem by using SSH, while remotely login in Oracle database that has installed in my roommate's windows computer on my own macbook. i hope this solution can help others oracle learner.
I feel like giving a salute.
Only one on UA-cam to walk me through the entire installation process with 100% success.
Thanks a ton man.
Thanks, glad the video was helpful! I tried to show the full process in this video (and my other videos too).
I'm so grateful for this. I have an M1 MacBook, and I tried several other guides, none of which worked. The steps in this video worked like a charm, without any hiccups whatsoever. I am just trying to learn Oracle Database so I can be competitive on the job market.
That’s great to hear it helped! Yeah Oracle don’t make it easy to work on Macs but this free cloud database seems to work.
Thank You so Much Mate, I am using a MacBook with m2 chip, and it works for it. Was stuck for almost a month because nothing was working which was free. Thanks again for the help.
Awesome, glad it works for you! Oracle don’t make it easy for Mac users!
Thank you very much. I struggled with this for 6 hours before coming to your channel. You are the best teacher in the world
Wow thanks I'm glad it helped! Yeah some of these setup processes be a bit confusing sometimes.
I got frustrated trying to setup the Oracle Cloud service and installed APEX instead so I could run some scripts from my SQL course as a refresher. When I originally did the SQL course I had an Intel based MacBook Pro and was running Oracle in a Docker container.
Your video on setting up the Cloud service was a God send. I am now setup up on my M2 MacBook Air. The next challenge will be connecting to the database from Flask.
Good to hear you've got it working!
Worked perfectly, thank you! I couldn't figure out how to set this up until now. Amazing!!
Glad it helped!
OMG You are so awesome! I went through so many videoss!!! Finally I got the Oracle Cloud set up!
Thanks! Glad it was helpful. Some of the tutorials I found were hard to follow so I know what you mean.
Thank yo very much, man! It worked on M1. Best tutorial so far!
Thanks, great to hear it worked on the M1!
can i contact you i also got m1
Thank you, this was really helpful! It was error free and so easy to follow!
Thanks, I’m glad you liked it and it was helpful!
Thank you, I've been looking for this video since my Windows laptop crashed, then I noticed that docker can't run oracle DB yet..this video result me very helpfull!
Thanks! Glad you found the video useful.
I added my payment information and my card got charged as well. Still the sign up process fails with error processing transasction error. I just tried it yesterday. Any idea?
That's strange it failed but still charged your card. I'm not sure why that happened, but other commenters have issues with cards as well.
Love you so much! it's been a long day with this M2. Thank for all your help
Glad to hear it helped! Yeah it can be hard getting Oracle to work on a Mac
I am still struggling to connect on M2, what am I doing wrong?
it is not accepting my payment information. I don't get it. It the same card that I use for everything and it's sending errors.
That's strange, I've seen other comments of cards not being accepted but I'm not sure why.
Thank you so much, sir!! I've been trying different methods to create an Oracle DB on MacBook Pro m2, like docker images with AMD architecture , then with ARM, but none of these worked, excepting this Oracle Cloud connection!
Glad to hear it worked!
Muchas gracias!!!!! Estaba ya desesperada y con la ayuda de tu vídeo he conseguido crear la conexión sin ningún problema. De verdad, gracias otra vez!
That’s great! You’re welcome.
thank you, It was driving me crazy trying to setting up on M1
Glad I could help! Yeah it’s hard getting it working on an M1
This is the only video that helped me using mac silicon
Great! Yeah it's hard to find content to get Oracle working on these new Macs.
Hi thank you for this guidance brother.
Could you please tell me what are the limitations of this free cloud oracle database.
Limitations like, number tables or amount of data that can be inserted or number of hits per day something.
You’re welcome!
I’m not sure what the limitations are, but for the most up to date information, you can check the Oracle website.
Thank you very much for this video. i was able to create my free trail and create a new database.
Glad it helped!
It worked perfect for me!!! Thank you. Got it after a long long trial.
Glad it was helpful!
hi Database Star. Sign up 3:37 show erro: "Invalid URL
You can't sign in by using the specified URL. We will automatically redirect you to the sign-in page." . Can u help me pls?
"Session Expired
Your session timed out. To continue working, sign in again. " 😥
Sure, what do you need help with? Did the page redirect to the right page, allowing you to sign in?
@@DatabaseStar no. although I received a successful confirmation mail from Oracle. I am able to log into my account, but then the screen shows the error "Session Expired
Your session timed out. To continue working, sign in again" (not like your 3:37 seconds screen)
That worked. Thank you so much. You are amazing.
You're welcome!
I have created oracle cloud account and finished all the process but while creating ATP DB I am getting this error: "Account has reached maximum limit for Always Free Autonomous Database instances.". But I am a first time user. Please can you tell what to do. Thank you.
Oh that's strange, that doesn't make sense. I'm not sure what to do, perhaps look at the Oracle forum or get in touch with Oracle support.
Perfect tutorial!
Thanks!
can i also use this for vs code oracle sql developer connection
?????
Yes you should be able to.
@@DatabaseStar can you just explain me how to do it?
thanks in advance
Thanks for this video! Working on my M1
Glad you got it working!
I renamed my DB AFTER creating a default one. At first the DB connection from SQL developer did not work, I then added my IP address to the ACL, which also did not work. I then recreated the wallet with the new DB name, and everything works now.
Good to know it works!
I'm getting error while testing the connection. Its throwing Test Failed: Mismatch with the server certDN.
Please guide and assist to troubleshoot.
Status : Failure -Test failed: IO Error: Mismatch with the server cert DN.
Exact error.
Hmm I'm not sure how to resolve that error unfortunately.
Hello, when creating the database I get this error,
Operation failed. OCI tenancy not validated.
I don't know what to do, can you help me? please?
Oh I’m not sure what that error means. I hope there’s something helpful when you google it.
can this cloud database used on sqldeveloper
i mean use for sqldeveloper
Yes you should be able to use sql developer with this cloud database.
I'm getting "Error processing transaction" even though everything seems good, I drafted the mail to the Oracle Client Service Team such that any help will be provided from their end but no response still !!?
That's odd, hopefully the Oracle team responds to you soon to help you resolve it.
Can i use jdbc details as well instead of wallet because i want to connect to oracle db via dbeaver and not sql developer
Good question! I'm not sure, as I haven't tried it.
It worked on macbook m1 but i there a sort of automatic reconnecction due to which i loose all the previous data and it occurs frequently is there any solution for that
Oh that’s weird. I’m not sure how that can be resolved. Perhaps asking on the Oracle forums could be helpful.
Do we know if it is possible to run an Oracle Database in Docker for M1 Macs at this point in time?
Not that I know of. Last I heard is that the Docker images do not run on the new Macs, unfortunately.
There is a tool called Colima that lets you run Oracle on an M1 Mac, but I don't have any experience in setting it up.
I can't create an account cause I live in Vietnam and my region does not exist in the part Home Region. Then when I entered the address, there was an error processing transaction. I'm an undergraduate and this semester I need to learn about Oracle. Can you help me with another way to download the Oracle database on Mac M1?
Oh sorry to hear that. The only other way that I know of is to use a tool called Colima. But I’ve never used it so I don’t know how easy it is.
Alternatively you could use Oracle Live SQL which is web based so you don’t need to install anything.
@@DatabaseStar Could you please find out about the Oracle Database on Visual studio Code? Does it support on Mac M1.
I’ve tried many ways to use the Oracle but I don’t have enough knowledge about it.
Or do you mind if I borrow your Oracle Cloud account :(
I know this offer is impolite but I really need to download and use it :(
awesome, i need to run apex on cloud, can you make a video to learn this topic?
I can but I’ll have to research it as I have never worked on Apex.
does it require oracle client to be installed in the macbook?
I believe that it comes with an IDE such as SQL Developer.
The database is connecting, but I need hostname and other credentials in order to connect with Spring boot application. How can I get that?
You should be able to find what you need on the Oracle Cloud dashboard/website. Perhaps there's another tutorial online about how to connect using Sprint boot (I have no experience with that).
i want to connect my M1 to sql plus is it possible to connect sql plus from Oracle Free Cloud Database?
I think so, you would just need to use a connection string that refers to the cloud database. I'm not sure what that would be though.
Working perfectly thanks but when I want to give privileges to a user it's says that i cant because i don't have the privileges how do i connect to the sys ?
You can connect to the SYS account which shoudl have the right privileges (DBA) to give privileges to other accounts.
Total legend, thanks!!!
You’re welcome!
Thank you. It was good explaining..
Glad it was helpful!
which oracle SQL developer to download for m1? can you provide the link and file name?
I even don't have a credit card what to do?
I use the one on the Oracle website, that works on M1 macs. It’s the oracle express that does not work on m1.
You shouldn’t need a credit card to download sql developer.
@@DatabaseStar Yes but to download from Oracle website, I need a credit card right?
Is it really free for life time (the cloud database version)?
To download sql developer I’m pretty sure you don’t need a credit card.
You’ll need a credit card for the oracle cloud database I believe. I’m not sure on how long it’s free for but it should say on the website.
Oracle account says payment error,
Tried 3 times with different email addresses.
No luck
I would suggest getting in touch with Oracle about that.
I have created my free database and have been playing around with it. Is there any way you can access tnsnames and listener, pfile, etc and the practice setting up stuff like data guard, using the free OCI stuff?
Oh I'm not sure, I haven't tried that actually.
Hi, The "service field" just below the configuration file is not getting populated. Could you please help me?
It might be something you'd have to Google or contact Oracle about, if it's something on the cloud database server, unfortunately...
will this only work in m1 macbook? can i make it work on a windows 11 laptop?>
Yes, it should work on a Windows laptop as well. The steps to set everything up should be the same, the only difference is that SQL Developer may look different.
Thank you so much this was a nice and simple to follow video
No problem, glad it was helpful!
Well, I could not create an account. It gives an error with the card validation. My card is a legit one, it works with other services perfectly. I created a ticket, because this solution is the best right now to use XE database with an M1 Mac.
Thanks for the tutorial.
No problem, glad it was helpful. Hope you get the card issue resolved.
My card keeps getting declined. 10th attempt and inputting all data fields over and over, double checking it's all right and nope, won't let me in! GREAT now I have to find a new tutorial series...
same here.
Oh no, that’s not good. Could you get in touch with Oracle to work out why it keeps getting declined?
me either, i have tried several times . and contact oracle already. they said they couldnt fix it out
Wonderful, very nice and clear
Thanks!
Hi Ben, where to find the table I just created? There are so many stuff on the server.
Ah, if you're in SQL Developer you can expand the object browser on the left panel. It should be in Tables, and then the tables are in alphabetical order.
About the payment linked to the credit card, is there any risk of collection?
Risk of collection of the payment from Oracle? I assume not - they said on the signup process you won't be charged. But you may want to read more about it.
If I try to import a file.sql (is a db for practise) and I run the script, I receive error... Try to set user as dba but need permission. How can I get it? Thanks
What error do you get when you run the script?
@@DatabaseStar I'm trying to add a new user (dbuser) and I receive:
ALTER SESSION SET "_ORACLE_SCRIPT" = TRUE
Report error -
ORA-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
Ah I think it could be to do with connecting to either a Container DB or a Pluggable DB, which is a fairly new feature in Oracle.
I've written more about connection issues here, including this message: www.databasestar.com/oracle-connection-issues/
I've also written a guide to CDB and PDB if you want to know more: www.databasestar.com/oracle-pdb/
you save my life, thank you for that, btw do you know how to use hr by this method? thanks
Thanks! What do you mean by "use hr by this method"? Do you mean use the Oracle HR database? If so, I have another video on my channel on loading the Oracle HR database which might help.
Can I choose the data warehouse for the database type?
You could try that, but I haven't done it before.
after I choose Create an ATP database it is not working. is there any alternatives?
What do you mean by "it is not working"? Do you get an error message?
Thanks a lot for your kindly help❤
You’re welcome!
what to pick if i want to used the oracle for vps forex proposes?
I’m not sure what that is. Are you creating a new app for forex?
is it possible to do some PL/SQL with this method ?
Yes, it is possible, you can run PL/SQL on this database.
Thanks . This works fine for me from mac mini (M1).
Great to hear!
How to delete Oracle Free Cloud Database and create a new one? I TERMINATED a Oracle database, But it can't create new one.
Oh that’s odd, there should be a button or option on the website to create a new database.
Hi now m getting some error as listener refused the connection. Can you please help me..
Sure. Are you using the same service name in the video?
Sure. Are you using the same service name in the video?
db202204072252
Used above service name
I keep getting error messages. SQLDeveloper couldn’t have access to my folder where the wallet was save. I keep getting this error message “I/O error the directory/users/…./download is not accessible. Please select a different directory”
I remember getting this as well. Could you try restarting SQL Developer (perhaps the folder was created after opening SQL Developer and for some reason it could not be found)? If that doesn't work, could you store it in a different folder?
@@DatabaseStar Im facing the same issue. I tried storing in different folder but no use.
@@DatabaseStar I've tried these but they don't work. Do you have other recommendations for solving this issue?
@@ruiguo1042 I moved the zip file to my home folder in Mac and then after restarting SQL developer. I could find it after clicking on browse.
Thank you for this video. But I am unable to install sqldeveloper IDE on macbook air M1. Do you have any tips for me regarding this? Thank you
Glad it was helpful. Ah I’ve just done some quick Googling and it seems it can be resolved with a JDK version change and a parameter. I don’t have an M1 so I can’t test it but there are a few good articles that show the steps.
can I use pl sql with it ?
Yes, you can.
Great video, very clear and well presented.
Is it possible to use this database to store/read data in a WPF application or Xamarin mobile application?
Thanks! I assume it would be, as it's just a database to access, but I have no experience in WPF or Xamarin.
Thank you so much, it helped me alott......
Glad you found it helpful!
How to connect to this Cloud Free Database from SQL Plus Command Line ?
You should be able to use similar details in SQL Plus as we used for SQL Developer
Thanks. It worked well. Does anybody know how I could connect to the database using a NodeJS application?
I'm not sure, but perhaps someone here can answer it.
will pl/sql work on this?
Yes it should, it’s a standard oracle database and I don’t think they would have removed plsql from it
THANK YOU SO MUCH !!
You're welcome!
Oracle why you no provide suppport for m1
I know, it's so annoying!
Hello, thanks for the video. I have created my ATP database, but when I tried to connect from my SQL Developer, I got this error: Listener refused the connection with the following error: ORA-12529, TNS:connect request rejected based on current filtering rules (CONNECTION_ID=DaiNx3GxQoKa7gYAEdsmwQ==)
Do you have any idead why it happen?
Hmmm, I'm not sure why that would happen. Perhaps there are some rules on the Oracle Cloud that is preventing your connection. Hopefully there are some StackOverflow answers or other pages out there with similar errors and a solution.
Done. Thanks so much
That's great!
thank you. success!!!!!
Awesome!
what's about windows sir?
This should work on Windows as well, as you can set it up and then use SQL Developer to connect.
AWESOME THANKS :)
You’re welcome!
how to get hr schema
I’ve got it in my repository and a video on my channel about it.
Thankyou😊!!
You're welcome!
it doesn't work with me,
What issue are you having?
I am a college student from China, the school course requires learning Oracle, but I am using mac m1, I can't register oracle cloud database of Oracle, because I can't complete the payment information, I went to Taobao (an e-commerce company) Trading platform) paid on behalf of me, but I was cheated of a sum of money. I hope someone can help me, register an oracle cloud database account, thank you🙏
Oh I'm sorry you got cheated out of some money. I'm not sure how you can get an Oracle database running (unfortunately Oracle isn't that good at supporting Macs). You could try using Docker and seeing if there are any images on the Oracle Container Registry or Docker Hub that would work on M1.
@@DatabaseStar thanks your reply, I already solve my problem by using SSH, while remotely login in Oracle database that has installed in my roommate's windows computer on my own macbook. i hope this solution can help others oracle learner.
@@peekaboo_ Hey i have got the same problem as you. Can you elaborate how you have managed to connect to the oracle database?
M2 air please
This should also work on an M2
wallet feature and step by step
Glad you found that helpful!
thanks!
No problem!
Funcionou correctamente!!
That’s great!
10/10
Thanks!