Installing Oracle Database on macOS: A Simple Guide Using Docker

Oracle Database installation on macOS can be challenging since there's no native installer. However, Docker makes this process straightforward by running the database in a container. This guide will walk you through installing Oracle Database using Docker and connecting to it through Visual Studio Code.

Before You Begin

Your Mac needs to meet these basic requirements:

• macOS 10.15 or newer
• At least 4 GB RAM available for Docker (Oracle Database needs significant resources)
• An Oracle account for accessing their container registry
• Docker Desktop installed on your system

Installing Docker Desktop

Getting Docker set up is your first step:

1. Download Docker Desktop from the official Docker website
2. Install it like any other Mac application
3. Start Docker Desktop and wait for it to initialize
4. Verify the installation by opening Terminal and running:

   docker --version

Setting Up Oracle Container Registry Access

Oracle keeps their Docker images in a private registry. Here's how to get access:

1. Visit the Oracle Container Registry website
2. Create an account using your email
3. Find and accept the license agreement for the database/free repository
4. Open Terminal and log in to the registry:

   docker login container-registry.oracle.com

When prompted, use your Oracle account email and password

Installing Oracle Database

Now let's get Oracle Database running:

1. Download the Oracle Database Express Edition (XE) image:

   docker pull container-registry.oracle.com/database/free:latest

2. Start the database container:

   docker run -d --name oracle-db -p 1521:1521 container-registry.oracle.com/database/free:latest

3. Watch the database initialization (this takes a few minutes):

   docker logs -f oracle-db

4. When you see "DATABASE IS READY TO USE!", set up the system passwords:

   docker exec oracle-db ./setPassword.sh your-password-here

Replace "your-password-here" with a secure password you'll remember

Connecting Through Visual Studio Code

Let's set up VS Code to work with your new database:

1. Open VS Code and install the "Oracle Developer Tools for VS Code" extension

2. Set up your database connection:

   • Click the database icon in the sidebar
   • Select "+ New Connection"
   • Fill in these details:
     • Connection Type: Basic
     • Host: localhost
     • Port: 1521
     • Service Name: FREEPDB1
     • Username: SYSTEM
     • Password: (the password you set earlier)

3. Click "Test Connection" to make sure everything works

Common Problems and Solutions

If something's not working, check these common issues:

Database Won't Start

• Make sure Docker has enough memory (at least 4 GB)
• Check the logs with docker logs oracle-db

Can't Connect

• Verify the container is running: docker ps
• Make sure nothing else is using port 1521
• Double-check your password and service name

Password Issues

You can always reset the password:

docker exec oracle-db ./setPassword.sh new-password

Daily Usage Tips

• Start the database: docker start oracle-db
• Stop the database: docker stop oracle-db
• Check database status: docker ps

What's Next?

With Oracle Database running on your Mac, you can:

• Create and manage databases
• Write and test SQL queries
• Connect your applications to the database
• Practice database administration

Remember that this setup is perfect for development and testing, but for production use, you'll want to look into Oracle's enterprise offerings and proper data persistence strategies.

Happy database development! 🎉