Docker Run Oracle DB 18c XE: Difference between revisions
Jump to navigation
Jump to search
| Line 78: | Line 78: | ||
docker exec -it --user=oracle oracle18c bash | docker exec -it --user=oracle oracle18c bash | ||
sqlplus sys@XEPDB1 as sysdba | sqlplus sys@XEPDB1 as sysdba | ||
sho con_name | |||
docker exec -it --user=oracle oracle18c bash | |||
sqlplus sys@XE as sysdba | |||
sho con_name | sho con_name | ||
Revision as of 20:37, 15 July 2020
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
docker exec -it --user=oracle oracle18c bash sqlplus sys@XEPDB1 as sysdba sho con_name
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