Public | Automated Build

Last pushed: a year ago
Short Description
Image for running Oracle Database 11g Standard/Enterprise.
Full Description

Image for running Oracle Database 11g Standard/Enterprise. Due to oracle license restrictions image is not contain database itself and will install it on first run from external directory.

How-To: build this image

If you want to build this image, you will need to download Oracle from Oracle site.
Download database installation files from Oracle site and unpack them to install_folder.

Tree install folder (after unzip sources) :

└── install folder
    ├── database
    │   ├── doc
    │   ├── install
    │   ├── response
    │   ├── rpm
    │   ├── runInstaller
    │   ├── sshsetup
    │   ├── stage
    │   └── welcome.html
    ├── linux.x64_11gR2_database_1of2.zip
    └── linux.x64_11gR2_database_2of2.zip

Run container and it will install oracle and create database:

docker run --name oracle \
    -p 1521:1521 \
    -v <local_app>:/data/oracle/app \
    -v <local_oraInventory>:/data/oracle/oraInventory \
    -v <local_dpdump>:/data/oracle/dpdump \
    -v <install_folder>:/install \
    webdevops/oracle

Database located in /data/oracle folder

OS users:

  • root/install
  • oracle/install

DB users:

  • SYS/oracle

SID : ORA11G

How-To: customize the installation of the database

You can override the environment variables :

  • ORACLE_HOSTNAME
  • ORACLE_UNQNAME
  • ORACLE_BASE
  • ORACLE_HOME
  • ORACLE_INVENTORY
  • ORACLE_HOME_LISTENER
  • ORACLE_SID
  • PATH
  • LD_LIBRARY_PATH
  • CLASSPATH
  • NLS_LANG
  • NLS_NUMERIC_CHARACTERS
  • NLS_DATE_FORMAT

example :

docker run --name oracle \
    -p 1521:1521 \
    -e "NLS_LANG=American_America.UTF8"
    -e "NLS_DATE_FORMAT=YYYY/MM/DD"
    -v <local_app>:/data/oracle/app \
    -v <local_oraInventory>:/data/oracle/oraInventory \
    -v <local_dpdump>:/data/oracle/dpdump \
    -v <install_folder>:/install \
    webdevops/oracle

You can override the responses files:

docker run --name oracle \
    -p 1521:1521 \
    -v <local_app>:/data/oracle/app \
    -v <local_oraInventory>:/data/oracle/oraInventory \
    -v <local_dpdump>:/data/oracle/dpdump \
    -v <install_folder>:/install \
    -v <local_db_install>:</response_files/oracle_db_install.rsp \
    -v <local_db_ca>:</response_files/dbca.rsp \
    webdevops/oracle

You can add a tnsnames.ora :

docker run --name oracle \
    -p 1521:1521 \
    -v <local_app>:/data/oracle/app \
    -v <local_oraInventory>:/data/oracle/oraInventory \
    -v <local_dpdump>:/data/oracle/dpdump \
    -v <install_tnsname>:/data/oracle/app/product/11.2.0/db_1/network/admin/tnsnames.ora \
    webdevops/oracle

Example of tnsnames.ora :

ORA11G =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST=127.0.0.1)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ORA11G)
    )
  )

Example :

[root@e36a8d861c3f oracle]# su - oracle
Last login: Mon Apr 11 13:45:33 UTC 2016
[oracle@e36a8d861c3f ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Lun. Avr. 11 13:53:41 2016

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


Connect▒ ▒ :
Oracle Database 11g Release 11.2.0.1.0 - 64bit Production

SQL>
Docker Pull Command
Owner
infogene
Source Repository

Comments (1)
ricardolinero
a year ago

This does not work at all, a lot of errors and no feedback or FAQ for it. Too promising until i download it :(

First error following the steps provided

SEVERE:OUI-10182:The effective user ID does not match the owner of the file, or the process is not the super-user; the system indicates that super-user privilege is required.

And it is the first of many more, if you can provide better examples of how this image can be run (even insided a docker-compose file) would be great