docker部署ORACLE19C

docker部署ORACLE19C 拉取镜像建立映射目录并赋权启动容器创建PDB用户测试登录

拉取镜像

拉去的是阿里云的oracle19c 的镜像

docker pull registry.cn-hangzhou.aliyuncs.com/zhuyijun/oracle:19c

等待拉取完毕后，查看images

[root@localhost /]# docker images
REPOSITORY                                          TAG       IMAGE ID       CREATED         SIZE
mysql                                               latest    3218b38490ce   4 months ago    516MB
registry.cn-hangzhou.aliyuncs.com/zhuyijun/oracle   19c       7b5eb4597688   21 months ago   6.61GB

建立映射目录并赋权

[root@localhost /]# mkdir /data/oracle/oradata
[root@localhost /]# chmod 777 /data/oracle/oradata

启动容器

docker run -d -p 1521:1521 -p 5502:5500 -e ORACLE_SID=ORCLCDB -e ORACLE_PDB=ORCLPDB -e ORACLE_PWD=oracle -e ORACLE_EDITION=standard -e ORACLE_CHARACTERSET=AL32UTF8 -v /data/oracle/oradata/:/opt/oracle/oradata/ --name oracle_19c registry.cn-hangzhou.aliyuncs.com/zhuyijun/oracle

oracle容器运行后会自动创建PDB，但是需要时间，可以通过查看日志的方式来判断安装是否结束

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 Sat May 14 07:14:03 2022
Version 19.3.0.0.0

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


Connected to:
Oracle Database 19c Standard Edition 2 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 Standard Edition 2 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:
ORCLPDB(3):ALTER DATABASE DEFAULT TABLESPACE "USERS"
ORCLPDB(3):Completed: ALTER DATABASE DEFAULT TABLESPACE "USERS"
2022-05-14T07:14:03.436776+00:00
ALTER SYSTEM SET control_files='/opt/oracle/oradata/ORCLCDB/control01.ctl' SCOPE=SPFILE;
2022-05-14T07:14:03.439826+00:00
ALTER SYSTEM SET local_listener='' SCOPE=BOTH;
   ALTER PLUGGABLE DATABASE ORCLPDB SAVE STATE
Completed:    ALTER PLUGGABLE DATABASE ORCLPDB SAVE STATE

XDB initialized.
2022-05-14T07:23:58.240070+00:00
ORCLPDB(3):Resize operation completed for file# 10, old size 327680K, new size 337920K

出现以上的提示就是安装完成了。

创建PDB用户

首先登录docker容器

docker exec -it cec11 /bin/bash

登录sqlplus 创建PDB用户

[oracle@cec11fa8577e ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Sat May 14 08:06:32 2022
Version 19.3.0.0.0

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


Connected to:
Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 ORCLPDB                        READ WRITE NO
SQL> alter session set container=ORCLPDB;

Session altered.

SQL> create user pdbtest1 identified by pdbtest1;

User created.

SQL> grant dba to pdbtest1;

Grant succeeded.

测试登录