🐳 Dockerfile of Oracle Database Express Edition 11g Release 2
Branch: master
Clone or download
Pull request Compare This branch is 47 commits ahead, 58 commits behind wnameless:master.
MaksymBilenko Update entrypoint.sh
Add workaround for sys system passwords
Latest commit d8d8b94 Aug 4, 2017
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
.dockerignore
.gitignore refined: .gitignore Jun 7, 2015
CHANGELOG
Dockerfile
LICENSE
README.md
chkconfig First commit Jan 11, 2014
entrypoint.sh
init.ora Add support for customization Database processes, sessions, transactions Jun 3, 2015
initXETemp.ora Add support for customization Database processes, sessions, transactions Jun 3, 2015
oracle-install.sh
oracle-xe_11.2.0-1.0_amd64.debaa
oracle-xe_11.2.0-1.0_amd64.debab Rebuild from Ubuntu 14.04.1 LTS Jan 6, 2015
oracle-xe_11.2.0-1.0_amd64.debac

README.md

docker-oracle-xe-11g

Oracle Express Edition 11g Release 2 on Ubuntu 14.04.1 LTS

This Dockerfile is a trusted build of Docker Registry.

Installation

docker pull sath89/oracle-xe-11g

Run with 8080 and 1521 ports opened:

docker run -d -p 8080:8080 -p 1521:1521 sath89/oracle-xe-11g

Run with data on host and reuse it:

docker run -d -p 8080:8080 -p 1521:1521 -v /my/oracle/data:/u01/app/oracle sath89/oracle-xe-11g

Run with customization of processes, sessions, transactions This customization is needed on the database initialization stage. If you are using mounted folder with DB files this is not used:

##Consider this formula before customizing:
#processes=x
#sessions=x*1.1+5
#transactions=sessions*1.1
docker run -d -p 8080:8080 -p 1521:1521 -v /my/oracle/data:/u01/app/oracle\
-e processes=1000 \
-e sessions=1105 \
-e transactions=1215 \
sath89/oracle-xe-11g

Run with custom sys password:

docker run -d -p 8080:8080 -p 1521:1521 -e DEFAULT_SYS_PASS=sYs-p@ssw0rd sath89/oracle-xe-11g

Connect database with following setting:

hostname: localhost
port: 1521
sid: xe
username: system
password: oracle

Password for SYS & SYSTEM:

oracle

Connect to Oracle Application Express web management console with following settings:

http://localhost:8080/apex
workspace: INTERNAL
user: ADMIN
password: oracle

Apex upgrade up to v 5.*

docker run -it --rm --volumes-from ${DB_CONTAINER_NAME} --link ${DB_CONTAINER_NAME}:oracle-database -e PASS=YourSYSPASS sath89/apex install

Details could be found here: https://github.com/MaksymBilenko/docker-oracle-apex

Auto import of sh sql and dmp files

docker run -d -p 8080:8080 -p 1521:1521 -v /my/oracle/data:/u01/app/oracle -v /my/oracle/init/sh_sql_dmp_files:/docker-entrypoint-initdb.d sath89/oracle-xe-11g

In case of using DMP imports dump file should be named like ${IMPORT_SCHEME_NAME}.dmp User credentials for imports are ${IMPORT_SCHEME_NAME}/${IMPORT_SCHEME_NAME}

In case of any issues please post it here.

CHANGELOG

  • Added auto-import using volume /docker-entrypoint-initdb.d for *.sh *.sql *.dmp
  • Fixed issue with reusable mounted data
  • Fixed issue with ownership of mounted data folders
  • Fixed issue with Gracefull shutdown of service
  • Reduse size of image from 3.8G to 825Mb
  • Database initialization moved out of the image build phase. Now database initializes at the containeer startup with no database files mounted
  • Added database media reuse support outside of container
  • Added graceful shutdown on containeer stop
  • Removed sshd