Repository files navigation

Oracle Express Edition 11g Release 2 on Ubuntu 14.04.1 LTS

docker pull quay.io/maksymbilenko/oracle-xe-11g

Run with 8080 and 1521 ports opened:

docker run -d -p 8080:8080 -p 1521:1521 quay.io/maksymbilenko/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 quay.io/maksymbilenko/oracle-xe-11g

Run with customization of processes, sessions, transactionsThis 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.1docker run -d -p 8080:8080 -p 1521:1521 -v /my/oracle/data:/u01/app/oracle\-e processes=1000 \-e sessions=1105 \-e transactions=1215 \quay.io/maksymbilenko/oracle-xe-11g

Run with custom sys password:

docker run -d -p 8080:8080 -p 1521:1521 -e DEFAULT_SYS_PASS=sYs-p@ssw0rd quay.io/maksymbilenko/oracle-xe-11g

Connect database with following setting:

hostname: localhostport: 1521sid: xeusername: systempassword: oracle

Password for SYS & SYSTEM:

oracle

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

http://localhost:8080/apexworkspace: INTERNALuser: ADMINpassword: 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 quay.io/maksymbilenko/docker-oracle-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 quay.io/maksymbilenko/oracle-xe-11g

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

In case of any issues please post ithere.

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