How to Set Up an Oracle Free Cloud Database (Works on M1 MacBook)

[@arunsamria7495]

I feel like giving a salute. Only one on KZbin to walk me through the entire installation process with 100% success. Thanks a ton man.

[@DatabaseStar]

Thanks, glad the video was helpful! I tried to show the full process in this video (and my other videos too).

[@michaelgoff4504]

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.

[@DatabaseStar]

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.

[@roushankashyap3842]

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.

[@DatabaseStar]

Awesome, glad it works for you! Oracle don’t make it easy for Mac users!

[@fortuneinc.4480]

Thank you very much. I struggled with this for 6 hours before coming to your channel. You are the best teacher in the world

[@DatabaseStar]

Wow thanks I'm glad it helped! Yeah some of these setup processes be a bit confusing sometimes.

[@dzheyms]

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.

[@DatabaseStar]

Good to hear you've got it working!

[@ColeHamilton85]

Worked perfectly, thank you! I couldn't figure out how to set this up until now. Amazing!!

[@DatabaseStar]

Glad it helped!

[@ilonkepretorius4649]

Thank you, this was really helpful! It was error free and so easy to follow!

[@DatabaseStar]

Thanks, I’m glad you liked it and it was helpful!

[@andresin884]

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!

[@DatabaseStar]

Thanks! Glad you found the video useful.

[@arirecaldegutierrez1249]

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!

[@DatabaseStar]

That’s great! You’re welcome.

[@zhangeralekul6439]

Thank yo very much, man! It worked on M1. Best tutorial so far!

[@DatabaseStar]

Thanks, great to hear it worked on the M1!

[@bhanukafernando4017]

can i contact you i also got m1

[@celestinnegraru9976]

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!

[@DatabaseStar]

Glad to hear it worked!

[@pasmetha]

OMG You are so awesome! I went through so many videoss!!! Finally I got the Oracle Cloud set up!

[@DatabaseStar]

Thanks! Glad it was helpful. Some of the tutorials I found were hard to follow so I know what you mean.

[@cristobalier]

thank you, It was driving me crazy trying to setting up on M1

[@DatabaseStar]

Glad I could help! Yeah it’s hard getting it working on an M1

[@eduardopizzanilopes3095]

Perfect tutorial!

[@DatabaseStar]

Thanks!

[@Cereal.Fidgeter]

This is the only video that helped me using mac silicon

[@DatabaseStar]

Great! Yeah it's hard to find content to get Oracle working on these new Macs.

[@guillermolezcano6690]

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.

[@DatabaseStar]

That's strange, I've seen other comments of cards not being accepted but I'm not sure why.

[@khadimali9755]

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?

[@DatabaseStar]

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.

[@chideraokafor4087]

Love you so much! it's been a long day with this M2. Thank for all your help

[@DatabaseStar]

Glad to hear it helped! Yeah it can be hard getting Oracle to work on a Mac

[@Segagab1]

I am still struggling to connect on M2, what am I doing wrong?

[@ferozdba]

Thank you very much for this video. i was able to create my free trail and create a new database.

[@DatabaseStar]

Glad it helped!

[@jyotiprakashs8394]

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.

[@DatabaseStar]

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.

[@maxketschik5625]

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.

[@DatabaseStar]

Good to know it works!

[@larrylamar9277]

Thanks for this video! Working on my M1

[@DatabaseStar]

Glad you got it working!

[@suneetamodekurty9380]

It worked perfect for me!!! Thank you. Got it after a long long trial.

[@DatabaseStar]

Glad it was helpful!

[@VictorHugo-bd3bf]

That worked. Thank you so much. You are amazing.

[@DatabaseStar]

You're welcome!

[@ldsansegundo]

Thanks a lot for your kindly help❤

[@DatabaseStar]

You’re welcome!

[@ManishJindalmanisism]

Can i use jdbc details as well instead of wallet because i want to connect to oracle db via dbeaver and not sql developer

[@DatabaseStar]

Good question! I'm not sure, as I haven't tried it.

[@khalidshaik6357]

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.

[@DatabaseStar]

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.

[@SunnyJayaraj345]

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 !!?

[@DatabaseStar]

That's odd, hopefully the Oracle team responds to you soon to help you resolve it.

[@SteveLion-f2t]

Do we know if it is possible to run an Oracle Database in Docker for M1 Macs at this point in time?

[@DatabaseStar]

Not that I know of. Last I heard is that the Docker images do not run on the new Macs, unfortunately.

[@DatabaseStar]

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.

[@mkm130402]

awesome, i need to run apex on cloud, can you make a video to learn this topic?

[@DatabaseStar]

I can but I’ll have to research it as I have never worked on Apex.

[@luisafernandaquinteroariza4842]

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?

[@DatabaseStar]

Oh I’m not sure what that error means. I hope there’s something helpful when you google it.

[@pratyushsingh-ve6km]

which oracle SQL developer to download for m1? can you provide the link and file name?

[@pratyushsingh-ve6km]

I even don't have a credit card what to do?

[@DatabaseStar]

I use the one on the Oracle website, that works on M1 macs. It’s the oracle express that does not work on m1.

[@DatabaseStar]

You shouldn’t need a credit card to download sql developer.

[@pratyushsingh-ve6km]

@@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)?

[@DatabaseStar]

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.

[@martinogold]

Total legend, thanks!!!

[@DatabaseStar]

You’re welcome!

[@priyankar.tiwari]

I'm getting error while testing the connection. Its throwing Test Failed: Mismatch with the server certDN. Please guide and assist to troubleshoot.

[@priyankar.tiwari]

Status : Failure -Test failed: IO Error: Mismatch with the server cert DN. Exact error.

[@DatabaseStar]

Hmm I'm not sure how to resolve that error unfortunately.

[@tiengiangmy4295]

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?

[@DatabaseStar]

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.

[@tiengiangmy4295]

@@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 :(

[@moesmael]

Thank you. It was good explaining..

[@DatabaseStar]

Glad it was helpful!

[@lma_shopify3186]

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 ?

[@DatabaseStar]

You can connect to the SYS account which shoudl have the right privileges (DBA) to give privileges to other accounts.

[@Kellett2360]

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?

[@DatabaseStar]

Thanks! I assume it would be, as it's just a database to access, but I have no experience in WPF or Xamarin.

[@manoj9944]

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

[@DatabaseStar]

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.

[@MrAndykofi]

Wonderful, very nice and clear

[@DatabaseStar]

Thanks!

[@bachthieuquang9957]

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?

[@bachthieuquang9957]

"Session Expired Your session timed out. To continue working, sign in again. " 😥

[@DatabaseStar]

Sure, what do you need help with? Did the page redirect to the right page, allowing you to sign in?

[@bachthieuquang9957]

@@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)

[@rajeshkjm]

does it require oracle client to be installed in the macbook?

[@DatabaseStar]

I believe that it comes with an IDE such as SQL Developer.

[@rakshitgoyal2107]

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

[@DatabaseStar]

Oh that’s weird. I’m not sure how that can be resolved. Perhaps asking on the Oracle forums could be helpful.

[@darfitodanurdoro5609]

i want to connect my M1 to sql plus is it possible to connect sql plus from Oracle Free Cloud Database?

[@DatabaseStar]

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.

[@daviddrabble8453]

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?

[@DatabaseStar]

Oh I'm not sure, I haven't tried that actually.

[@danilobrun6058]

About the payment linked to the credit card, is there any risk of collection?

[@DatabaseStar]

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.

[@techxball]

Thank you so much this was a nice and simple to follow video

[@DatabaseStar]

No problem, glad it was helpful!

[@purushottomdutta]

The database is connecting, but I need hostname and other credentials in order to connect with Spring boot application. How can I get that?

[@DatabaseStar]

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).

[@shankhadeepbhowmik1917]

Hi, The "service field" just below the configuration file is not getting populated. Could you please help me?

[@DatabaseStar]

It might be something you'd have to Google or contact Oracle about, if it's something on the cloud database server, unfortunately...

[@NaguTexan]

Thanks . This works fine for me from mac mini (M1).

[@DatabaseStar]

Great to hear!

[@brianyang1572]

Hi Ben, where to find the table I just created? There are so many stuff on the server.

[@DatabaseStar]

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.

[@HeRoisDreamin]

will this only work in m1 macbook? can i make it work on a windows 11 laptop?>

[@DatabaseStar]

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.

[@simpsonito]

Thanks. It worked well. Does anybody know how I could connect to the database using a NodeJS application?

[@DatabaseStar]

I'm not sure, but perhaps someone here can answer it.

[@FM-nq7wh]

you save my life, thank you for that, btw do you know how to use hr by this method? thanks

[@DatabaseStar]

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.

[@imanuel4122]

can this cloud database used on sqldeveloper

[@imanuel4122]

i mean use for sqldeveloper

[@DatabaseStar]

Yes you should be able to use sql developer with this cloud database.

[@hizokadarkwolf]

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.

[@DatabaseStar]

No problem, glad it was helpful. Hope you get the card issue resolved.

[@dhatrisahithi-lq4zj]

Oracle account says payment error, Tried 3 times with different email addresses. No luck

[@DatabaseStar]

I would suggest getting in touch with Oracle about that.

[@brianyang1572]

Can I choose the data warehouse for the database type?

[@DatabaseStar]

You could try that, but I haven't done it before.

[@landiwi]

Done. Thanks so much

[@DatabaseStar]

That's great!

[@brahimvallboumouzouna7026]

is it possible to do some PL/SQL with this method ?

[@DatabaseStar]

Yes, it is possible, you can run PL/SQL on this database.

[@designfighter41]

thank you. success!!!!!

[@DatabaseStar]

Awesome!

[@rwima9]

can I use pl sql with it ?

[@DatabaseStar]

Yes, you can.

[@dpvdan]

THANK YOU SO MUCH !!

[@DatabaseStar]

You're welcome!

[@harrylongofficial6248]

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...

[@陳薇甯-v9w]

same here.

[@DatabaseStar]

Oh no, that’s not good. Could you get in touch with Oracle to work out why it keeps getting declined?

[@kkhh880aIo]

me either, i have tried several times . and contact oracle already. they said they couldnt fix it out

[@sonambhosle2823]

Thank you so much, it helped me alott......

[@DatabaseStar]

Glad you found it helpful!

[@plusonekonceptplt4390]

what to pick if i want to used the oracle for vps forex proposes?

[@DatabaseStar]

I’m not sure what that is. Are you creating a new app for forex?

[@swaradagade9635]

will pl/sql work on this?

[@DatabaseStar]

Yes it should, it’s a standard oracle database and I don’t think they would have removed plsql from it

[@ibrahiimeldesoukii9463]

after I choose Create an ATP database it is not working. is there any alternatives?

[@DatabaseStar]

What do you mean by "it is not working"? Do you get an error message?

[@emiliolomonaco3907]

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]

What error do you get when you run the script?

[@emiliolomonaco3907]

@@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

[@DatabaseStar]

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/

[@pavelllamocca5242]

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?

[@DatabaseStar]

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.

[@ppkwii]

How to delete Oracle Free Cloud Database and create a new one? I TERMINATED a Oracle database, But it can't create new one.

[@DatabaseStar]

Oh that’s odd, there should be a button or option on the website to create a new database.

[@ramjielangovan6817]

AWESOME THANKS :)

[@DatabaseStar]

You’re welcome!

[@gummadavellilaxmi4787]

Thankyou😊!!

[@DatabaseStar]

You're welcome!

[@rajshreerai628]

Oracle why you no provide suppport for m1

[@DatabaseStar]

I know, it's so annoying!

[@robertbusa5031]

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”

[@DatabaseStar]

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?

[@vamsibhashyam8053]

@@DatabaseStar Im facing the same issue. I tried storing in different folder but no use.

[@ruiguo1042]

@@DatabaseStar I've tried these but they don't work. Do you have other recommendations for solving this issue?

[@kvpankaj71]

@@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.

[@sonambhosle2823]

Hi now m getting some error as listener refused the connection. Can you please help me..

[@DatabaseStar]

Sure. Are you using the same service name in the video?

[@DatabaseStar]

Sure. Are you using the same service name in the video?

[@sonambhosle2823]

db202204072252

[@sonambhosle2823]

Used above service name

[@ano1976]

what's about windows sir?

[@DatabaseStar]

This should work on Windows as well, as you can set it up and then use SQL Developer to connect.

[@BroadVisions92]

How to connect to this Cloud Free Database from SQL Plus Command Line ?

[@DatabaseStar]

You should be able to use similar details in SQL Plus as we used for SQL Developer

[@RudyRdx]

wallet feature and step by step

[@DatabaseStar]

Glad you found that helpful!

[@binkhalid4642]

how to get hr schema

[@DatabaseStar]

I’ve got it in my repository and a video on my channel about it.

[@hope_85]

M2 air please

[@DatabaseStar]

This should also work on an M2

[@kkhh880aIo]

it doesn't work with me,

[@DatabaseStar]

What issue are you having?

[@AlexPereiraperez]

Funcionou correctamente!!

[@DatabaseStar]

That’s great!

[@peekaboo_]

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🙏

[@DatabaseStar]

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.

[@peekaboo_]

@@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.

[@anshulsinghchouhan8083]

@@peekaboo_ Hey i have got the same problem as you. Can you elaborate how you have managed to connect to the oracle database?

[@kaiseasy]

thanks!

[@DatabaseStar]

No problem!

[@kikemon3455]

10/10

[@DatabaseStar]

Thanks!