Linux中Docker快速安装Oracle 18c、21c、23ai

项目中需要用到Oracle多个版本的环境进行测试验证，11g版本有几个，缺少高版本的Oracle，遂决定用Docker快速拉起多个版本的单实例。

阿里云创建一个按量付费的抢占式实例，2c8g，系统盘50G，操作系统：Rocky Linux 8.9 64位

[root@iZbp12pyn2zoan7xvmajciZ ~]# cat /etc/redhat-release 
Rocky Linux release 8.9 (Green Obsidian)
复制

安装并启动docker，PS：yum默认安装了红帽版容器podman，命令和docker类似，且可沿用docker命令。

yum install docker
service start podman
复制

在Oracle官网镜像仓库查找需要的镜像，拉取18c\21c\23ai docker镜像

docker pull container-registry.oracle.com/database/free:latest

docker pull container-registry.oracle.com/database/express:18.4.0-xe

docker pull container-registry.oracle.com/database/express:21.3.0-xe
复制

创建目录，调整权限

mkdir -p /u01/oracle/23ai
mkdir -p /u01/oracle/18c
mkdir -p /u01/oracle/21c

chmod -R o+w /u01

复制

分别运行数据库实例

podman run --name ora23ai \
-p 1523:1521 \
-e ORACLE_PWD=Ora2024 \
-v /u01/oracle/23ai:/opt/oracle/oradata \
container-registry.oracle.com/database/free:latest 


podman run --name ora21c \
-p 1521:1521 -p 5500:5500 \
-e ORACLE_PWD=Ora2021 \
-v /u01/oracle/21c:/opt/oracle/oradata \
container-registry.oracle.com/database/express:21.3.0-xe


podman run --name ora18c \
-p 1518:1521 \
-e ORACLE_PWD=Ora2018 \
-v /u01/oracle/18c:/opt/oracle/oradata \
container-registry.oracle.com/database/express:18.4.0-xe

复制

查看docker运行状态

[root@iZbp12pyn2zoan7xvmajciZ ~]# podman ps
CONTAINER ID  IMAGE                                                     COMMAND               CREATED            STATUS                   PORTS                                           NAMES
91dbb37c2ab0  container-registry.oracle.com/database/free:latest        /bin/bash -c $ORA...  4 hours ago        Up 54 minutes (healthy)  0.0.0.0:1523->1521/tcp                          ora23ai
c8ab2b85d8b3  container-registry.oracle.com/database/express:21.3.0-xe  /bin/bash -c $ORA...  3 hours ago        Up 56 minutes (healthy)  0.0.0.0:1521->1521/tcp, 0.0.0.0:5500->5500/tcp  ora21c
fbe22c391b6b  container-registry.oracle.com/database/express:18.4.0-xe  /bin/sh -c exec $...  About an hour ago  Up 57 minutes (healthy)  0.0.0.0:1518->1521/tcp                          ora18c
复制

验证数据库

[root@iZbp12pyn2zoan7xvmajciZ ~]# docker exec -it ora18c sqlplus sys/Ora2018@//localhost:1521/XE as sysdba
Emulate Docker CLI using podman. Create /etc/containers/nodocker to quiet msg.

SQL*Plus: Release 18.0.0.0.0 - Production on Tue Sep 24 06:39:48 2024
Version 18.4.0.0.0

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


Connected to:
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Version 18.4.0.0.0

SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 XEPDB1                         READ WRITE NO
SQL> Disconnected from Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Version 18.4.0.0.0
[root@iZbp12pyn2zoan7xvmajciZ ~]# docker exec -it ora21c sqlplus / as sysdba
Emulate Docker CLI using podman. Create /etc/containers/nodocker to quiet msg.

SQL*Plus: Release 21.0.0.0.0 - Production on Tue Sep 24 06:40:21 2024
Version 21.3.0.0.0

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


Connected to:
Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production
Version 21.3.0.0.0

SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 XEPDB1                         READ WRITE NO
SQL> Disconnected from Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production
Version 21.3.0.0.0
[root@iZbp12pyn2zoan7xvmajciZ ~]# docker exec -it ora23ai sqlplus / as sysdba
Emulate Docker CLI using podman. Create /etc/containers/nodocker to quiet msg.

SQL*Plus: Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems on Tue Sep 24 06:40:38 2024
Version 23.5.0.24.07

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


Connected to:
Oracle Database 23ai Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free
Version 23.5.0.24.07

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 FREEPDB1                       READ WRITE NO
SQL> 
复制