Instalasi DB Oracle XE 11g di Ubuntu dengan Docker

Proses Build Local  Oracle XE 11g

Build sendiri dari hasil clone di Github.

Clone Masuk ke folder hasil clone

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

Build dengan docker build.

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

Proses Pull dari DockerHub  Oracle XE 11g

Langsung pull dari DockerHUb

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

Hasil Build dan Pull

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

Quick Start

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.

Hasil Instalasi

Sumber: https://github.com/wnameless/docker-oracle-xe-11g