下载oracle docker-images

github地址：https://github.com/oracle/docker-images
zip下载地址：https://codeload.github.com/oracle/docker-images/zip/refs/heads/main

docker如果是默认的，需要升级下才能安装

否则报错如下

WARNING: You're not using the default seccomp profile
Checking Docker version.
Docker version is below the minimum required version 17.09
Please upgrade your Docker installation to procee

升级docker

systemctl stop docker.service

yum remove -y docker docker-client docker-client-latest docker-common docker-latest docker-latest-logrotate docker-logrotate docker-selinux docker-engine-selinux docker-engine

yum install -y yum-utils device-mapper-persistent-data lvm2
yum-config-manager --add-repo http://mirrors.aliyun.com/docker-ce/linux/centos/docker-ce.repo
 
yum -y install docker-ce docker-ce-cli containerd.io

docker 构造oracle image

需要从官网下载oracle安装包，19c是如下zip
LINUX.X64_193000_db_home.zip

# 解压从github下载的docker-images
unzip docker-images-main.zip

# 将oracle安装包放在docker-images的执行路径。oracle数据库版本不同需要放在不同的路径下
mv LINUX.X64_193000_db_home.zip docker-images-main/OracleDatabase/SingleInstance/dockerfiles/19.3.0/

# 操作系统需要添加一个oracle用户，给docker用
useradd oracle

# 切换目录，并且开始构建image
cd docker-images-main/OracleDatabase/SingleInstance/dockerfiles/
./buildContainerImage.sh -e -v 19.3.0 -o '--build-arg SLIMMING=true'

docker构造完成

如果出现以下提示，则证明oralce image构造完成

Successfully built b6247d563bf8
Successfully tagged oracle/database:19.3.0-ee

  Oracle Database container image for 'ee' version 19.3.0 is ready to be extended: 
    
    --> oracle/database:19.3.0-ee

  Build completed in 1268 seconds.
  
You have new mail in /var/spool/mail/root

docker run oracle

docker run oracle命令参考

# 格式
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> \
-e ENABLE_ARCHIVELOG=true \
-v [<host mount point>:]/opt/oracle/oradata \
-v [<host mount point>:]/opt/oracle/scripts/startup \
-v [<host mount point>:]/opt/oracle/scripts/setup
oracle/database:21.3.0-ee

以下为使用例子

创建数据文件目录

用户存放数据文件，并授权

mkdir -p /opt/oracle/oradata
chmod a+rwx /opt/oracle/ -R

运行容器

docker run -itd --name oracletest \
-p 1521:1521 -p 5500:5500 \
-e ORACLE_SID=oracletest \
-e ORACLEPDB=mytest \
-e ORACLEPWD=password \
-e INIT_SGA_SIZE=527 \
-e INIT_PGA_SIZE=128 \
-e ORACLE_EDITION=enterprise \
-e ORACLE_CHARACTERSET=AL32UTF8 \
-e ENABLE_ARCHIVELOG=false \
-v /opt/oracle/oradata:/opt/oracle/oradata \
oracle/database:19.3.0-ee

# 日志：
ORACLE EDITION: ENTERPRISE
ORACLE PASSWORD FOR SYS, SYSTEM AND PDBADMIN: rUUpXBPOBKg=1

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 30-SEP-2021 06:03:18

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/e84a01839c31/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                30-SEP-2021 06:03:18
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/e84a01839c31/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/ORACLETEST.
Database Information:
Global Database Name:ORACLETEST
System Identifier(SID):ORACLETEST
Look at the log file "/opt/oracle/cfgtoollogs/dbca/ORACLETEST/ORACLETEST.log" for further details.

SQL*Plus: Release 19.0.0.0.0 - Production on Thu Sep 30 06:33:56 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> SQL> 
Session altered.

SQL> 
User created.

SQL> 
Grant succeeded.

SQL> 
Grant succeeded.

SQL> 
User altered.

SQL> 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
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):Resize operation completed for file# 10, old size 337920K, new size 348160K
2021-09-30T06:33:57.465308+00:00
ALTER SYSTEM SET control_files='/opt/oracle/oradata/ORACLETEST/control01.ctl' SCOPE=SPFILE;
2021-09-30T06:33:57.530875+00:00
ALTER SYSTEM SET local_listener='' SCOPE=BOTH;
   ALTER PLUGGABLE DATABASE ORCLPDB1 SAVE STATE
Completed:    ALTER PLUGGABLE DATABASE ORCLPDB1 SAVE STATE
2021-09-30T06:34:02.809930+00:00

XDB initialized

看到*DATABASE IS READY TO USE!*就说明oracle创建完毕了

进docker

docker ps

查看container id

docker exec -it cb80027f7449 bash