The best way I have found for installing an Oracle Database (EE 12c) on you MacBook is installing a Database Virtual Box Appliance / Virtual Machine.
Main steps are:
- Install Oracle VM VirtualBox Manager
You can download it from https://www.virtualbox.org/ and the installation is very simple.
- Download the VM appliance from Oracle
I recommend to use a download manager as I failed twice just trying to download it as a normal file using Chrome. I installed DownThemAll from http://www.downthemall.net/ (note: it requires Firefox). The OVA file can be downloaded from: http://www.oracle.com/technetwork/database/enterprise-edition/databaseappdev-vm-161299.html
- Create the Virtual Machine.
Open VM Virtual Box and go to File/Import appliance. Then select the file that you have download and just go forwards.
And that’s all. Everything is installed.
Start working with your database
Now you should start the VM for starting using your database. Then you will be ready to make a client connection from you Mac, either using a tnsnames entry as follows:
(ADDRESS= (PROTOCOL=TCP) (HOST=127.0.0.1) (PORT=1521) )
(CONNECT_DATA= (SERVER=dedicated) (SERVICE_NAME=cdb1) )
Or using a jdbc connection string like jdbc:oracle:thin:@127.0.0.1:1521/PDB1
All passwords are oracle (including user sys).
For being able to share files between your Mac and the Oracle VM you can enable the drag and drop option in the Oracle VM VirtualBox Manager. Select the VM created, click on Settings. A new window will pop up. In the General screen you will find where to set up the Shared ClipBoard and the Drag & Drop in the tab Advanced.
Latest note: this should not be used for creating an environment for developers, testers, etc. And off course if you are thinking about a production environment just forget it.