Docker Run Oracle DB 18c XE

From Chorke Wiki
Jump to navigation Jump to search
Linux:
export ORACLE_HOME=/srv/oracle
MacOS:
export ORACLE_HOME=$HOME/oracle

Build

cd $ACADEMIA_WSS/unix/dokr_wss/
mkdir academia-dokr-ora18c
cd academia-dokr-ora18c/

git clone https://github.com/oracle/docker-images.git .
cd OracleDatabase/SingleInstance/dockerfiles/
./buildDockerImage.sh -v 18.4.0 -x

Run

docker run --detach \
--name oracle18c \
--publish 1521:1521 \
--publish 5500:5500 \
--env ORACLE_PWD=oracle \
--env ORACLE_CHARACTERSET=AL32UTF8 \
oracle/database:18.4.0-xe

With Volumes

Local location Container location Usage
$ORACLE_HOME/oracle18c/oradata /opt/oracle/oradata Oracle 18c XE Data
$ORACLE_HOME/oracle18c/scripts/setup /opt/oracle/scripts/setup Setup Scripts
$ORACLE_HOME/oracle18c/scripts/startup /opt/oracle/scripts/startup Startup Scripts
docker run --detach \
--name oracle18c \
--publish 1521:1521 \
--publish 5500:5500 \
--env ORACLE_PWD=oracle \
--env ORACLE_CHARACTERSET=AL32UTF8 \
--volume $ORACLE_HOME/oracle18c/oradata:/opt/oracle/oradata \
--volume $ORACLE_HOME/oracle18c/scripts/setup:/opt/oracle/scripts/setup \
--volume $ORACLE_HOME/oracle18c/scripts/startup:/opt/oracle/scripts/startup \
oracle/database:18.4.0-xe

With Volumes And Network

docker network ls
docker network create oracle_network
docker run --detach \
--name oracle18c \
--publish 1521:1521 \
--publish 5500:5500 \
--env ORACLE_PWD=oracle \
--env ORACLE_CHARACTERSET=AL32UTF8 \
--volume $ORACLE_HOME/oracle18c/oradata:/opt/oracle/oradata \
--volume $ORACLE_HOME/oracle18c/scripts/setup:/opt/oracle/scripts/setup \
--volume $ORACLE_HOME/oracle18c/scripts/startup:/opt/oracle/scripts/startup \
--network oracle_network \
oracle/database:18.4.0-xe

Docker Client

XEPDB1
docker exec -it --user=oracle oracle18c bash
sqlplus sys@XEPDB1 as sysdba
sho con_name
CDB$ROOT
docker exec -it --user=oracle oracle18c bash
sqlplus sys@XE as sysdba
sho con_name

Remote Client

sqlplus sys/oracle@//10.19.83.10:1521/XE
sqlplus sys/oracle@//10.19.83.10:1521/XEPDB1

Good To Know

docker logs oracle18c
docker stop oracle18c
docker start oracle18c
docker restart oracle18c
docker exec -it oracle18c /bin/bash
docker exec -it --user=oracle oracle18c bash
docker network ls
docker network create oracle_network
docker-machine create --driver virtualbox default
docker-machine start default
docker-machine stop default
docker-machine ip default
docker-machine ls

References