How to install an Oracle Database on your MacBook

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:

  1. Install Oracle VM VirtualBox Manager

You can download it from https://www.virtualbox.org/ and the installation is very simple.

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

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

MYMAC_DB =

(DESCRIPTION=

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

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s