Instant Oracle datase server

A Docker image with Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 running in Oracle Linux 6

Install

Install Docker
The image will get removed from dockerhub by the Docker support and hence will have to build by ourself.

Build

This section will guide you step by step to build oracle-12c docker image. The build will have following features by default:

Oracle database server with spatial features. (If you want additional features, edit the file create file inside step2 folder and add required feature)
New user will be created with name simon and password root ( If you want to create custom user, edit the file startdb.sql and write the sql statements to add new user)
For static registation of database intance with listener you can edit start file inside step3folder

#!/bin/bash

mount -t tmpfs shmfs -o size=4g /dev/shm

echo "SID_LIST_LISTENER =
  (SID_LIST =
     (SID_DESC =
      (GLOBAL_DBNAME = ORCL)
      (ORACLE_HOME = /u01/app/oracle/product/12.1.0/dbhome_1)
      (SID_NAME = ORCL)
    )
  )
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = $HOSTNAME)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )" >> $ORACLE_HOME/network/admin/listener.ora

while true; do
  status=`ps -ef | grep tns | grep oracle`
  pmon=`ps -ef | egrep pmon_$ORACLE_SID'\>' | grep -v grep`
  if [ "$status" == "" ] || [ "$pmon" == "" ]
  then
    su -s /bin/bash oracle -c "lsnrctl start"
    su -s /bin/bash oracle -c "sqlplus /nolog @?/config/scripts/startdb.sql"
    su -s /bin/bash oracle -c "lsnrctl status"
  fi
  sleep 1m
done;

4.Default database will be ORCLat port 1521.

Issues and solutions:

If the space allocated for boot2docker is used fully, then you may get error like 'no space left on device' and subsequent steps may fail.

Solution: You can go step by step procedure mentioned in Boot2Docker Volume resize and increase the volume size and retry building the image again.

Step 1

Download linuxamd64_12102_database_1of2.zip & linuxamd64_12102_database_2of2.zip from Oracle Tech Net
Put the 2 zip files in the step1 directory
cd to the oracle-12c repo directory
$ docker build -t oracle-12c:step1 step1
$ docker run --privileged -ti --name step1 oracle-12c:step1 /bin/bash
# /tmp/install/install (takes about 5m)

Tue Sep 16 08:48:00 UTC 2014
Starting Oracle Universal Installer...

Checking Temp space: must be greater than 500 MB.   Actual 40142 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 1392 MB    Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2014-09-16_08-48-01AM. Please wait ...[root@51905aa48207 /]# You can find the log of this install session at:
 /u01/app/oraInventory/logs/installActions2014-09-16_08-48-01AM.log
The installation of Oracle Database 12c was successful.
Please check '/u01/app/oraInventory/logs/silentInstall2014-09-16_08-48-01AM.log' for more details.

As a root user, execute the following script(s):
	1. /u01/app/oracle/product/12.1.0/dbhome_1/root.sh



Successfully Setup Software.
As install user, execute the following script to complete the configuration.
	1. /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/configToolAllCommands RESPONSE_FILE=<response_file>

 	Note:
	1. This script must be run on the same host from where installer was run. 
	2. This script needs a small password properties file for configuration assistants that require passwords (refer to install guide documentation).

<enter>
# exit (the scripts mentioned are executed as part of the step2 build)
$ docker commit step1 oracle-12c:installed

Step 2

$ docker build -t oracle-12c:step2 step2
$ docker run --privileged -ti --name step2 oracle-12c:step2 /bin/bash
# /tmp/create (takes about 15m)

Tue Sep 16 11:07:30 UTC 2014
Creating database...

SQL*Plus: Release 12.1.0.2.0 Production on Tue Sep 16 11:07:30 2014

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Connected to an idle instance.

File created.

ORACLE instance started.

Total System Global Area 1073741824 bytes
Fixed Size		    2932632 bytes
Variable Size		  721420392 bytes
Database Buffers	  343932928 bytes
Redo Buffers		    5455872 bytes

Database created.


Tablespace created.


Tablespace created.

Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

Tue Sep 16 11:07:50 UTC 2014
Running catalog.sql...

Tue Sep 16 11:08:51 UTC 2014
Running catproc.sql...

Tue Sep 16 11:19:38 UTC 2014
Running pupbld.sql...

Tue Sep 16 11:19:38 UTC 2014
Create is done; commit the container now

# exit
$ docker commit step2 oracle-12c:created

Step 3

$ docker build -t sameer/oracle-12c step3

Run

Create and run a container named orcl:

$ docker run --privileged -dP --name orcl oracle-12c
989f1b41b1f00c53576ab85e773b60f2458a75c108c12d4ac3d70be4e801b563

Yes, alas, this has to run privileged in order to gain permission for the mount statement in /tmp/start that ups the amount of shared memory, which has a hard value of 64M in Docker; see this GitHub issue If we do not run it privileged then there will be mounting issue and you will not be able to connect to the oracle instance and errors will be thrown.

After running the container, view the container logs with command docker orcl logs and check if there are no error while starting the database.

Connect

The default password for the sys user is change_on_install, and for system it's manager A new user 'simon' is created with password 'root' based on the startdb.sql file with The ORCL database port 1521 is bound to the Docker host through run -P. To find the host's port:

$ docker port orcl 1521
0.0.0.0:49189

So from the host, you can connect with system/manager@localhost:49189/orcl Though if using Boot2Docker, you need the actual ip address instead of localhost:

$ boot2docker ip

The VM's Host only interface IP address is: 192.168.59.103

If you're looking for a databse client, consider sqlplus

$ sqlplus system/manager@192.168.59.103:49189/orcl

SQL*Plus: Release 11.2.0.4.0 Production on Mon Sep 15 14:40:52 2014

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> |

Editing the container

In docker, image is a read only layer and never changes. But at some point you want to have some changes inside image,

Run a container of this image.
docker run -privileged -dP --name containerinstance sameer/oracle-12c
Execute the command docker exec -it orcl /bin/bash
Make changes inside the container.
exit
Save the conatainer to the new image docker commit containerinstance sameer/oracle-12c-new
You can use this image with new changes.

Monitor

The container runs a process that starts up the database, and then continues to check each minute if the database is still running, and start it if it's not. To see the output of that process:

$ docker logs orcl

LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 16-SEP-2014 11:34:56

Copyright (c) 1991, 2014, Oracle.  All rights reserved.

Starting /u01/app/oracle/product/12.1.0/dbhome_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 12.1.0.2.0 - Production
Log messages written to /u01/app/oracle/diag/tnslsnr/e90ad7cc75a1/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=e90ad7cc75a1)(PORT=1521)))

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 12.1.0.2.0 - Production
Start Date                16-SEP-2014 11:34:56
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Log File         /u01/app/oracle/diag/tnslsnr/e90ad7cc75a1/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=e90ad7cc75a1)(PORT=1521)))
The listener supports no services
The command completed successfully

SQL*Plus: Release 12.1.0.2.0 Production on Tue Sep 16 11:34:56 2014

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Connected to an idle instance.
ORACLE instance started.

Total System Global Area 1073741824 bytes
Fixed Size		    2932632 bytes
Variable Size		  721420392 bytes
Database Buffers	  343932928 bytes
Redo Buffers		    5455872 bytes
Database mounted.
Database opened.
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 16-SEP-2014 11:35:24

Copyright (c) 1991, 2014, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 12.1.0.2.0 - Production
Start Date                16-SEP-2014 11:34:56
Uptime                    0 days 0 hr. 0 min. 28 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Log File         /u01/app/oracle/diag/tnslsnr/e90ad7cc75a1/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=e90ad7cc75a1)(PORT=1521)))
Services Summary...
Service "ORCL" has 1 instance(s).
  Instance "ORCL", status READY, has 1 handler(s) for this service...
The command completed successfully

Enter

There's no ssh daemon or similar configured in the image. If you need a command prompt inside the container, consider nsenter (and mind the Boot2Docker note there)

Reference

wscherphof/oracle-12c

License

GNU Lesser General Public License (LGPL) for the contents of this GitHub repo; for Oracle's database software, see their Licensing Information

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

README.md

README.md

Instant Oracle datase server

Install

Build

Issues and solutions:

Step 1

Step 2

Step 3

Run

Connect

Editing the container

Monitor

Enter

Reference

License

Files

README.md

Latest commit

History

README.md

File metadata and controls

Instant Oracle datase server

Install

Build

Issues and solutions:

Step 1

Step 2

Step 3

Run

Connect

Editing the container

Monitor

Enter

Reference

License