Oracle Xe Download For Mac

Oracle database for learning purposes. Viewed 1k times 0. I would like to know if I can download Oracle Database on my Mac OS X and use it for learning purposes? I know that Oracle Database Express Edition 11g is free, but is it free for OS X? Under Linux, as root, run 'rpm -i oracle-xe-10.2.0.1-1.0.i386.rpm'. Has to be owned by the Unix user „oracle“ or set appropriately. If omitted the database will not be persisted over container recreation. Use the Oracle XE container. Stop the container with docker stop or start it with docker start. Connect to the database from macOS using localhost, port 1521 and SID XE.

  • Oracle Database Express Edition (XE) is a community supported edition of the Oracle Database family. Please go to the Oracle Database XE Community Support Forum for help, feedback, and enhancement requests. Note: Oracle Support Services only provides support for Oracle Database Enterprise Edition (EE) and Oracle Database Standard Edition 2 (SE2) in conjunction with a valid Oracle.
  • An Oracle Database XE installation will consume around 9 gigabytes of disk space under /opt.If this disk partition does not have the required disk space available, you must add space or mount an alternative partition as /opt/oracle.
  • The first step to getting Oracle on your Mac is to download a program called.

Update: May 14, 2019This article originally contained instructions for running Oracle 12c. The Docker image that was being used was deleted by the author and so was not usable. I have updated the instructions to work again, though the image it uses now runs Oracle 18c. If you need to run 12c specifically, you’ll need to look for instructions elsewhere. Some screenshots may now be out of date.

In this post, we will go through the steps of installing Oracle 12c in a Docker container and connect to the database using SQL Developer on a Mac. This is a much lighter way of running Oracle locally compared to running a full Windows virtual machine with VMWare or Virtualbox.

1. Install Docker

- If your Mac is newer than 2010
You can simply install “Docker for Mac”.Download and install “Docker for Mac” from here (You’ll have to create a quick account to download it. Annoying, I know)

- If your Mac is 2010 or older
You can still run Docker, but there will be a few extra steps. You’ll install a tool called “Docker Toolbox” which includes everything you need.Download and install “Docker Toolbox” here.

2. Pull Docker image

Download
  • Open the Terminal app and run the following. If you get no errors Docker is installed correctly and running.

  • Pull the Oracle image by running

3. Create container

  • First we create a directory outside the Docker container to store the database

  • Then we create a new container with our downloaded image

This should return a long hash string.

Scripts are disabled!

DownloadOracle on mac
  • Open Kitematic and find the container we just created.
  • Click the “Start” button. The first time you start the container, it will take a 5-10 minutes for the database to build. Just wait until the log reads: DATABASE IS READY TO USE!

4. Install SQL Developer

  • Head to this page, click the Agree button and hit Download. You’ll have to create a quick account to continue through the download (very annoying, I agree).
  • Unzip, drag the app into the Applications folder, and fire it up

5. Connect to Oracle database

  • In SQL Developer, click the green plus button to create a new connection.
  • If your Mac is 2010 or older: Get the IP address of your Oracle container by opening Kitematic and switching to the Settings and then Hostname / Ports. Use this in the next step for Hostname.
  • The default credentials to connect are as follows:
    • Connection Name: Whatever you want. I suggest “Docker - Oracle System”
    • Username: system
    • Password: Password1
    • Hostname: localhost
    • Port: 1521
    • SID: xe
  • When you’ve filled all that out, hit “Test”. If the message in the lower-left corner reads “Status: Success”, you’ve done it correctly. Hit Save and then Connect. If you didn’t get a success message, double-check your IP address and username/password combination.

Oracle Xe Mac

6. Creating new databases

  • In Oracle 12c, users and databases are essentially the same thing. So to create a new database, we’ll create a new user with the following SQL queries, assuming we want to create a database with name “SALES” and password “password”. Execute the following in a SQL worksheet

Change SALES to whatever database name you want

Potential Problems

  • IO Error: The Network Adapter could not establish the connection
    This means that you are trying to connect with SQL Developer, but your Docker container is stopped. Open Kitematic, select your Oracle container, and click “Start”. When the logs read “Database ready to use. Enjoy! ;)”

This article explains how to create and use a Docker container with an Oracle XE database on macOS. The following steps are very simple and easy. The database setup needs only minutes and works very well for development and testing purposes.

Requirements

  • Docker software for macOS is installed and configured (Download Docker for Mac).

Create and Configure the container

1. Navigate to github to get official Docker images for Oracle Software

2. Clone the git repository

docker run--name OracleXE--shm-size=1g-p1521:1521-p8080:8080-eORACLE_PWD=weblogic1 oracle/database:11.2.0.2-xe

Oracle Xe Download Mac Os

* Note:*

  • Add -v option to the command to specify the data volume to use for the database. Has to be owned by the Unix user „oracle“ or set appropriately. If omitted the database will not be persisted over container recreation.

Use the Oracle XE container

1. Stop the container with docker stop <container id> or start it with docker start <container id>.

2. Connect to the database from macOS using localhost, port 1521 and SID XE. When using another VM on your macOS (example: a JDeveloper environment managed with vagrant) you have to use the IP address of you macOS system instead of localhost when connecting to the database.

Oracle Xe 18 Download

Links

Oracle Xe Database Download For Mac

Unsere Leistungen im Bereich Architektur

Mehr erfahren