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
Oracle 11g free download. Development Tools downloads - Oracle Database 11g Express Edition by Oracle Corporation and many more programs are available for instant and free download. More discussions in Oracle Database Express Edition (XE) This discussion is archived.
- 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 |
* 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.