IT Solutions Technology Blog

   https://github.com/oracle/docker-images/blob/main/OracleDatabase/SingleInstance/README.md

The requirements are you must have 2 CPUs / 6 GByte of the memory / 15 GByte of free storage

┌──(root💀vm-iot-jsho-docker-02)-[~]
└─# git clone https://github.com/oracle/docker-images.git
Klone nach ‚docker-images‘ …
remote: Enumerating objects: 18, done.
remote: Counting objects: 100% (18/18), done.
remote: Compressing objects: 100% (17/17), done.
remote: Total 13652 (delta 1), reused 4 (delta 0), pack-reused 13634
Empfange Objekte: 100% (13652/13652), 9.83 MiB | 5.03 MiB/s, fertig.
Löse Unterschiede auf: 100% (7995/7995), fertig.

┌──(root💀vm-iot-jsho-docker-01)-[~]
└─# cd docker-images/OracleDatabase/SingleInstance/dockerfiles/19.3.0

┌──(root💀vm-iot-jsho-docker-02)-[~/…/OracleDatabase/SingleInstance/dockerfiles/19.3.0]
└─#

┌──(root💀vm-iot-jsho-docker-02)-[~/…/OracleDatabase/SingleInstance/dockerfiles/19.3.0]
└─# mv /tmp/LINUX.X64_193000_db_home.zip .

┌──(root💀vm-iot-jsho-docker-02)-[~/…/OracleDatabase/SingleInstance/dockerfiles/19.3.0]
└─# cd ..

┌──(root💀vm-iot-jsho-docker-02)-[~/docker-images/OracleDatabase/SingleInstance/dockerfiles]
└─# ./buildContainerImage.sh -h

Usage: buildContainerImage.sh -v [version] [-e | -s | -x] [-i] [-o] [container build option]
Builds a container image for Oracle Database.

Parameters:
-v: version to build
Choose one of: 11.2.0.2 12.1.0.2 12.2.0.1 18.3.0 18.4.0 19.3.0
-e: creates image based on ‚Enterprise Edition‘
-s: creates image based on ‚Standard Edition 2‘
-x: creates image based on ‚Express Edition‘
-i: ignores the MD5 checksums
-o: passes on container build option

* select one edition only: -e, -s, or -x

LICENSE UPL 1.0

Copyright (c) 2014,2021 Oracle and/or its affiliates.

┌──(root💀vm-iot-jsho-docker-02)-[~/docker-images/OracleDatabase/SingleInstance/dockerfiles]
└─# ./buildContainerImage.sh -v 19.3.0 -e

Oracle Database container image for ‚ee‘ version 19.3.0 is ready to be extended:

–> oracle/database:19.3.0-ee

Build completed in 653 seconds.

┌──(root💀vm-iot-jsho-docker-02)-[~/docker-images/OracleDatabase/SingleInstance/dockerfiles]
└─#

┌──(root💀vm-iot-jsho-docker-02)-[~]
└─# docker images
REPOSITORY TAG IMAGE ID CREATED SIZE
oracle/database 19.3.0-ee 28f2ce0e86dc 15 minutes ago 6.67GB

┌──(root💀vm-iot-jsho-docker-02)-[~]
└─#

# docker run –name <container name> \
-p <host port>:1521 -p <host port>:5500 \
-e ORACLE_SID=<your SID> \
-e ORACLE_PDB=<your PDB name> \
-e ORACLE_PWD=<your database passwords> \
-e INIT_SGA_SIZE=<your database SGA memory in MB> \
-e INIT_PGA_SIZE=<your database PGA memory in MB> \
-e ORACLE_EDITION=<your database edition> \
-e ORACLE_CHARACTERSET=<your character set> \
-v [<host mount point>:]/opt/oracle/oradata \
oracle/database:19.3.0-ee

┌──(root💀vm-iot-jsho-docker-02)-[~]
└─# docker run -d -it –name oracle19ee –hostname oracle19ee -p 1521:1521 -p 5500:5500 -e ORACLE_PWD=<password> oracle/database:19.3.0-ee

┌──(root💀vm-iot-jsho-docker-02)-[~]
└─# docker logs -f oracle19ee

ORACLE EDITION: ENTERPRISE
ORACLE PASSWORD FOR SYS, SYSTEM AND PDBADMIN:<password>

LSNRCTL for Linux: Version 19.0.0.0.0 – Production on 12-FEB-2021 08:33:21

Copyright (c) 1991, 2019, Oracle. All rights reserved.

Starting /opt/oracle/product/19c/dbhome_1/bin/tnslsnr: please wait…

TNSLSNR for Linux: Version 19.0.0.0.0 – Production
System parameter file is /opt/oracle/product/19c/dbhome_1/network/admin/listener.ora
Log messages written to /opt/oracle/diag/tnslsnr/oracle19ee/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
————————
Alias LISTENER
Version TNSLSNR for Linux: Version 19.0.0.0.0 – Production
Start Date 12-FEB-2021 08:33:21
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /opt/oracle/product/19c/dbhome_1/network/admin/listener.ora
Listener Log File /opt/oracle/diag/tnslsnr/oracle19ee/listener/alert/log.xml
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521)))
The listener supports no services
The command completed successfully
.
Prepare for db operation
8% complete
Copying database files
31% complete
Creating and starting Oracle instance
32% complete
36% complete
40% complete
43% complete
46% complete
Completing Database Creation
51% complete
54% complete
Creating Pluggable Databases
58% complete
77% complete
Executing Post Configuration Actions
100% complete
Database creation complete. For details check the logfiles at:
/opt/oracle/cfgtoollogs/dbca/ORCLCDB.
Database Information:
Global Database Name:ORCLCDB
System Identifier(SID):ORCLCDB
Look at the log file „/opt/oracle/cfgtoollogs/dbca/ORCLCDB/ORCLCDB.log“ for further details.

SQL*Plus: Release 19.0.0.0.0 – Production on Fri Feb 12 08:50:20 2021
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle. All rights reserved.

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.3.0.0.0

SQL>
System altered.

SQL>
System altered.

SQL>
Pluggable database altered.

SQL>
PL/SQL procedure successfully completed.

SQL> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.3.0.0.0
The Oracle base remains unchanged with value /opt/oracle
#########################
DATABASE IS READY TO USE!
#########################
The following output is now a tail of the alert.log:
ORCLPDB1(3):ALTER DATABASE DEFAULT TABLESPACE „USERS“
ORCLPDB1(3):Completed: ALTER DATABASE DEFAULT TABLESPACE „USERS“
2021-02-12T08:50:20.389852+00:00
ALTER SYSTEM SET control_files=’/opt/oracle/oradata/ORCLCDB/control01.ctl‘ SCOPE=SPFILE;
2021-02-12T08:50:20.395466+00:00
ALTER SYSTEM SET local_listener=“ SCOPE=BOTH;
ALTER PLUGGABLE DATABASE ORCLPDB1 SAVE STATE
Completed: ALTER PLUGGABLE DATABASE ORCLPDB1 SAVE STATE

XDB initialized.

┌──(root💀vm-iot-jsho-docker-02)-[~]
└─# docker exec -it oracle19ee /bin/bash
[oracle@oracle19ee ~]$

Oracle Enterprise Manager Database Express

https://127.0.0.1:5500/em/login​
system <password> orclpdb1

┌──(root💀vm-iot-jsho-docker-02)-[~]
└─# docker ps
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
ecb493fec6e5 oracle/database:19.3.0-ee „/bin/sh -c ‚exec $O…“ 28 hours ago Up 18 hours (healthy) 0.0.0.0:1521->1521/tcp, 0.0.0.0:5500->5500/tcp oracle19ee

┌──(root💀vm-iot-jsho-docker-02)-[~]
└─# docker stop -t 30 oracle19ee
oracle19ee

┌──(root💀vm-iot-jsho-docker-02)-[~]
└─#

┌──(root💀vm-iot-jsho-docker-02)-[~]
└─# docker start oracle19ee
oracle19ee

┌──(root💀vm-iot-jsho-docker-02)-[~]
└─#

┌──(root💀vm-iot-jsho-docker-02)-[~]
└─# docker exec -it oracle19ee /bin/bash
[oracle@oracle19ee ~]$

[oracle@oracle19ee ~]$ sqlplus pdbadmin@orclpdb1

SQL*Plus: Release 19.0.0.0.0 – Production on Sat Feb 13 17:04:15 2021
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle. All rights reserved.

Enter password: <password>

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.3.0.0.0

SQL>

┌──(root💀vm-iot-jsho-docker-02)-[~]
└─# docker commit -p oracle19ee oracle19ee.backup.20210213
sha256:ec89f8aa5c9b69a63f96aa43c433f2d34a82eebd2b699379077f49ff05179290

┌──(root💀vm-iot-jsho-docker-02)-[~]
└─# docker images
REPOSITORY TAG IMAGE ID CREATED SIZE
oracle19ee.backup.20210213 latest ec89f8aa5c9b 14 minutes ago 11.5GB
oracle/database 19.3.0-ee 28f2ce0e86dc 2 days ago 6.67GB

┌──(root💀vm-iot-jsho-docker-02)-[~]
└─# docker save -o /tmp/oracle19ee.backup.20210213.tar oracle19ee.backup.20210213

┌──(root💀vm-iot-jsho-docker-02)-[~]
└─#