holywen/oracle_xe_ecdb repository overview

Cloned from alexeiled/docker-oracle-xe-11g/

Created a new empty 500M database named ecdb with password ecdb, sid is xe Updated the open_cursors:

alter system set open_cursors = 4000 scope=both;

To pull:

docker pull holywen/oracle_xe_ecdb

To run:

docker run -d --shm-size=2g -p 1521:1521 -p 8080:8080  holywen/oracle_xe_ecdb

DB name: xe DB user: ecdb DB pass: ecdb

update the Database Configuration to connect to it:

ectool  setDatabaseConfiguration --databaseType  oracle  --hostName localhost --databaseName xe  --userName ecdb --password ecdb --port 1521

docker-oracle-xe-11g Oracle XE - Dockerfile

⁠Note: It's important to run Oracle XE with >1GB shared memory.

Start Oracle XE

Running Oracle XE in detached mode with 1521 and 8080 ports opened and 2GB shared memory:

docker run -d --shm-size=2g -p 1521:1521 -p 8080:8080 holywen/oracle_xe_ecdb

Start Oracle XE and execute SQL on startup

Put your *.sql files for database init into some local folder and mount this folder during container startup to /etc/entrypoint-initdb.d volume.

docker run -d --shm-size=1g -p 8080:8080 -p 1521:1521 -v /local-initdb:/etc/entrypoint-initdb.d alexeiled/docker-oracle-xe-11g

Connect

Connect database with following setting:

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

Password for SYS user oracle

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

url: http://localhost:8080/apex
workspace: internal
user: admin
password: oracle

Do not forget to change admin password!