9.2

Oracle Database 9.2 Enterprise Edition

Content

Dockerfile including scripts to build an image containing the following:

• CentOS 5.11
• Oracle Database 9.2.0.8.0 Enterprise Edition
  • Sample schemas SCOTT, HR, OE, PM, SH
  • Sample schemas for Queued Shipping (QS, ...) are installed but accounts are "Expired & Locked"

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

Installation

Using Default Settings (recommended)

Complete the following steps to create a new container:

1. Create the container

    docker run --stop-timeout 60 -d -p 1521:1521 -h odb --name odb phsalvisberg/odb:9.2
   

2. wait around 20 minutes until the Oracle database instance is created. 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 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.

Options

Environment Variables

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:

Environment variable	Default value	Comments
GDBNAME	odb.docker	Global database name, used by DBCA
ORACLE_SID	odb	Oracle System Identifier
SERVICE_NAME	odb.docker	Oracle Service Name (for the container database)
PASS	oracle	Password for SYS, SYSTEM

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

docker run -e PASS=manager -e -d -p 1521:1521 -h odb --name odb phsalvisberg/odb:9.2

Volumes

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 --stop-timeout 60 -v odb:/u02 -d -p 1521:1521 -h odb --name odb phsalvisberg/odb:9.2

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

docker run --stop-timeout 60 -v $HOME/docker/odb/u02:/u02 -d -p 1521:1521 -h odb --name odb phsalvisberg/odb:9.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.

Change Timezone

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 odb

Access To Database Services

Database Connections

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

Property	Value
Hostname	localhost
Port	1521
SID	odb
Service	odb.docker

The configured user with their credentials are:

User	Password
system	oracle
sys	oracle
scott	tiger
hr	hr
oe	oe
pm	pm
sh	sh

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

Backup

Complete the following steps to backup the data volume:

1. Stop the container with

    docker stop 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
   

Restore

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 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 --stop-timeout 60 -v odb:/u02 -p 1521:1521 -h odb --name odb phsalvisberg/odb:9.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! ;-)
   

Credits

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