In this video, I want to share with you how I installed Oracle Database 11g on MAC OS using Virtual Machine. If you have some questions, post it in comments. Oracle 11g free download. Development Tools downloads - Oracle Database 11g Express Edition by Oracle Corporation and many more programs are available for instant and free download. The overhead is really negligible as if you’re natively running Oracle Server on your machine. Let’s see how to install Oracle Database Express 11g on your shiny Mac via Docker. Your Mac(iMac, Mac Mini, Mac Pro, Macbook Pro, Macbook Air or whatever Mac Apple is going to release after I publish this post). Download and install prior to installing Oracle Real Application Clusters, Oracle Real Application Clusters One Node, or other Oracle software in a Grid Environment Oracle Database Gateways 11g Release 2 (220.127.116.11.0) for Microsoft Windows (x64). For example, Oracle Call Interface 19 and 18 can connect to Oracle Database 11.2 or later. Some tools may have other restrictions. In a future Oracle release only DMG files will be available. Note ZIP files are not notarized.
- Oracle Database For Mac
- Oracle Sql Developer For Mac
- Install Oracle On Mac
- Oracle Sql Developer Download Mac
Recently I tried to install Oracle XE into a docker container on Mac OS Sierra using the official docker file from Oracle. I had no luck, because the installation failed with this error message:
This system does not meet the minimum requirements for swap space. Based on the amount of physical memory available on the system, Oracle Database 11g Express Edition requires 2048 MB of swap space. This system has 0 MB of swap space. Configure more swap space on the system and retry the installation.
The problem is, that you can't do anything for this on a Mac - the system manages the swap files by itself and if you need for an example 64 GB you will get it. My new standard MacBook has 8 GB RAM and there is currently no reason for a swap file.
So, what can we do? After a short search I found this blog post, which describes how to alter the pre-installation script of the RPM installation file with the help of the
repmrebuild command. Unfortunately this command is not available on Mac OS. I found only rpmbuild as part of the rpm installation with Homebrew.
Luckily I found another way to modify a rpm package under Mac OS: There is a Ruby based tool to build packages for multiple platforms called fpm. So, lets start:
If you don't have Homebrew on your Mac, install this first:
Unzip the downloaded Linux XE installation archive and go into the directory Disk1:
Write rpm scripts to text file:
Find this loop (from line 197 until line 212 as of this writing) and comment out or delete it:
Find this line (starting on line 328 as of this writing) and delete the line and everything behind until the file end:
Delete the very first line containing this code:
Oracle Database For Mac
Save the file and bring it back into the rpm with this command (will take some time):
Go out of Disk1 and update the zip archive, because the Oracle provided build script needs it compressed (will take some time):
When you now do the Docker build you will face another error message:
package oracle-xe-11.2.0-1.0.x86_64 is intended for a different operating system
To fix this is fairly easy. Open the Dockerfile.xe, go to line 61 (as of this writing) and change this code:
to this one:
When you now start the docker build you should be successful (will take some time):
The last step is to run the container - on the first startup the database is created (will take some time, align the name to your needs):
If you plan to use APEX without any dedicated webserver (maybe because you are the only user and it is only a small dev instance) you should pimp the EPG a little bit:
I use currently a Node.js based proxy server running directly on my Mac OS, because I need a webserver there anyway. The nice thing is, that the EPG don't need to serve the images and I also don't need to install the images into the EPG, when I upgrade to a newer APEX version. This saves me time and the EPG runs faster because of less number of requests. I will cover this topic in the next post.
Happy installing :-)
A few semester back I finished database design course at university. While the theory part was all about database design the lab part focused more on database manipulation. Or in simpler words it was all about SQL. Now if you want an RDBMS software what choices do you get? A lot! Oracle, Microsoft SQL Server, MySQL etc etc. The list will just rage on these days. Our lab instructor however insisted on using Oracle, and that bugged me out because I carry a macbook to the lab for lab works and – there’s no MacOS version by Oracle for the Oracle Database Express. But, we’re in the age of VM’s and who cares what OS you’re using? Use a VM, job done! Now should you install an entire OS on VM for that? Well, it’s overkill. That’s why Docker comes in, it creates a Linux VM where you can deploy install test and do whatever you want with your applications. The overhead is really negligible as if you’re natively running Oracle Server on your machine. Let’s see how to install Oracle Database Express 11g on your shiny Mac via Docker.
What you need
- Your Mac(iMac, Mac Mini, Mac Pro, Macbook Pro, Macbook Air or whatever Mac Apple is going to release after I publish this post)
- Make sure your machine has enough RAM to power a VM. Anything above 4GB is fine.
- Make sure again you’re running the Latest Version of MacOS
- Docker Toolbox + Kitematic
- And yes you need some time. Grab some coffee or Doritos if you want to.
First : Download Docker Toolbox and install it
Download Docker Toolbox + Kitematic dmg form this LINK . You know how to install from dmg images on your mac so I’m just skipping this part.
A note : MacOS may block the installer from running saying it’s unidentified. Just allow it from “Security and Privacy” in System Prefs.
Docker is a command line based tool and we don’t want to get pinned down with large commands, Kitematic, with it’s GUI makes life easier for us and helps completely forget that Docker needs cli. At least for our purpose!
If Docker shows some error like it’s unable to create the VM, install Oracle Virtual Box. A quick google will give you the link. First time installation will take a while so have patience. You’ve coffee and Doritos right?
When it’s ready you’ll get this Window. You can create an account if you want, or skip for now. I’d suggest opening an account. Has some benefits.
Next Part : Download and install Oracle Database Express 11g Image
You don’t need to look further! Just type in the name and Kitematic will find out the image for you(if it’s available).
Well well, a lot of choices , I mean images. So which one to choose? I’ll go with the marked one (because I’ve used it, tested, works.) – created by “wnameless”. Click on create and let the wait flow through you. Kitematic will download and install the image for you. Easy. You just need to wait.
Aaaaaaaaand we’re ready!
Kitematic has done the hardwork for us, now it’s time to get to work.
Now we need to start the server. Just click on start. Wait Until you see Unauthorized in Web Preview. The server needs some time to set in. Once you see it, click on the button beside right to web preview.
Oracle Sql Developer For Mac
Oracle Database Express will now open in your system default web browser. You can copy paste the address to another browser if you want to!
Now you need a username and password. As the Docker image doc goes, you need to use these credentials.
Install Oracle On Mac
username : system
password : oracle
Now this should be working pretty nice but it doesn’t. From my experience I’ve found that you can’t login this way. What you need to this , enter the credentials and when it asks again for credentials , cancel it, then refresh the page. It works this way. If you find a workaround, feel free to leave a comment. May help others (and me too!)
Remote view for mac. Hail the Oracle Database
So we’re in and this is what Oracle Database system looks.
Now what happens if you accidentally close the window? No problem, just open it from Docker again. Funny thing is , this time it won’t bother you with that login issue.
Let’s create an user and configure system admin for database
You now need an user account to work with the database and also need admin privilege to create user and workspaces for them. Now who’s the admin? You’re, and you’ve the login credentials we mentioned above.
Click on Application Express to begin with. Login with username : system and password : oracle.
For first time use, create a new user, a database and give the user a password. Now what if you’ve worked for some time then logged out and want to get back where you left off. Follow the instruction the the image, click on that button, enter the username and password you used when creating the user and you should be right back where you left off. Cool!
Oracle Sql Developer Download Mac
So let’s just wrap it. It was a long procedure, I hope you didn’t run out of coffee and Doritos.