sath89/oracle-xe-11g

最新推荐文章于 2021-04-06 20:26:13 发布

weixin_33968104

最新推荐文章于 2021-04-06 20:26:13 发布

阅读量671

点赞数

文章标签：数据库运维 python

原文链接：https://my.oschina.net/u/2245781/blog/1580669

版权

2019独角兽企业重金招聘Python工程师标准>>>

Short Description

Oracle xe 11g with database files mount support and graceful shutdown database files mount support

Full Description

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 ssh