Installing And Downloading Oracle 11g On Mac UPDATED

Munoz Rabliver – February 28, 2022

• Facebook
• Twitter
• WhatsApp

Installing And Downloading Oracle 11g On Mac

In this post, you're going to learn the exact steps to take to install Oracle on your Mac computer.

This guide includes:

• stride-by-stride instructions on downloading and setting upward the required software
• screenshots at each stage
• explanations of the configurations you need to fix (such as connecting to the database)

And then if you want to fix up Oracle on your Mac reckoner, y'all'll beloved this guide.

Permit's become right into information technology.

Overall Process

Installing an Oracle database on a Mac computer is a fleck different from installing it on a Windows or Linux calculator.

Oracle doesn't back up running an Oracle database directly on a Mac calculator. You can't install Oracle Express, for example, in the same style that you can on a Windows computer.

The good news is that y'all tin utilize a Virtual Machine. To get set up with Oracle on your Mac, the general process is shown below.

Note: An alternative to using a Virtual Machine is using Docker. I believe using Docker is a simpler process and seems to less resources-intensive than a Virtual Car. I've documented the entire process here if y'all want to try that method instead: How to Fix a Database on Docker.

Table of Contents

1. Become VirtualBox
2. Download the Oracle Developer VM
3. Gear up Upwards Oracle VM
4. Run the Oracle VM
5. Test Using SQL Developer

Let'southward take a look at the requirements, and then get into the steps.

Requirements for Oracle VM on a Mac

So, what practice y'all need to be able to run Oracle using a VM on a Mac?

The requirements for running a virtual auto are listed on Oracle's page here (final updated xx Jun 2019), and are shown below:

• At least 2GB RAM. Default VM is 1G RAM, for amend performance increase.
• At least 15GB of free infinite

• 2GHz processor (a bottom processor will be acceptable but slower)

• Mozilla Firefox ii.0 or higher, Internet Explorer 7 or higher, Safari 3.0 and higher or Google Chrome 1.0 or higher

• Admin privileges on your computer

My electric current Mac is a 2018 MacBook Pro with 8GB of RAM and a 256GB hard drive, which runs the VM pretty well.

On my previous MacBook Air (2015, 4GB RAM), it actually ran pretty slowly, because the 4GB RAM is split with 2GB for the VM and two GB for the Mac Bone, bringing both systems to a crawl. MacBook Airs are not designed to be able to run intensive programs such every bit VMs.

If you actually want to use Oracle on a Mac, simply don't quite come across the requirements, yous can use Oracle Live SQL, which is a web-based Oracle database.

Assuming yous want to install Oracle on your Mac, let's look at the steps.

Step 1: Become VirtualBox

The first step to getting Oracle on your Mac is to download a program called VirtualBox. This plan allows you lot to run virtual machines, which are cocky-independent operating systems. It will let you lot run a Windows or Linux operating system inside your Mac.

I suggest VirtualBox because it'south free, and Oracle provides a ready-made file that you tin utilise with it. One alternative is Parallels, which I explain at the end of this guide.

To download VirtualBox:

Footstep 1A: Become to the VirtualBox website: https://world wide web.virtualbox.org/wiki/Downloads (opens in new tab).

The current version is shown at the top of the folio (currently it is 6.ii.half-dozen).

Stride 1B: Click on "Os X Hosts". This is a directly link to a .dmg file, which is the installer file for Mac.

The file will start downloading. It'southward approximately 122 MB.

Step 1C: Once the file is downloaded, open it.

Stride 1D: Double click the VirtualBox.pkg icon in the window that appears.

Step 1E: Click Continue if a message appears about installing the package.

Stride 1F: Click Proceed on the welcome screen.

The installer volition tell yous how much infinite VirtualBox will have upwards (approx 251.eight MB).

Step 1G: Click Install.

Stride 1H: Enter your password if prompted.

The program will at present exist installed.

Step 1I: Once completed, information technology volition inform y'all the installation was successful.

Stride 1J: Click Shut, and move the installer to the trash.

Installation Failed?

Did you get an mistake saying the installation had failed for VirtualBox VM?

The installation failed.

The Installer encountered an fault that caused the installation to neglect. Contact the software manufacturer for assistance.

I got this error when attempting to install VirtualBox on 10 May 2020, running macOS Catalina 10.15.4.

How tin you resolve this?

These are the steps I followed (thanks to Daniel Meechan'south article here):

Follow the steps from 1D to 1G above, stopping when y'all get to the screen with the "Alter Install Location" and "Install" buttons. Don't click Install.

Open Organization Preferences from the Apple bill of fare.

Click on Security & Privacy (second row, far right).

Click on the General tab.

You should run across a greyed-out bulletin at the bottom of the window proverb "Arrangement software from developer "Oracle America Inc." was blocked from loading.

Click the padlock icon on the bottom left of the window to unlock this window.

Enter your password and click OK.

The disabled text and buttons should now exist enabled.

Click Permit.

Enter your countersign once again.

Now, return to the VirtualBox installer and click Install.

Resume the steps above from 1H. The installation should now exist successful.

Step 2: Download the Oracle Developer VM

Now you've got VirtualBox installed, yous need to download the file that contains the Oracle database. This is the virtual car file and is provided by Oracle.

It's called the "Oracle Developer VM" or "Oracle Developer Day VM", as it was originally created for developers but information technology has expanded since and so.

To download this file:

Step 2A: Visit the Oracle Developer 24-hour interval download page here (terminal updated 20 June 2019).

This page lists the versions of software it comes with. At the fourth dimension of writing, this is Oracle Linux 7 with Oracle Database xix.iii.

Pace 2B: Roll to the lesser of the folio and click the Oracle DB Develop VM link.

Footstep 2C: On the popup that appears, check the box to accept the license understanding, and click the green Download push.

Step 2nd. You'll be asked to log in to your Oracle account. If you accept an account, enter your details. If you don't accept an business relationship, y'all can create one. It's easy and free.

Pace 2E: Once you accept logged in, the Developer Days VM file volition start downloading. Information technology has an "ova" extension.

This file is well-nigh 7GB so may take a while. I've had no issues downloading information technology with Chrome, just you may want to apply a download manager if your connection isn't very good.

Step 3: Fix the Oracle VM

Now you have downloaded the Oracle VM file, it's time to ready it up.

Footstep 3A: Open VirtualBox. I unremarkably do this past pressing Command + Space and typing in VirtualBox.

Step 3B: Click File, and so click Import Appliance (or click the Import push button at the top of the main screen). The Appliance to Import screen is displayed.

Step 3C: Click the Cull File button on the right of the textbox, which is the little yellowish folder icon with the green pointer. (Leave the Source textbox equally the default "Local File System").

Pace 3D: Select the DeveloperDays OVA file you have just downloaded, and click Open.

In that location's no need to excerpt the file earlier opening information technology.

Footstep 3E: Click the Go on button on the chief installer.

Step 3F: Click Import on the Application Settings page.

Step 3G: Click Agree on the popup that appears.

Step 3H: The import process will begin. This procedure took well-nigh 2 minutes for me.

Step 3I: Once the installer is finished, you should encounter "Oracle Programmer Days (Powered Off)" on the left panel of the VirtualBox window.

This ways the VM is installed but not running.

Stride iv: Run the Oracle VM

Now the installation has finished, it'southward time to run the Oracle VM.

Step 4A: To run the Virtual Machine, click once to select "Oracle DB Programmer VM" and click the green Start arrow.

There volition exist a minute or then of a black screen with white text as the virtual machine loads, and a black screen.

A Linux desktop volition announced, and a moment afterward a last window will announced:

The virtual machine is now ready to use.

A Notation About Firewall and Port Forwarding

In previous versions of VirtualBox and this VM, we had to take extra steps to brand the VM visible to the host (the Mac that you lot are running the VM on). We also had to fix port forwarding, which would allow us to enter in an IP accost such as "localhost" on the Mac and have it forward to the Virtual Car.

All the same, this configuration is already done in the latest version. So, these steps are no longer needed. Once the VM is running, every bit mentioned above, nosotros can connect to it using SQL Developer (or another IDE).

I've removed these steps from the guide, only the comments beneath even so refer to them.

Let'southward go on!

Step v: Test Using SQL Developer

The last step is to test this connection using SQL Developer.

Step 5A: Open SQL Developer on your mac. If y'all oasis't downloaded it, you can download information technology from the Oracle website.

Footstep 5B: Create a new connexion by clicking on the greenish + icon.

Step 5C: Enter these details for your connection:

• Name: whatever you lot like. A name such as "VirtualBox Oracle" is OK if yous can't think of anything.
• Username: 60 minutes
• Countersign: oracle
• Cheque Save Countersign if you don't desire to enter the password every fourth dimension.
• Hostname: localhost
• Port: 1521
• Select "Service Name" instead of "SID"
• Service Proper name: orcl
• Connection Type: Basic

Your connectedness screen should look something like this:

Pace 5D: Click "Test" to test the connection. The message should say "Success", which means the connection has worked.

• If it says "Listener refused the connection with the following error: 12514", and so you likely have the Service Proper noun wrong.
• If it says "Listener refused the connection with the following error: 12505", so you lot likely have selected SID instead of Service Proper name.
• If it says "Test failed: ORA0-1017: invalid username/password, logon denied", then you likely have an incorrect username or password, or one of several other issues.

I've written more than about resolving Oracle connectedness issues hither.

Footstep 5E: Click Save to save your connection in the list.

Footstep 5F: Click Connect. After a moment, a new SQL worksheet window is opened on this new connection.

You tin now run SQL queries on Oracle on your Mac. This will piece of work for as long every bit you have the Virtual Machine running in the background.

To examination this, you can run this query:

                SELECT * FROM v$version;              

This will testify the current version of the Oracle database.:

Your Mac tin can now access your Oracle database running on your ain virtual machine!

Shutting Downwardly

One time you lot have finished with your Oracle SQL session, yous tin can close down your VM. To do this, go to Machine > ACPI Shutdown. The Virtual Auto will go back to a "Powered Off" when it'southward done.

Culling to VirtualBox: Utilise Parallels

1 alternative to this process of using VirtualBox and the Oracle VM is to use Parallels. Parallels is a VM awarding, only like VirtualBox. The key differences are:

• It has a different VM file format, and then y'all tin can't employ Oracle's VM files.
• Information technology's a paid tool, unlike VirtualBox which is free.
• Yous can install your own operating system on information technology, so you tin can run Windows 10 for example, instead of Oracle Linux. VirtualBox allows this equally well.
• You lot tin install your ain version of Oracle on there, such as Oracle Express or an earlier/later version of Oracle.

The steps are quite similar to setting up VirtualBox. To prepare Parallels for an Oracle database on your Mac, the high-level steps are:

1. Purchase and download Parallels for Mac (or employ the free trial).
2. Install Parallels.
3. Ready upwards a new Virtual Machine on Windows 10. I don't know if you have to download the Windows x (or other Windows version) ISO file, or if Parallels tin can practise that for you lot.
4. Once the operating organisation is installed, download Oracle or Oracle Express from the Oracle website, inside your virtual machine.
5. Install it on your virtual machine equally though you're running it on a Windows reckoner.
6. Configure the port settings in a similar way as y'all did for VirtualBox
7. Connect to the virtual machine from SQL Programmer on your Mac.

I've used Parallels in the past for this. The only reason I stopped was because my MacBook air didn't have the specs to keep up with running a VM.

Summary

Some developers want to run an Oracle database on a Mac. While Oracle is not natively available on a Mac computer, it's possible to run Oracle or Oracle Limited on a Mac using a virtual machine.

This article describes the steps you demand to have to ready the existing Oracle Programmer VM and VirtualBox on your Mac to get it upwards and running.

DOWNLOAD HERE

Posted by: cranegrele1964.blogspot.com

• Facebook
• Twitter
• WhatsApp