Instalasi DB Oracle XE 11g di Ubuntu dengan Docker

Proses Build Local Oracle XE 11g

Build sendiri dari hasil clone di Github.

git clone https://github.com/wnameless/docker-oracle-xe-11g.git
cd docker-oracle-xe-11g

docker build -t wnameless/oracle-xe-11g .

docker pull wnameless/oracle-xe-11g-r2

Yang atas adalah hasil build kita sedangkan yang berada dibagian bawah adalah hasil pull. Untuk digunakan terserah pakai yang mana sama saja.

Run with 1521 port opened:

docker run -d -p 49161:1521 wnameless/oracle-xe-11g-r2

Run this, if you want the database to be connected remotely:

docker run -d -p 49161:1521 -e ORACLE_ALLOW_REMOTE=true wnameless/oracle-xe-11g-r2

For performance concern, you may want to disable the disk asynch IO:

docker run -d -p 49161:1521 -e ORACLE_DISABLE_ASYNCH_IO=true wnameless/oracle-xe-11g-r2

Enable XDB user with default password: xdb, run this:

docker run -d -p 49161:1521 -e ORACLE_ENABLE_XDB=true wnameless/oracle-xe-11g-r2

For APEX user:

docker run -d -p 49161:1521 -p 8080:8080 wnameless/oracle-xe-11g-r2

# Login http://localhost:8080/apex/apex_admin with following credential:
username: ADMIN
password: admin

For latest APEX(18.1) user, please pull wnameless/oracle-xe-11g-r2:18.04-apex first:

docker run -d -p 49161:1521 -p 8080:8080 wnameless/oracle-xe-11g:18.04-apex

# Login http://localhost:8080/apex/apex_admin with following credential:
username: ADMIN
password: Oracle_11g

By default, the password verification is disable(password never expired)
Connect database with following setting:

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

Password for SYS & SYSTEM

oracle

Support custom DB Initialization and running shell scripts

# Dockerfile
FROM wnameless/oracle-xe-11g-r2

ADD init.sql /docker-entrypoint-initdb.d/
ADD script.sh /docker-entrypoint-initdb.d/

Running order is alphabetically.