banglamon/oracle193db repository overview

docker login -u username
Password: xxxxx
Login Succeeded
docker pull banglamon/oracle193db:19.3.0-ee
docker image ls|grep oracle

sudo su - oracle 
docker run -d --name oracle19db \
-p 1521:1521 \
-e ORACLE_SID=MONGO \
-e ORACLE_PDB=MONGOPDB \
-e ORACLE_PWD=Oracle123 \
-v /u01/app/oracle/oradata:/opt/oracle/oradata \
banglamon/oracle193db:19.3.0-ee

where,

-d To start a container in detached mode, you use -d=true or just -d option
-p Mapped port 1521  on my laptop to the corresponding ports inside the container
-e env list Set environment variables 
-v Mapped my local directory (/u01/app/oracle/oradata ) to the default location where the data files will be stored (:/opt/oracle/oradata) to ensure the files are persisted outside my container.

i. find the oracle docker process
docker ps -a | grep oracle

ii. docker logs -f <PID>

docker exec -it oracle19db bash -c "source /home/oracle/.bashrc; sqlplus /nolog”

SQL> conn / as sysdba
Connected.

SQL> select name from v$database;
NAME
— — — —
MORAL

SQL> show con_name
CON_NAME
— — — — — — — — — — — — — — —
CDB$ROOT

SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
— — — — — — — — — — — — — — — — — — — — — — — — — — — — — —
2 PDB$SEED READ ONLY NO
3 MORALPDB READ WRITE NO

SQL> alter session set container=MORALPDB;
Session altered.

SQL> create table DockerTst (id int,name varchar2(20));
Table created.

SQL> select tablespace_name from dba_tablespaces;
TABLESPACE_NAME
— — — — — — — — — — — — — — —
SYSTEM
SYSAUX
UNDOTBS1
TEMP
USERS

SQL> select name from v$datafile;
NAME
— — — — — — — — — — — — — — — — — — — — — — — — — — -
/u01/app/oracle/oradata/MORAL/system01.dbf
/u01/app/oracle/oradata/MORAL/sysaux01.dbf
/u01/app/oracle/oradata/MORAL/undotbs01.dbf
/u01/app/oracle/oradata/MORAL/pdbseed/system01.dbf
/u01/app/oracle/oradata/MORAL/pdbseed/sysaux01.dbf
/u01/app/oracle/oradata/MORAL/users01.dbf
/u01/app/oracle/oradata/MORAL/pdbseed/undotbs01.dbf
/u01/app/oracle/oradata/MORAL/MORALPDB/system01.dbf
/u01/app/oracle/oradata/MORAL/MORALPDB/sysaux01.dbf
/u01/app/oracle/oradata/MORAL/MORALPDB/undotbs01.dbf
/u01/app/oracle/oradata/MORAL/MORALPDB/users01.dbf
11 rows selected.

SQL> create tablespace testdocker datafile ‘/u01/app/oracle/oradata/MORAL/testdocker01.dbf’ size 100M;
Tablespace created.

Create a sample table
========================
connect sys as sysdba;

-- Here enter the password as 'Oradoc_db1'

alter session set "_ORACLE_SCRIPT"=true;
create user dummy identified by dummy;
GRANT CONNECT, RESOURCE, DBA TO dummy;

--Now create a sample table.

create table DockerTst (id int,name varchar2(20));

--Start inserting values in to the table.

SQL> conn / as sysdba
Connected.

SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT

SQL> show pdbs
    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 BONGOPDB                       READ WRITE NO

SQL> alter session set container=BONGOPDB;
Session altered.

SQL> create user dummy identified by dummy;
User created.

SQL> GRANT CONNECT, RESOURCE, DBA TO dummy;
Grant succeeded.

SQL> create table Docker (id int,name varchar2(20));
Table created.

[oracle@opsdev ~]$ docker ps -a

CONTAINER ID        IMAGE                             COMMAND                  CREATED             STATUS                       PORTS               NAMES
202f391b8388        banglamon/oracle193db:19.3.0-ee   "/bin/sh -c 'exec $O…"   About an hour ago   Exited (137) 8 minutes ago                       oracle19db

docker stop 202f391b8388

[oracle@opsdev ~]$ docker rm 202f391b8388

202f391b8388

$ docker images
REPOSITORY              TAG                 IMAGE ID            CREATED             SIZE
banglamon/oracle193db   19.3.0-ee           c796ed598500        3 months ago        6.5GB

$ docker rmi c796ed598500

Untagged: banglamon/oracle193db:19.3.0-ee
Untagged: banglamon/oracle193db@sha256:2afff2ab1a5ecd7f40767a39398b3e7598bab92ff68793d81699c6ea0008f04f
Deleted: sha256:c796ed5985008036d12719c93eb233f3a2d764a962d9bfcfa656609e71f37fec
Deleted: sha256:e1e8029532ad917476a3a38831121bac71d1d205e92cbbe44d2581b16483e257
Deleted: sha256:8e862861784ece5ed7af5e89a99154e7d4a5e0830cd66175db69cb916b027f02
Deleted: sha256:5bf5d87e7c3a50d8321f9585bdb9e0310c50c5829fc1584797a54679117e8845
Deleted: sha256:f0117c129f6a96c9893170a797437c01a7e5d693236b382b23f83626d3b0c3ef
Deleted: sha256:10e2a1b7e3c6f5f0ff5219331f0dfbcd990960afff6025c77f0222d77cf67aa3
Deleted: sha256:b87942114db6b2cf0bf150f9f85f220fffa5287d57e3bc1677f7f09915c10cf1