Oracle Database 12c now available on Docker

Last week at Dockercon, Oracle announced that the Oracle Database is now available alongside other Oracle products the on Docker Store.

Given how much folks here in Silicon Valley (including my better half) rave about how easy and great Docker is, I thought I would try it out and share with you exactly how I did.

Since I was a Docker virgin, the first thing I had to do was download and install Docker. Then, a quick trip to the Docker Store followed by a double click, and I was up and running!

Next, I needed to get the new Oracle Database container. Again, you have two options here:

  1. Go back to the Docker Store and search for “oracle database” which will return a Docker container with a database but is not a persistent image. That means if you drop the container, the database disappears too. IIt’salso not possible to unplug the database from within the container and plug it in anywhere else.
  2. Go to Github, get an Oracle Docker build file, and go to and get the 12.2 database software. This combination will allow you to create a Docker container with the latest 12.2 database and persisted. That is to say, if the container is dropped, you still have the database, and it is possible to unplug the database and plug it in somewhere else.

I chose to go with option 2, which is a wee bit more involved but having 12.2 and a persistent image were both very important to me. And before you ask, yes, 12.2 will be made available in the Docker Store, and it will be persistent. IIt’sjust not there yet.

The steps below explain precisely what I did (with some help from @GeraldVenzl)

1. Go to and download the Oracle Docker build files.

2. Go to and download Oracle Database 12c Release 2 for Linux x86-64.

3. You should now have two files:

Unzip the file, which will result in a new directory called docker-images-master. This directory contains 12 subdirectories, one for each Oracle product supported on Docker.

creating: docker-images-master/
extracting: docker-images-master/.gitattributes
inflating: docker-images-master/.gitignore
inflating: docker-images-master/.gitmodules
inflating: docker-images-master/

4. Copy the 12.2 software ( into the /docker-images-master/OracleDatabase/dockerfiles/ subdirectory.

5. Next, you need to create the Docker image. I took the easy route and utilized the shell script, which is included in It will create an image using oraclelinux:7-slim and whichever database version you specify. I used the following command to install Oracle Database 12.2 software:

./ -v -e
Checking if required packages are present and valid... OK
Building image 'oracle/database:' ...
Sending build context to Docker daemon 2.688 GB

that the installer reaches out to the internet to get oraclelinux:7-slim and to do a yum update of the OS inside the container. If you are doing this behind a corporate firewall, you will need to explicitly set the environment variable https_proxy. The script will automatically detect http_proxy and https_proxy and pass it on to Docker to use for the image build.

6. Once the image is built you can check what you have by running the “docker images” command

docker images
REPOSITORY         TAG               IMAGE ID           CREATED             SIZE
oracle/database      7c2999a16928       7 hours ago       14.8 GB
oraclelinux         7-slim           442ebf722584       5 days ago         114 MB

As you can see, I have installed Oracle Linux and the Oracle Database software. But, unfortunately, we don’t have a database yet.

7. To get an actual database, we need to create our first container. I used the “docker run” command below to do this and supplied a couple of additional parameters for mappings since I wanted to persist the database files even if the container was removed.

docker run --name oracle -p 1521:1521 -p 5500:5500 
-v /Users/mcolgan-mac/oradata:/opt/oracle/oradata oracle/database:
LSNRCTL for Linux: Version - 
Production on 26-APR-2017 18:04:36
Copyright (c) 1991, 2016, Oracle.  All rights reserved.
Starting /opt/oracle/product/ 
please wait...
TNSLSNR for Linux: Version - Production
System parameter file is /opt/oracle/product/
Log messages written to /opt/oracle/diag/tnslsnr/75ca99d5275d/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=75ca99d5275d)(PORT=1521)))
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))

–name   Gave the new container the name “oracle”(will be auto-generated if omitted)
-p            Mapped port 1521 and 5500 on my laptop to the corresponding ports inside the container
-v             Mapped my local directory (/Users/mcolgan-mac/oradata ) to the default location where the data files will be stored (:/opt/oracle/oradata) to ensure the files are persisted outside my container.

8. The “docker run” command calls the Oracle DBCA and automatically creates a database. Since this is a 12c database, it will automatically create a container database ORCLCDB and one pluggable database ORCLPDB1 (both can be overwritten if you wish).
I didn’t specify a password for the SYS, SYSTEM or PDBADMIN accounts in my command, so one was automatically generated for me and displayed in the output of the command. Be sure to change the password from this default. Using the “docker exec” command, you can do this once your database is up and running.

docker exec oracle ./ XXXXXX

9. We can confirm that our container was created successfully and is running using the “docker ps” command.

docker ps -a
CONTAINER ID       IMAGE                         COMMAND                 CREATED        STATUS        PORTS         NAMES
75ca99d5275d       oracle/database:   "/bin/sh -c 'exec ..."   8 hours ago   Up 5 hours    oracle

10. Going forward, all we need to do is start and stop the container, which will open and close the database.

docker start oracle
docker stop oracle

You can monitor exactly what is going on during these commands by looking at the docker logs using the docker log command.

docker logs oracle
LSNRCTL for Linux: Version - Production on 27-APR-2017 18:58:05
Copyright (c) 1991, 2016, Oracle.  All rights reserved.
Starting /opt/oracle/product/ please wait...
TNSLSNR for Linux: Version - Production
System parameter file is /opt/oracle/product/
Log messages written to /opt/oracle/diag/tnslsnr/75ca99d5275d/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=75ca99d5275d)(PORT=1521)))
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version - Production
Start Date                27-APR-2017 18:58:05
Uptime                    0 days 0 hr. 0 min. 2 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /opt/oracle/product/
Listener Log File         /opt/oracle/diag/tnslsnr/75ca99d5275d/listener/alert/log.xml
Listening Endpoints Summary...
The listener supports no services
The command completed successfully
SQL*Plus: Release Production on Thu Apr 27 18:58:08 2017
Copyright (c) 1982, 2016, Oracle.  All rights reserved.
Connected to an idle instance.
SQL> ORACLE instance started.
Total System Global Area 1610612736 bytes
Fixed Size		    8793304 bytes
Variable Size		  520094504 bytes
Database Buffers	 1073741824 bytes
Redo Buffers		    7983104 bytes
Database mounted.
Database opened.
SQL> Disconnected from Oracle Database 12c Enterprise Edition Release - 64bit Production
ORCLPDB1(3):Database Characterset for ORCLPDB1 is AL32UTF8
ORCLPDB1(3):Opatch validation is skipped for PDB ORCLPDB1 (con_id=0)
ORCLPDB1(3):Opening pdb with no Resource Manager plan active
Pluggable database ORCLPDB1 opened read write
Starting background process CJQ0
CJQ0 started with pid=40, OS id=262 
Shared IO Pool defaulting to 64MB. Trying to get it from Buffer Cache for process 81.
Dumping current patch information
No patches have been applied
db_recovery_file_dest_size of 12780 MB is 0.00% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.

So there you have it, ten simple steps to get you up and running with Oracle Database 12.2 on Docker. If you want more details on building Oracle Database Docker images, check out Gerald’sblog.

28 thoughts on “Oracle Database 12c now available on Docker”

  1. ./ –v –e

    Checking if required packages are present and valid… OK OK
    Building image ‘oracle/database:’ …
    Sending build context to Docker daemon 2.688 GB ~ ???

    1. Hi Naveen,

      You caught me!

      I forgot to capture the screen output for this step, so I stole some from Gerald’s blog without realizing he had installed and not LOL!

      I’ve gone ahead and corrected the mistake!

      Thanks for keeping me honest,

  2. Hi Maria,

    As I see, you have installed this on your mac. Which is lightweight and preferred?Virtual box or docker?

    1. Hi Vivek,

      I’ve used virtual box exclusively in the past but I’m slowly converting over to using Docker now.

      With my Oracle Database environments I wouldn’t consider either option lightweight as they both require a minimum of 2GB of DRAM.

      My basic rule of thumb is virtual box for older versions of the Oracle Database, 11gR1 etc. as those images are readily available and Docker for newer stuff.


  3. Thanks, Maria,

    I am able to set DB and I have few questions:
    1. how I can login into this DB as a sysadmin and what will be the password.
    2. how can know service_name of this DB.

    1. Hi Daya,

      On the first startup of the container a random password will be generated for the database if one was not provided. You can find this password in the output line:


      You can also change the password for those accounts via the docker exec command. Note, the container has to be running before you do this:

      docker exec ./


  4. Hi Maria,
    I’m using windows 10 and Docker Tool box.

    I’m able create image, run and connect to database with out data volume creation.

    If i try to do with data volume creation, i’m getting below errors.
    Please guide me.

    SQL> Disconnected
    mkdir: cannot create directory ‘/opt/oracle/oradata/dbconfig’: Permission denied
    mv: cannot stat ‘/opt/oracle/product/’: No such file or directory
    mv: cannot stat ‘/opt/oracle/product/’: No such file or directory
    mv: cannot move ‘/opt/oracle/product/’ to ‘/opt/oracle/oradata/dbconfig/gkp/’: No such file or directory
    mv: cannot move ‘/opt/oracle/product/’ to ‘/opt/oracle/oradata/dbconfig/gkp/’: No such file or directory
    mv: cannot move ‘/opt/oracle/product/’ to ‘/opt/oracle/oradata/dbconfig/gkp/’: No such file or directory
    cp: cannot create regular file ‘/opt/oracle/oradata/dbconfig/gkp/’: No such file or directory
    ln: failed to create symbolic link ‘/opt/oracle/product/’: File exists
    ln: failed to create symbolic link ‘/opt/oracle/product/’: File exists
    ln: failed to create symbolic link ‘/opt/oracle/product/’: File exists
    cp: cannot stat ‘/opt/oracle/oradata/dbconfig/gkp/oratab’: No such file or directory
    ########### E R R O R ###############
    Please check output for further info!
    ########### E R R O R ###############
    The following output is now a tail of the alert.log:
    tail: cannot open ‘/opt/oracle/diag/rdbms/*/*/trace/alert*.log’ for reading: No such file or directory
    tail: no files remaining


    1. Hello Krish,

      Could you please tell how you have created the docker container without the volume switch (-v)


  5. Hi Maria

    Thank you for this clear and very useful guide. I had no problems getting it working.

    However, there is a problem with native compilation of PLSQL objects. Compilation works fine in “interpreted” mode, but with “native” mode it gets the following Internal Error:

    ORA-00600: internal error code, arguments: [pesldl03_MMap: errno 1 errmsg
    Operation not permitted

    This is covered in metalink article 1625010.1, where it says that /dev/shm needs to be mounted with rw and exec permissions and without noexec or nosuid.

    Is there a way to do this in the docker image, or when the container starts up (ie before starting the DB)?


  6. Hi Maria,

    Thanks for the write up. I have completed all the steps you have given above successfully.
    How do I now start working on the oracle database – I mean creating tables and all?
    In Gerald’s blog, he says to use “sql system/LetsDocker@//localhost:1521/ORCLPDB1” to connect to the DB. How do I do the same in mac? It is telling me “sql command not found.”


  7. Hi Maria, a question about oracle-database-11 on docker, can it be done with I tried but 11g have archive of two files, when i run i got an error like ‘missing files in folder’ , i run like -v -e

  8. I am getting the following error while creating the image . Could you help me with this .

    —> Running in 80129a4b716c
    —> 08b6c5cf64e6
    Removing intermediate container 80129a4b716c
    —> Running in f19c5fc4a6ec
    —> 3fed2f7d7458
    Removing intermediate container f19c5fc4a6ec
    Removing intermediate container f6a053631abd
    devmapper: Error mounting ‘/dev/mapper/docker-253:3-6292555-d8a22e7866427d7232a3ab403380a6de78d8d898ecc59e79628d8740b1871be5’ on ‘/var/lib/docker/devicemapper/mnt/d8a22e7866427d7232a3ab403380a6de78d8d898ecc59e79628d8740b1871be5’: input/output error

  9. ERROR: Oracle Database Docker Image was NOT successfully created.
    ERROR: Check the output and correct any reported problems with the docker build operation.


  10. Hi Maria
    I have tried to install windows Oracle DB (Microsoft Windows x64 (64-bit)) its failed because its expecting to copy linux binaries even though i install windows binaries.
    could you able to assist if i m missing something.

    —> 473b7a7a8b1c
    COPY failed: stat /mnt/sda1/var/lib/docker/tmp/docker-builder174664057/linuxamd6 no such file or directory

    ERROR: Oracle Database Docker Image was NOT successfully created.
    ERROR: Check the output and correct any reported problems with the docker build

  11. I did pretty much exactly this on Docker for Mac, only difference is I used docker-compose with following YAML file:

    version: ‘2’
    image: ‘oracle/database:’
    – ‘1521:1521/tcp’
    – ‘5500:5500/tcp’
    – ORACLE_PWD=Welcome1
    – ‘occs:availability=per-pool’
    – ‘occs:scheduler=random’
    – >-
    occs:description=Official Oracle DB Enterprise. View the logs on the button
    – ‘/opt/oracle/oradata:/opt/oracle/oradata’

    It all SEEMS to work, except any data I add to database is lost any time i stop the container and restart. No idea what the solution is.

  12. Quick question on this, is there anyway to access the Enterprise Manager when Oracle is installed in Docker? Thanks in advance

    1. Hi Eddy,

      Oracle EM Express is available with Oracle Database in Docker by default, once you forward port 5500 because it doesn’t need an agent. However, the full-blown Enterprise Manager tool would require you to install and configure the EM agent.


Leave a Reply

Your email address will not be published. Required fields are marked *