How to Install Oracle on an M1/M2 Mac (Finally)

[@DatabaseStar]

Want to easily remember the SQL commands for your database? Get my free SQL Cheat Sheets here: www.databasestar.com/get-sql-cheat-sheets/?

[@RidhimaChopra-f6i]

Couldn't be more happier today, Finally got the oracle database running on my mac m2. Thank you for sharing this

[@DatabaseStar]

Great to hear!

[@JuanHerrera-io5qy]

Finally! Didn't know that was not possible to install oracle db on Mac until last wednesday. Then this video appears! Thanks from Brazil!

[@DatabaseStar]

Thanks! Yeah it’s a new file Oracle created for this. 😀

[@vj2310]

Finally, I managed to get Oracle DB running on Mac M1 and continued practicing. Thank you for sharing this!

[@DatabaseStar]

Glad it helped!

[@cnagappa]

Thank you so much!! I am so happy to have chanced upon this video. I've followed your instructions to the T on my Mac M1 Mini 2020 (16GB/512GB SDD). Everything worked just as you described. Separately, I've downloaded SQL Developer and the connection is so smooth.

[@DatabaseStar]

Awesome! Glad it worked for you. It’s been hard in the last few years to get Oracle on the M1 Mac but this recent release has made it easier.

[@FullStackJavaJourney-s5g]

thanks a lot it helped me a lot one request after restarting system it is gone so could you please give me the command for running docker command using volume so that data will be persist after restart also

[@DatabaseStar]

You’re welcome! Sure, I have a video on bind mounts on my channel which explains how to do this.

[@raguveer6277]

Please upload a video about uninstalling the oracle and docker fully from the device

[@DatabaseStar]

Good idea!

[@SnehilPriyam]

hey after entering the the command at 5:39 i am getting an error (No docker or podman executable found in your PATH) before that everthing works fine can u help me out .

[@DatabaseStar]

Have you downloaded and installed Docker? If so, the PATH environment variable may not include the location that Docker is installed to. I would google how to update your PATH variable to include this.

[@SnehilPriyam]

@@DatabaseStar No not downloaded docker

[@jesusmartineznoda6595]

It is a bit unclear to me on the step of having a GitHub repository in my folder. 2:26 Can anyone help me out please?

[@DatabaseStar]

I'll try to help. This step is needed because the files that are used to create an image (a kind of "installation file"), are stored in a GitHub repository. We need to download those to our computer so that we can run the script to create this image.

[@umathitamilyoutuber4185]

Thanks :) Finally got to use oracle db in my MAC after 3 years of trying. Great!

[@DatabaseStar]

You’re welcome! Glad it worked for you.

[@GaoMingYang0101]

Thank you so much! I have tried many times to use Oracle database on m1 mac, this time I success!😄

[@DatabaseStar]

Glad it helped!

[@RohitKumar-ip1qp]

Finally I can practice PLSQL on a m1 Mac

[@DatabaseStar]

Yeah it’s great we can do that now

[@AbdallahBoukouffallah]

I can't be more grateful, Thanks dude you are a life saver .

[@DatabaseStar]

Glad you found it useful!

[@nader_908]

Hi Database Star this is a great video but how i can active hr on it

[@DatabaseStar]

Thanks! I'm not sure if it's already included, but I'll create a video on how to do this.

[@nader_908]

@@DatabaseStar Thanks❤

[@naachhair]

Thanks for your sharing. I finally installed oracle on my mac m2.

[@DatabaseStar]

Glad you were able to get it working!

[@AQ.shorts]

Please help me i also have mac m2 cd github comd dont work for me please give the right cmd by rply this comment

[@mohdwasique1682]

Thank you very much !!! I am very happy and finally i am able to connect Oracle DB database on my MAC M1. I was really struggling to do so, your video was very informative and helpful. Thanks & Appreciated for good work. Subscribed!!

[@DatabaseStar]

Glad it helped!

[@sardarsajju]

FINALLY..... Thank you so much for the video each and every step is sooo clear. Finally i got Oracle running on my computer🤗🤗🤗🤗

[@DatabaseStar]

Glad to hear it worked!

[@masto2733]

I cannot see Sql developer in VScode to add connection, I managed to connect via standalone SQL Developer, but cannot make connection from VSC, how to add that option? // I have it, added 3rd party extension, thanks. Great job, finally someone delivered how to. Many thanks

[@DatabaseStar]

Glad you got it working!

[@QuynhDuong-x4w]

I got this error while building the image. "=> ERROR [stage-2 2/4] RUN "/opt/oracle"/oraInventory/orainstRoot.sh && 1.3s" can you help me fix this, please!!!

[@DatabaseStar]

Oh I’m not sure why you would be getting that error unfortunately

[@lestercorrales4670]

same I also encountered that => ERROR [stage-2 2/4] RUN "/opt/oracle"/oraInventory/orainstRoot.sh && "/opt/oracle/product/19c/dbhome_1"/root.sh

[@1w4n]

I got the same error. The first time I downloaded the db form the Oracle site, Safari unzipped it and I re-zipped the expanded folder. I got the your error. So I re-downloaded the .zip file avoiding Safari to unzip it. And it worked!

[@Anonymouse-kb5po]

Great video! If i'm using docker compose, what location should I bind to have persistent data?

[@DatabaseStar]

Hmm I'm not 100% sure on that actually. I've used docker compose briefly as well as bind mounts briefly but I don't know enough to have an answer for this.

[@anantatw]

please add if we create user using this container, use naming for username C##[username] or give some configuration. thanks.

[@DatabaseStar]

You can login with the SYS user, or create a new user if you like. If you want a "local user" (which is like a regular user), you'll need to create it on the Pluggable Database and not use the C## format.

[@AliHsn-Official]

Much appreciated man!🙏❤ I have a questions tho, how to properly exit the running image and rerun it again?

[@DatabaseStar]

You can use the command "docker stop" to stop it and "docker run" to run it again.

[@PatrickRenaudWendyamRAYAISSE]

My macbook is using intel chip . is it possible to install on it ?

[@DatabaseStar]

Yes, it's possible. There are instructions on using Docker on the Oracle download page: www.oracle.com/uk/database/technologies/oracle-database-software-downloads.html

[@jokingstew7885]

Thanks it for me in SQL developer, really thank you, with the others images of Oracle in Docker for me doesn't work but with this, Everything work, merci beaucoup

[@DatabaseStar]

Glad it helped!

[@fernandoluna3866]

Hi, my question is more towards VS Code and VS Code Server. I have VS Code installed and had no problem adding the SQL Developer extension. However, this doesn't seem to be available for the Server version of VS Code (which I am hosting in my home lab). Any thoughts on why this is or if there is a work-around to getting it installed?

[@DatabaseStar]

Oh I've never heard of a server version of VS Code. I'm not sure how to get it installed unfortunately.

[@StatusWorld2k17]

Hi sir, can you please help to get the default database table such as emp, dept etc

[@DatabaseStar]

Sure, I have a KZbin video here on setting up the HR database: kzbin.info/www/bejne/rmmmaapqf7Jmd7c

[@zahrafakhirahidayat4278]

sir, my docker can't be opened and used, how can I open and use it? please answer my question, i need to use oracle for my task :(🙏

[@DatabaseStar]

Are you getting an error when you try to use Docker? Do you have the right version of Docker?

[@zahrafakhirahidayat4278]

@@DatabaseStar yes, i used the version that you used in the video, because mine is m2 i thought it was same with yours

[@regreto9741]

Checking if required packages are present and valid... md5sum: LINUX.ARM64_1919000_db_home.zip: No such file or directory MD5 for required packages to build this image did not match! Make sure to download missing files in folder 19.3.0. how do I fix this and what am I missing

[@DatabaseStar]

I’m not sure what that error means.

[@blauee5268]

did u fix it I have the same error

[@ZFighter-d7k]

Pls tell a fix if u got any

[@ghalibalmandhary6217]

The fix is simple, don't download the LINUX.ARM64 on safari as the format of the file will not be .zip. download using any other browser, I tried with google chrome and it worked. Once the download is done, just place the .zip file in the directory that you have done the git clone.

[@ghalibalmandhary6217]

@@blauee5268 The fix is simple, don't download the LINUX.ARM64 on safari as the format of the file will not be .zip. download using any other browser, I tried with google chrome and it worked. Once the download is done, just place the .zip file in the directory that you have done the git clone.

[@sainnath]

Thanks! please also make a video on how to install Oracle Data intergrator (ODI) 12c on m1 mac. unable to find arm(aarch64) version for ODI 12c.

[@DatabaseStar]

I don't have any experience with ODI so I'm not sure how that would be done.

[@knabivan9274]

Thanks. It also works on Windows ARM.

[@DatabaseStar]

Good to know!

[@jorgemeza4364]

Thank you very much mate, greetings from Mexico

[@DatabaseStar]

You're welcome!

[@regreto9741]

I only have 2 options of download for docker, apple silicon or intel chip, please answer quickly

[@DatabaseStar]

It’s the Apple Silicon chip, this is the one used by the M series Macs.

[@yassinezaimi1071]

No docker or podman executable found in your PATH (what’s problem )

[@DatabaseStar]

Do you have Docker installed?

[@abdulwahabsindi2731]

im having trouble connecting to the database with a user other than SYS. i need to be able to drop tables for example. please help

[@DatabaseStar]

What error are you getting? It's hard to connect to Oracle and there could be any number of causes and solutions :|

[@Jawaher_ar]

When I get to Build command and write in the terminal image step it says :”oracle Database container image was not successfully created “ and I am making sure the code is right and the docker is open what you think the problem is? because i need it for college 😔

[@DatabaseStar]

Hmm I'm not sure. I would suggest looking on Google or Stack Overflow as there are likely others with the same issue.

[@ShahbazKhan-tv6ws]

I am having same issues. even I tried with multiple version of docker.

[@erwingcossb4926]

Thank you so much for the video!

[@DatabaseStar]

You're welcome

[@neriyoutuber]

How can i install oracle apex after this?

[@DatabaseStar]

I’m not sure, unfortunately, as I’ve never used Apex.

[@OndiFransButarbutar]

may i know which builder you were using?

[@DatabaseStar]

What do you mean by "builder"?

[@BurntDosa]

i get a 400 bad request error when im trying to download the file from oracle how do I fix this?

[@BurntDosa]

i also get 502 error in the same page

[@DatabaseStar]

I'm not sure, I think that would be an issue with Oracle's site.

[@SnehilPriyam]

I want to run command using terminal (as we can do it in command prompt in windows) not VS code how can i do that ??

[@DatabaseStar]

There's a way to show the terminal in VS Code: View > Terminal.

[@karynnthedreamer]

Thanks for saving my Comp Sci masters 🙇‍♀

[@DatabaseStar]

Happy to help!

[@sharminsultana9206]

hi, I just wanted to know where are the files being created? like what do I need to do when I eant to uninstall/remove it? And do I need to run the docker run command everytime I need to use the database?

[@DatabaseStar]

I think the files are created in a docker folder somewhere on your computer. I don't know where off the top of my head, but it should be on Google. If you want to remove the database, you can use the docker command "docker container rm " to remove the container. If you leave the computer running, the docker container should still be running. If you exit docker or restart your computer, you'll need to run "docker run" again.

[@kumotskie]

Can this be also apply to the new Microsoft Surface laptop with snapdragon arm chips?

[@DatabaseStar]

Good question. I assume it can, if it's an ARM chip, but I'm not sure.

[@E_Haven]

When I do the building the image, I get like * select one edition only: -e, -s, -x, or -f LICENSE UPL 1.0 Copyright (c) 2014,2024 Oracle and/or its affiliates. how to fix this

[@DatabaseStar]

Could you choose one of those options?

[@kriswiley4734]

is it possible to add a database I have in a file to this?

[@DatabaseStar]

Yes, depending on the format. If it's one or more SQL files you can run them. If it's a CSV file you can import the CSV.

[@james.sanjaya]

is it safe to have oracle in the macbook rather than using a virtual machine??

[@DatabaseStar]

Generally it's OK, but Docker is meant for temporary usage from what I understand, and not for anything production related.

[@badboysforlifebbfl9777]

How to use hr and Scott user in this bro ?

[@DatabaseStar]

You can install those database tables separately. Oracle has some scripts on GitHub and I have some on my GitHub as well. I also have a video on my channel

[@sameerkurhade6436]

Hello How to unloack hr schema in sql developer through connect docker in Macbook pro m2 please help me

[@DatabaseStar]

I've got a video on loading the Oracle HR schema here: kzbin.info/www/bejne/rmmmaapqf7Jmd7c

[@regreto9741]

im getting an issue 400 bad request . request header or cookie to large when Im trying to download the aarm oracle

[@DatabaseStar]

Oh that’s odd. Hopefully it’s a temporary issue.

[@giammaplays9580]

I've got this error Checking if required packages are present and valid... md5sum: LINUX.X64_193000_db_home.zip: No such file or directory MD5 for required packages to build this image did not match! Make sure to download missing files in folder 19.3.0. Any idea why he is searching X64 version?

[@DatabaseStar]

That's odd, I don't know why you would be getting this error.

[@ahmedgamal203]

thank you so much, i am trying to build my app locally using Tilt and the commands to run DB are in k82 yaml file, whatever the logs show the tables is created but i got login denied invalid user or password!

[@DatabaseStar]

Oh that's odd, I don't know much about Tilt or k82 unfortunately

[@VinnyVibe-u5g]

I wanted to import a .csv file into a table I created using SQL developer extension on VSCode. But it seems to be there isn’t anyway for that. Any help?

[@DatabaseStar]

Perhaps that functionality hasn't been added to the extension yet. They are adding features quickly, so it will be there eventually.

[@saiganesh-l2194]

Can i connect this oracle database to java jdbc?

[@DatabaseStar]

I’m not sure as I haven’t used Java

[@mrsmart4102]

I have the base model m3 and I wanna use it for doing java enterprise practise with this database will this work ok or should I switch to my windows

[@DatabaseStar]

I think it will work for Oracle. I’m not sure about Java as I don’t have much experience with it.

[@leilaallouch4470]

everytime i klick the link to download the zip data it doesnt work. I am taken directly to an error message and cannot install it.

[@DatabaseStar]

Oh that's odd. What error message do you get on the website?

[@JosephReyes-d6x]

my terminal says "No docker or podman executable found in your PATH" how can i fix this?

[@DatabaseStar]

Do you have docker installed? This message may appear if you don’t have it installed. If not, try installing docker and try this process again.

[@philippemallari8077]

Hey, i do have a question, when I try to connect to a specific user it says: "SQL> connect leticia; The connect request was not recognized: please type HELP CONNECT to find out more about the supported combinations of command options SQL> connect cprg250; The connect request was not recognized: please type HELP CONNECT to find out more about the supported combinations of command options SQL> connect cprg250s; The connect request was not recognized: please type HELP CONNECT to find out more about the supported combinations of command options SQL> select * from customers;" how can I connect to a specific user?

[@DatabaseStar]

Where are you typing this command? I'm not familiar with the CONNECT command. Is it in SQL*Plus or some other tool?

[@philippemallari8077]

@@DatabaseStar My professor is using windows and is using SQL*Plus, so I am trying on my end with oracle on vs code

[@philippemallari8077]

@@DatabaseStar yeah my professor is in windows and is doing it in SQL plus

[@mr.benjamincounta]

Can we run older versions of Linux and red hat finally now ?

[@DatabaseStar]

I’m not sure

[@idrisbouch9646]

it said operation not permitted in my terminal pls help

[@DatabaseStar]

Which operation is this?

[@avinashavi6536]

No docker or podman executable found in your PATH it is showing like this

[@DatabaseStar]

Have you installed Docker?

[@jejemon021]

Exactly what I need, thank you so much!!! :)

[@DatabaseStar]

You're welcome!

[@GameQuestChronicles12]

can I practice sql plus from this

[@DatabaseStar]

I assume so, but I haven't tried it.

[@anniepham162]

It's really helpful, thank you so much 💌

[@DatabaseStar]

You're welcome 😊

[@kkcheng0816]

Thank you very much for your video! I installed Oracle 19c successfully on my Mac M1 laptop. But when I tried to unlock HR schema, I got ORA-01918: user 'HR' does not exist although I already ran the following statements. ALTER SESSION SET container=ORCLPDB1; ALTER PLUGGABLE DATABASE open; ALTER PLUGGABLE DATABASE ORCLPDB1 SAVE STATE; alter user hr identified by hr account unlock;

[@DatabaseStar]

Glad you liked it! I'm not sure how to unlock the HR schema on these databases, or even if it's included.

[@henry5649]

hi, just wonder to know how can I connect to oracle autonomous database in mac m1.

[@DatabaseStar]

If it's cloud hosted, I have a video for that on my channel.

[@ankursingh730]

That is really helpful. I was able to Install Oracle on my Macbook M3. PS: Any tips on installing Sql Plus too on macbook (apple chip)?

[@DatabaseStar]

Glad it helped! I don’t have any tips for that, I thought it already came with the database. I’ll look into it though.

[@ankursingh730]

@@DatabaseStar thanks ! That will be helpful :)

[@mrsmart4102]

@@ankursingh730 did u find a way to use the sql plus

[@MdAzharuddin-h3u]

why i cant find my table which i created earlier whenever i close vs code

[@DatabaseStar]

I'm not sure, it should be there even if you close VS Code. Are you on the same connection?

[@shadinvp1211]

How to create a user in this database ? It showing error when using this command “CONN USER user_name IDENTIFIED BY mypassword “after connecting database

[@DatabaseStar]

Good question. It's a bit confusing with the recent CDB and PDB architecture in Oracle, but essentially you log in to the plulggable database and create the user. I've written a little about it here: www.databasestar.com/oracle-pdb/

[@jasonadventure2265]

Very good video, I'm waiting for a long time, thank you so much

[@DatabaseStar]

You're welcome!

[@LuisGonzalez-zl8pm]

Thank you sou much! It was very helpful for me. Greetings from Cuba

[@DatabaseStar]

Glad it helped!

[@PShrinidhi]

I am getting 400 bad request What should i do

[@DatabaseStar]

When are you getting that error?

[@philippemallari8077]

does this work for m3?

[@DatabaseStar]

Yes it should, but I haven't tried it.

[@philippemallari8077]

@@DatabaseStar it does work thanks

[@engmmazeem]

Well Done, It worked with me .. Thank You

[@DatabaseStar]

Glad it helped

[@marcohiponia]

Great tutorial!

[@DatabaseStar]

Thank you!

[@philippemallari8077]

hey guys, how do you insert an existing file?

[@DatabaseStar]

What do you mean by existing file? If you mean a CSV file, you can import that with SQL Developer

[@philippemallari8077]

@@DatabaseStar yes thanks, i do have a question, when I try to connect to a specific user it says: "SQL> connect leticia; The connect request was not recognized: please type HELP CONNECT to find out more about the supported combinations of command options SQL> connect cprg250; The connect request was not recognized: please type HELP CONNECT to find out more about the supported combinations of command options SQL> connect cprg250s; The connect request was not recognized: please type HELP CONNECT to find out more about the supported combinations of command options SQL> select * from customers;" how can I connect to a specific user?

[@carloskelaidis6077]

Something I'm not quite clear on. Does this allows me to connect to a remote Oracle DB? Or is this a local Oracle DB? Because I'm on M1 Mac and need to connect to an Oracle DB hosted on my company's server. Any help is much appreciated!

[@DatabaseStar]

This will allow you to set up a local Oracle database, one that runs on your computer. You can use SQL Developer or another tool to connect to it. Or you can use SQL Developer to connect to the Oracle DB on your company's server.

[@aiyananowar7718]

YOU'RE A LIFE SAVER 🙏

[@DatabaseStar]

Thanks!

[@muhammadandynurkautsar7616]

No docker or podman executable found in your PATH

[@DatabaseStar]

Do you have docker installed?

[@frederikjorgensen94]

It worked! ✅Thank you so much man!

[@DatabaseStar]

You’re welcome, glad it helped

[@BANKAPALLIMANOJ]

i did everything as shown in video but u got connection issues

[@DatabaseStar]

What issue are you having?

[@Chunzhendingyilang]

You are life saver, thank you so much!

[@DatabaseStar]

You're welcome!

[@fatkur]

is that free? how about XE version?

[@DatabaseStar]

I believe it is, but check the download page to be sure.

[@llwii-fs6pm]

how can I change the username?

[@DatabaseStar]

You can create a new user on Oracle by logging in to the SYS account and running a Create User command. I have a video coming out soon with the steps to do this.

[@api_maker]

Thank you so much for this great video..!!

[@DatabaseStar]

Glad it was helpful!

[@suat6282]

Installation on MacBooks is a problem in itself, thanks for sharing.

[@DatabaseStar]

You're welcome!

[@prteek10]

Most waited video 👍👍👍

[@DatabaseStar]

Yeah it has been a long time coming!

[@prteek10]

@@DatabaseStar How is Perfomance of laptop? Resource utilization of m1?

[@douglassouza8884]

Thank you friend, tutorial grade 10.

[@DatabaseStar]

Glad you liked it!

[@raguveer6277]

Status is showing un healthy what to do?

[@DatabaseStar]

I would suggest looking at the docket logs. I forget the command for it, but there is a way to look at the logs to see if there are any errors and the details of them.

[@raguveer6277]

@@DatabaseStar Ok 👍🏻 Thank You

[@Penitent85]

thank you great video it's work 100%

[@DatabaseStar]

Glad to hear it worked!

[@Penitent85]

@DatabaseStar it's also work with oracle sql developer

[@anthon-x5871]

Amazing, great help!

[@DatabaseStar]

Thanks!

[@raulosoy2220]

bro you save me, my Inglish its so bad but I can do all the proces and my db works, thanks form GT

[@DatabaseStar]

Glad I could help

[@rajands65]

Thank you so much !

[@DatabaseStar]

You're welcome!

[@insung27]

you're the best!

[@DatabaseStar]

Thanks!

[@gag2077]

amazing you are the best

[@DatabaseStar]

Thanks!

[@exocy6480]

it says that my password or username is wrong eventhough i used your commands

[@DatabaseStar]

Oh that’s odd. Are you connecting to the CDB or the PDB? I get this error sometimes even though the password is definitely right.

[@exocy6480]

@@DatabaseStar Both. I restartet the container and it somehow worked

[@miguelangelllanten8289]

How can I know the password of the user “SYS”?

[@DatabaseStar]

You set this when you install the database. I don’t know if there’s a way to reset it if you don’t know it.

[@nicolasmarino5314]

Thank you!!

[@DatabaseStar]

You're welcome!

[@christopheralvaradoflores6265]

Hi, when I try to execute the build command I have the next error: /opt/oracle/product/19c/dbhome_1/runInstaller: line 67: /opt/oracle/product/19c/dbhome_1/perl/bin/perl: cannot execute binary file: Exec format error

[@DatabaseStar]

Oh I’m not sure why that error would be happening

[@sameerkurhade6436]

thank you so much really

[@DatabaseStar]

You're welcome

[@JeevanAppu-ys6iv]

Hi I'm getting an error like no docker or podman executable found in your path. Can please guide me

[@DatabaseStar]

Do you have docker installed? If so, is the path to the file correct?