larmic/oracle-xe repository overview

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

username: integrationtest
password: app

ALTER TABLESPACE temp ADD TEMPFILE '/opt/oracle/product/18c/dbhomeXE/dbs/temp01.dbf' SIZE  64M;

grant create session to integrationtest;
GRANT RESOURCE to integrationtest;
GRANT CREATE VIEW TO integrationtest;
alter user integrationtest quota unlimited on system;

# load image
$ docker pull larmic/oracle-xe:18.4.0 

# start local docker image
$ docker run --name larmic-oracle-xe -d -it -p 1521:1521 larmic/oracle-xe:18.4.0

# connect to jdbc:oracle:thin:@localhost:1521:XE and do your update stuff

# stop running container
$ docker stop larmic-oracle-xe

# commit container to image
$ docker commit <container-id> larmic/oracle-xe:18.4.0.Fix1

# remove old container 
docker rm larmic-oracle-xe

# squash image to reduce space (I'm using https://github.com/goldmann/docker-squash installed by homebrew)
$ docker-squash -t larmic/oracle-xe:18.4.0.squashed larmic/oracle-xe:18.4.0.Fix1

# clean up
$ docker rmi larmic/oracle-xe:18.4.0
$ docker rmi larmic/oracle-xe:18.4.0.Fix1
$ docker tag larmic/oracle-xe:18.4.0.squashed larmic/oracle-xe:18.4.0
$ docker rmi larmic/oracle-xe:18.4.0.squashed