Dockerfile including scripts to build an image containing the following:

• Oracle Linux 7.6
• Oracle Database 12.2.0.1.190716 Enterprise Edition
  • Sample schemas SCOTT, HR, OE, PM, IX, SH, BI (master branch as of build time)
  • APEX 19.1.0 including APEX_LISTENER and APEX_REST_PUBLIC_USER
  • Oracle REST Data Services 19.1.0
  • FTLDB 1.5.0
  • tePLSQL (master branch as of build time)
  • oddgen example/tutorial schemas ODDGEN, OGDEMO (main branch as of build time)

This image supports CDB and non-CDB architecture. The latter is the default. Please note that the non-CDB architecture is deprecated with Oracle 12.2.0.1. See Oracle Database Upgrade Guide for more information.

Due to OTN Developer License Terms I cannot make this image available on a public Docker registry.

Complete the following steps to create a new container:

1. Create the container

    docker run -d -p 8080-8081:8080-8081 -p 1521:1521 -h odb --name odb phsalvisberg/odb:12.2
   

2. wait around 20 minutes until the Oracle database instance is created and APEX is updated to the latest version. Check logs with docker logs -f -t odb. The container is ready to use when the last line in the log is Database ready to use. Enjoy! ;-). The container stops if an error occurs. Check the logs to determine how to proceed.

Feel free to stop the docker container after a successful installation with docker stop -t 60 odb. The container should shutdown the database gracefully within the given 60 seconds and persist the data fully (ready for backup). Next time you start the container using docker start odb the database will start up.

You may set the environment variables in the docker run statement to configure the container setup process. The following table lists all environment variables with its default values:

Here's an example run call amending the PASS environment variable skip APEX installation:

docker run -e PASS=manager -e APEX=false -d -p 8080-8081:8080-8081 -p 1521:1521 -h odb --name odb phsalvisberg/odb:12.2

Here's an other example createing a container database and extending the database port ranges to cover a total of three pluggable databases:

docker run -e MULTITENANT=true -d -p 8080-8081:8080-8081 -p 1521-1523:1521-1523 -h ocdb --name ocdb phsalvisberg/oddgendemo

The image defines a volume for /u02. You may map this volume to a storage solution of your choice. Here's an example using a named volume odb:

docker run -v odb:/u02 -d -p 8080-8081:8080-8081 -p 1521:1521 -h odb --name odb phsalvisberg/odb:12.2

Here's an example mapping the local directory $HOME/docker/odb/u02 to /u02.

docker run -v $HOME/docker/odb/u02:/u02 -d -p 8080-8081:8080-8081 -p 1521:1521 -h odb --name odb phsalvisberg/odb:12.2

Please note: Volumes mapped to local directories are not stable, at least not in Docker for Mac 1.12.0. E.g. creating a database may never finish. So I recommend not to use local mapped directories for the time being. Alternatively you may use a volume plugin. A comprehensive list of volume plugins is listed here.

The default timezone of the container is "Central European Time (CET)". To query the available timezones run:

docker exec odb ls -RC /usr/share/zoneinfo

To change the timezone to "Eastern Time" run the following two commands:

docker exec odb unlink /etc/localtime
docker exec odb ln -s /usr/share/zoneinfo/America/New_York /etc/localtime

Restart your container to ensure the new setting take effect.

docker restart -t 60 odb

http://localhost:8080/em/

• when using ORDS: http://localhost:8081/ords/
• when using EPG: http://localhost:8080/apex/

To access the database e.g. from SQL Developer you configure the following properties:

The configured user with their credentials are:

Use the following connect string to connect as scott via SQL*Plus or SQLcl: scott/tiger@localhost/odb.docker

Complete the following steps to backup the data volume:

1. Stop the container with

    docker stop -t 30 odb
   

2. Backup the data volume to a compressed file odb.tar.gz in the current directory with a little help from the ubuntu image

    docker run --rm --volumes-from odb -v $(pwd):/backup ubuntu tar czvf /backup/odb.tar.gz /u02
   

3. Restart the container

    docker start odb
   

Complete the following steps to restore an image from scratch. There are other ways, but this procedure is also applicable to restore a database on another machine:

1. Stop the container with

    docker stop -t 30 odb
   

2. Remove the container with its associated volume

    docker rm -v odb
   

3. Remove unreferenced volumes, e.g. explicitly created volumes by previous restores

    docker volume ls -qf dangling=true | xargs docker volume rm
   

4. Create an empty data volume named odb

    docker volume create --name odb
   

5. Populate data volume odb with backup from file odb.tar.gz with a little help from the ubuntu image

    docker run --rm -v odb:/u02 -v $(pwd):/backup ubuntu tar xvpfz /backup/odb.tar.gz -C /
   

6. Create the container using the odbvolume

    docker run -v odb:/u02 -d -p 8080-8081:8080-8081 -p 1521:1521 -h odb --name odb phsalvisberg/odb:12.2
   

7. Check log of odb container

    docker logs odb
   

   The end of the log should look as follows:

    Reuse existing database.
   
    (...)
   
    Database ready to use. Enjoy! ;-)
   

This Dockerfile is based on the following work:

• Maksym Bilenko's GitHub project sath89/docker-oracle-12c
• Frits Hoogland's blog post Installing the Oracle database in docker