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.
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!!
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
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?
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.
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?
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?
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
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!
I restarted my Mac and then launched docker, ran the image and then tried to run Oracle 19c DB but unable to from VSCode. What to do? A connection with the database could not be established
@@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?
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?
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
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/
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!
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.
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.
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 .
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.
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 It's a pain. I've been trying to do it for a few days. I didn't succeed. I think the option with a virtual machine on Windows will pass.
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 Thanks for posting. I am also seeing this error. It is during buildContainerImage.sh. A little more detail if you may have any suggestions: => ERROR [stage-2 2/4] RUN "/opt/oracle"/oraInventory/orainstRoot.sh && "/opt/oracle/product/19c/dbhome_1"/root.sh 0.1s ------ > [stage-2 2/4] RUN "/opt/oracle"/oraInventory/orainstRoot.sh && "/opt/oracle/product/19c/dbhome_1"/root.sh: 0.076 /bin/sh: /opt/oracle/oraInventory/orainstRoot.sh: No such file or directory
@@DatabaseStar Thanks for posting. I am also seeing this error. It is during buildContainerImage.sh.A little more detail if you may have any suggestions: => ERROR [stage-2 2/4] RUN "/opt/oracle"/oraInventory/orainstRoot.sh && "/opt/oracle/product/19c/dbhome_1"/root.sh 0.1s ------ > [stage-2 2/4] RUN "/opt/oracle"/oraInventory/orainstRoot.sh && "/opt/oracle/product/19c/dbhome_1"/root.sh: 0.076 /bin/sh: /opt/oracle/oraInventory/orainstRoot.sh: No such file or directory
Hi, When I am trying to run the build command I get an error like this on my M1 Macbook Air: => ERROR [builder 1/2] COPY --chown=oracle: dba LINUX.ARM64_1919000_db_home.zip db_inst.rsp installDBBinaries.sh /opt/install/ 0.0s ------ > [builder 1/2] COPY --chown=oracle:dba LINUX.ARM64_1919000_db_home.zip db_inst.rsp installDBBinaries.sh /opt/install/: ------ 1 warning found (use docker --debug to expand): - FromAsCasing: 'as' and 'FROM' keywords' casing do not match (line 25) Dockerfile:108 -------------------- 106 | 107 | # Copy DB install file 108 | >>> COPY --chown=oracle:dba $INSTALL_FILE_1 $INSTALL_RSP $INSTALL_DB_BINARIES_FILE $INSTALL_DIR/ 109 | 110 | # Install DB software binaries -------------------- ERROR: failed to solve: failed to compute cache key: failed to calculate checksum of ref 8e807cfe-0856-42f7-a3f7-4adb514edf4b::z8lqyiby3t5edaw7xn648a4gt: "/LINUX.ARM64_1919000_db_home.zip": not found ERROR: Oracle Database container image was NOT successfully created. ERROR: Check the output and correct any reported problems with the build operation. Could please help me in resolving this.