参考《docker安装oracle19c》

在安装的过程中需要准备一台机器,这里用虚拟机演示;

因为oracle 19c对内存和磁盘存储有限制。在安装的过程中发现没有符合oracle的要求,导致启动容器的时候,oracle安装报错。

先决条件:

为了安装oracle,我这里将内存和磁盘存储调大。(可以考虑另外搞一个新的虚拟机)
本次实验的硬件参数
内存设置为8G
磁盘为60G

如果此前你的磁盘大小和内存都不满足需要进行扩容。
需要注意的是,用虚拟机上面操作扩容磁盘虽然显示你扩容了,但是linux系统的磁盘没有进行更新,需要通过磁盘工具进行扩容,好比加了一块新的磁盘,你需要进行格式化,然后扩展磁盘。


docker环境搭建 省略略


第一步、创建数据卷

数据卷需要 授权777,-R是递归,不然安装会失败

mkdir -p /mydata/oracle/oradata
chmod 777 -R /mydata/oracle/oradata

第二步、启动容器

用的是第三方搭建的镜像,自行修改配置

docker run --network=host \
-e ORACLE_SID=orcl \
-e ORACLE_PDB=orclpdb1 \
-e ORACLE_PWD=123456 \
-e ORACLE_EDITION=standard \
-e ORACLE_CHARACTERSET=zhs16gbk \
-v /mydata/oracle/oradata:/opt/oracle/oradata \
-v /mydata/oracle/diag:/opt/oracle/diag \
--restart=always \
--name oracle \
registry.cn-hangzhou.aliyuncs.com/zhuyijun/oracle:19c

关于oracle启动时打印的日志

下面的日志中,当日志显示下面标出的信息后,说明数据库已经启动完成了。
在这里插入图片描述
完整的启动日志信息

Xshell 6 (Build 0111)
Copyright (c) 2002 NetSarang Computer, Inc. All rights reserved.

Type `help' to learn how to use Xshell prompt.
[C:\~]$ 

Connecting to 192.168.117.128:22...
Connection established.
To escape to local shell, press 'Ctrl+Alt+]'.

Welcome to Ubuntu 22.04 LTS (GNU/Linux 5.15.0-46-generic x86_64)

 * Documentation:  https://help.ubuntu.com
 * Management:     https://landscape.canonical.com
 * Support:        https://ubuntu.com/advantage

174 updates can be applied immediately.
To see these additional updates run: apt list --upgradable

Last login: Fri Aug 12 01:36:07 2022 from 192.168.117.1
root@angel:~# mkdir -p /mydata/oracle/oradata
root@angel:~# chmod 777 -R /mydata/oracle/oradata
root@angel:~# mkdir -p /mydata/oracle/diag
root@angel:~# chmod 777 /mydata/oracle/diag
root@angel:~# docker run --network=host \
> -e ORACLE_SID=orcl \
> -e ORACLE_PDB=orclpdb1 \
> -e ORACLE_PWD=123456 \
> -e ORACLE_EDITION=standard \
> -e ORACLE_CHARACTERSET=zhs16gbk \
> -v /mydata/oracle/oradata:/opt/oracle/oradata \
> -v /mydata/oracle/diag:/opt/oracle/diag \
> --restart=always \
> --name oracle \
> registry.cn-hangzhou.aliyuncs.com/zhuyijun/oracle:19c
Unable to find image 'registry.cn-hangzhou.aliyuncs.com/zhuyijun/oracle:19c' locally
19c: Pulling from zhuyijun/oracle
bce8f778fef0: Pull complete 
3fc3fd32c0bc: Pull complete 
02948dd6d654: Pull complete 
67f2dfeb2f1b: Pull complete 
2e42d8039fd9: Pull complete 
b94f01bb60c6: Pull complete 
Digest: sha256:3898a9394720f30ce7f0b83ef2d172f4cd11b958282e0505f83cf2b0e5eaf7d4
Status: Downloaded newer image for registry.cn-hangzhou.aliyuncs.com/zhuyijun/oracle:19c
cat: /sys/fs/cgroup/memory/memory.limit_in_bytes: No such file or directory
cat: /sys/fs/cgroup/memory/memory.limit_in_bytes: No such file or directory
/opt/oracle/runOracle.sh: line 103: [: -lt: unary operator expected
Relinking oracle binary for edition: standard
make -f /opt/oracle/product/19c/dbhome_1/rdbms/lib/ins_rdbms.mk edition_standard ioracle
Deploying Oracle Database Standard Edition
mv -f /opt/oracle/product/19c/dbhome_1/lib/libedtn19.a /opt/oracle/product/19c/dbhome_1/lib/libedtn19_backup.a
cp /opt/oracle/product/19c/dbhome_1/lib/libedtn19_std.a /opt/oracle/product/19c/dbhome_1/lib/libedtn19.a
chmod 755 /opt/oracle/product/19c/dbhome_1/bin

 - Linking Oracle 
rm -f /opt/oracle/product/19c/dbhome_1/rdbms/lib/oracle
/opt/oracle/product/19c/dbhome_1/bin/orald  -o /opt/oracle/product/19c/dbhome_1/rdbms/lib/oracle -m64 -z noexecstack -Wl,--disable-new-dtags -L/opt/oracle/product/19c/dbhome_1/rdbms/lib/ -L/opt/oracle/product/19c/dbhome_1/lib/ -L/opt/oracle/product/19c/dbhome_1/lib/stubs/   -Wl,-E /opt/oracle/product/19c/dbhome_1/rdbms/lib/opimai.o /opt/oracle/product/19c/dbhome_1/rdbms/lib/ssoraed.o /opt/oracle/product/19c/dbhome_1/rdbms/lib/ttcsoi.o -Wl,--whole-archive -lperfsrv19 -Wl,--no-whole-archive /opt/oracle/product/19c/dbhome_1/lib/nautab.o /opt/oracle/product/19c/dbhome_1/lib/naeet.o /opt/oracle/product/19c/dbhome_1/lib/naect.o /opt/oracle/product/19c/dbhome_1/lib/naedhs.o /opt/oracle/product/19c/dbhome_1/rdbms/lib/config.o  -ldmext -lserver19 -lodm19 -lofs -lcell19 -lnnet19 -lskgxp19 -lsnls19 -lnls19  -lcore19 -lsnls19 -lnls19 -lcore19 -lsnls19 -lnls19 -lxml19 -lcore19 -lunls19 -lsnls19 -lnls19 -lcore19 -lnls19 -lclient19  -lvsnst19 -lcommon19 -lgeneric19 -lknlopt -loraolap19 -lskjcx19 -lslax19 -lpls19  -lrt -lplp19 -ldmext -lserver19 -lclient19  -lvsnst19 -lcommon19 -lgeneric19 `if [ -f /opt/oracle/product/19c/dbhome_1/lib/libavserver19.a ] ; then echo "-lavserver19" ; else echo "-lavstub19"; fi` `if [ -f /opt/oracle/product/19c/dbhome_1/lib/libavclient19.a ] ; then echo "-lavclient19" ; fi` -lknlopt -lslax19 -lpls19  -lrt -lplp19 -ljavavm19 -lserver19  -lwwg  `cat /opt/oracle/product/19c/dbhome_1/lib/ldflags`    -lncrypt19 -lnsgr19 -lnzjs19 -ln19 -lnl19 -lngsmshd19 -lnro19 `cat /opt/oracle/product/19c/dbhome_1/lib/ldflags`    -lncrypt19 -lnsgr19 -lnzjs19 -ln19 -lnl19 -lngsmshd19 -lnnzst19 -lzt19 -lztkg19 -lmm -lsnls19 -lnls19  -lcore19 -lsnls19 -lnls19 -lcore19 -lsnls19 -lnls19 -lxml19 -lcore19 -lunls19 -lsnls19 -lnls19 -lcore19 -lnls19 -lztkg19 `cat /opt/oracle/product/19c/dbhome_1/lib/ldflags`    -lncrypt19 -lnsgr19 -lnzjs19 -ln19 -lnl19 -lngsmshd19 -lnro19 `cat /opt/oracle/product/19c/dbhome_1/lib/ldflags`    -lncrypt19 -lnsgr19 -lnzjs19 -ln19 -lnl19 -lngsmshd19 -lnnzst19 -lzt19 -lztkg19   -lsnls19 -lnls19  -lcore19 -lsnls19 -lnls19 -lcore19 -lsnls19 -lnls19 -lxml19 -lcore19 -lunls19 -lsnls19 -lnls19 -lcore19 -lnls19 `if /usr/bin/ar tv /opt/oracle/product/19c/dbhome_1/rdbms/lib/libknlopt.a | grep "kxmnsd.o" > /dev/null 2>&1 ; then echo " " ; else echo "-lordsdo19 -lserver19"; fi` -L/opt/oracle/product/19c/dbhome_1/ctx/lib/ -lctxc19 -lctx19 -lzx19 -lgx19 -lctx19 -lzx19 -lgx19 -lclscest19 -loevm -lclsra19 -ldbcfg19 -lhasgen19 -lskgxn2 -lnnzst19 -lzt19 -lxml19 -lgeneric19 -locr19 -locrb19 -locrutl19 -lhasgen19 -lskgxn2 -lnnzst19 -lzt19 -lxml19 -lgeneric19  -lgeneric19 -lorazip -loraz -llzopro5 -lorabz2 -lorazstd -loralz4 -lipp_z -lipp_bz2 -lippdc -lipps -lippcore  -lippcp -lsnls19 -lnls19  -lcore19 -lsnls19 -lnls19 -lcore19 -lsnls19 -lnls19 -lxml19 -lcore19 -lunls19 -lsnls19 -lnls19 -lcore19 -lnls19 -lsnls19 -lunls19  -lsnls19 -lnls19  -lcore19 -lsnls19 -lnls19 -lcore19 -lsnls19 -lnls19 -lxml19 -lcore19 -lunls19 -lsnls19 -lnls19 -lcore19 -lnls19 -lasmclnt19 -lcommon19 -lcore19  -ledtn19 -laio -lons  -lmql1 -lipc1 -lfthread19    `cat /opt/oracle/product/19c/dbhome_1/lib/sysliblist` -Wl,-rpath,/opt/oracle/product/19c/dbhome_1/lib -lm    `cat /opt/oracle/product/19c/dbhome_1/lib/sysliblist` -ldl -lm   -L/opt/oracle/product/19c/dbhome_1/lib `test -x /usr/bin/hugeedit -a -r /usr/lib64/libhugetlbfs.so && test -r /opt/oracle/product/19c/dbhome_1/rdbms/lib/shugetlbfs.o && echo -Wl,-zcommon-page-size=2097152 -Wl,-zmax-page-size=2097152 -lhugetlbfs`
rm -f /opt/oracle/product/19c/dbhome_1/bin/oracle 
mv /opt/oracle/product/19c/dbhome_1/rdbms/lib/oracle /opt/oracle/product/19c/dbhome_1/bin/oracle
chmod 6751 /opt/oracle/product/19c/dbhome_1/bin/oracle
(if [ ! -f /opt/oracle/product/19c/dbhome_1/bin/crsd.bin ]; then \
    getcrshome="/opt/oracle/product/19c/dbhome_1/srvm/admin/getcrshome" ; \
    if [ -f "$getcrshome" ]; then \
        crshome="`$getcrshome`"; \
        if [ -n "$crshome" ]; then \
            if [ $crshome != /opt/oracle/product/19c/dbhome_1 ]; then \
                oracle="/opt/oracle/product/19c/dbhome_1/bin/oracle"; \
                $crshome/bin/setasmgidwrap oracle_binary_path=$oracle; \
            fi \
        fi \
    fi \
fi\
);
ORACLE EDITION: STANDARD
ORACLE PASSWORD FOR SYS, SYSTEM AND PDBADMIN: 123456

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 13-AUG-2022 15:48:13

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/angel/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                13-AUG-2022 15:48:13
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/angel/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
[WARNING] [DBT-06208] The 'SYS' password entered does not conform to the Oracle recommended standards.
   CAUSE: 
a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].
b.The password entered is a keyword that Oracle does not recommend to be used as password
   ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.
[WARNING] [DBT-06208] The 'SYSTEM' password entered does not conform to the Oracle recommended standards.
   CAUSE: 
a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].
b.The password entered is a keyword that Oracle does not recommend to be used as password
   ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.
[WARNING] [DBT-06208] The 'PDBADMIN' password entered does not conform to the Oracle recommended standards.
   CAUSE: 
a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].
b.The password entered is a keyword that Oracle does not recommend to be used as password
   ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.
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/ORCL.
Database Information:
Global Database Name:ORCL
System Identifier(SID):ORCL
Look at the log file "/opt/oracle/cfgtoollogs/dbca/ORCL/ORCL.log" for further details.

SQL*Plus: Release 19.0.0.0.0 - Production on Sat Aug 13 16:00:31 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:
ORCLPDB1(3):Completed: ALTER DATABASE DEFAULT TABLESPACE "USERS"
2022-08-13T16:00:31.267007+00:00
ALTER SYSTEM SET control_files='/opt/oracle/oradata/ORCL/control01.ctl' SCOPE=SPFILE;
2022-08-13T16:00:31.280438+00:00
ALTER SYSTEM SET local_listener='' SCOPE=BOTH;
   ALTER PLUGGABLE DATABASE ORCLPDB1 SAVE STATE
Completed:    ALTER PLUGGABLE DATABASE ORCLPDB1 SAVE STATE
2022-08-13T16:00:31.311856+00:00

XDB initialized.
2022-08-13T16:10:23.493496+00:00
ORCLPDB1(3):Resize operation completed for file# 10, old size 327680K, new size 337920K
2022-08-13T18:00:46.937318+00:00
Resize operation completed for file# 3, old size 522240K, new size 532480K
2022-08-13T21:42:23.897968+00:00
Resize operation completed for file# 201, old size 32768K, new size 33792K
Resize operation completed for file# 201, old size 33792K, new size 34816K
Resize operation completed for file# 201, old size 34816K, new size 35840K
Resize operation completed for file# 201, old size 35840K, new size 36864K
Resize operation completed for file# 201, old size 36864K, new size 37888K
Resize operation completed for file# 201, old size 37888K, new size 38912K
Resize operation completed for file# 201, old size 38912K, new size 39936K
Resize operation completed for file# 201, old size 39936K, new size 40960K
Resize operation completed for file# 201, old size 40960K, new size 41984K
Resize operation completed for file# 201, old size 41984K, new size 43008K
Resize operation completed for file# 201, old size 43008K, new size 44032K
Resize operation completed for file# 201, old size 44032K, new size 45056K
Resize operation completed for file# 201, old size 45056K, new size 46080K
Resize operation completed for file# 201, old size 46080K, new size 47104K
Resize operation completed for file# 201, old size 47104K, new size 48128K
Resize operation completed for file# 201, old size 48128K, new size 49152K
Resize operation completed for file# 201, old size 49152K, new size 50176K
Resize operation completed for file# 201, old size 50176K, new size 51200K
Resize operation completed for file# 201, old size 51200K, new size 52224K
Resize operation completed for file# 201, old size 52224K, new size 53248K
Resize operation completed for file# 201, old size 53248K, new size 54272K
Resize operation completed for file# 201, old size 54272K, new size 55296K
Resize operation completed for file# 201, old size 55296K, new size 56320K
Resize operation completed for file# 201, old size 56320K, new size 57344K
Resize operation completed for file# 201, old size 57344K, new size 58368K
Resize operation completed for file# 201, old size 58368K, new size 59392K
Resize operation completed for file# 201, old size 59392K, new size 60416K
Resize operation completed for file# 201, old size 60416K, new size 61440K
Resize operation completed for file# 201, old size 61440K, new size 62464K
Resize operation completed for file# 201, old size 62464K, new size 63488K
Resize operation completed for file# 201, old size 63488K, new size 64512K
Resize operation completed for file# 201, old size 64512K, new size 65536K
Resize operation completed for file# 201, old size 65536K, new size 66560K
Resize operation completed for file# 201, old size 66560K, new size 67584K
Resize operation completed for file# 201, old size 67584K, new size 68608K
Resize operation completed for file# 201, old size 68608K, new size 69632K
Resize operation completed for file# 201, old size 69632K, new size 70656K
Resize operation completed for file# 201, old size 70656K, new size 71680K
Resize operation completed for file# 201, old size 71680K, new size 72704K
Resize operation completed for file# 201, old size 72704K, new size 73728K
Resize operation completed for file# 201, old size 73728K, new size 74752K
Resize operation completed for file# 201, old size 74752K, new size 75776K
Resize operation completed for file# 201, old size 75776K, new size 76800K
Resize operation completed for file# 201, old size 76800K, new size 77824K
Resize operation completed for file# 201, old size 77824K, new size 78848K
Resize operation completed for file# 201, old size 78848K, new size 79872K
Resize operation completed for file# 201, old size 79872K, new size 80896K
Resize operation completed for file# 201, old size 80896K, new size 81920K
Resize operation completed for file# 201, old size 81920K, new size 82944K
Resize operation completed for file# 201, old size 82944K, new size 83968K
Resize operation completed for file# 201, old size 83968K, new size 84992K
Resize operation completed for file# 201, old size 84992K, new size 86016K
Resize operation completed for file# 201, old size 86016K, new size 87040K
Resize operation completed for file# 201, old size 87040K, new size 88064K
Resize operation completed for file# 201, old size 88064K, new size 89088K
Resize operation completed for file# 201, old size 89088K, new size 90112K
Resize operation completed for file# 201, old size 90112K, new size 91136K
Resize operation completed for file# 201, old size 91136K, new size 92160K
Resize operation completed for file# 201, old size 92160K, new size 93184K
Resize operation completed for file# 201, old size 93184K, new size 94208K
Resize operation completed for file# 201, old size 94208K, new size 95232K
Resize operation completed for file# 201, old size 95232K, new size 96256K
Resize operation completed for file# 201, old size 96256K, new size 97280K
Resize operation completed for file# 201, old size 97280K, new size 98304K
Resize operation completed for file# 201, old size 98304K, new size 99328K
Resize operation completed for file# 201, old size 99328K, new size 100352K
Resize operation completed for file# 201, old size 100352K, new size 101376K
Resize operation completed for file# 201, old size 101376K, new size 102400K
Resize operation completed for file# 201, old size 102400K, new size 103424K
Resize operation completed for file# 201, old size 103424K, new size 104448K
Resize operation completed for file# 201, old size 104448K, new size 105472K
Resize operation completed for file# 201, old size 105472K, new size 106496K
Resize operation completed for file# 201, old size 106496K, new size 107520K
Resize operation completed for file# 201, old size 107520K, new size 108544K
Resize operation completed for file# 201, old size 108544K, new size 109568K
Resize operation completed for file# 201, old size 109568K, new size 110592K
Resize operation completed for file# 201, old size 110592K, new size 111616K
Resize operation completed for file# 201, old size 111616K, new size 112640K
Resize operation completed for file# 201, old size 112640K, new size 113664K
Resize operation completed for file# 201, old size 113664K, new size 114688K
Resize operation completed for file# 201, old size 114688K, new size 115712K
2022-08-13T21:42:24.899414+00:00
Resize operation completed for file# 201, old size 115712K, new size 116736K
Resize operation completed for file# 201, old size 116736K, new size 117760K
Resize operation completed for file# 201, old size 117760K, new size 118784K
Resize operation completed for file# 201, old size 118784K, new size 119808K
Resize operation completed for file# 201, old size 119808K, new size 120832K
Resize operation completed for file# 201, old size 120832K, new size 121856K
Resize operation completed for file# 201, old size 121856K, new size 122880K
2022-08-13T21:42:42.180573+00:00
ORCLPDB1(3):Resize operation completed for file# 203, old size 36864K, new size 37888K
ORCLPDB1(3):Resize operation completed for file# 203, old size 37888K, new size 38912K
ORCLPDB1(3):Resize operation completed for file# 203, old size 38912K, new size 39936K
ORCLPDB1(3):Resize operation completed for file# 203, old size 39936K, new size 40960K
ORCLPDB1(3):Resize operation completed for file# 203, old size 40960K, new size 41984K
ORCLPDB1(3):Resize operation completed for file# 203, old size 41984K, new size 43008K
ORCLPDB1(3):Resize operation completed for file# 203, old size 43008K, new size 44032K
ORCLPDB1(3):Resize operation completed for file# 203, old size 44032K, new size 45056K
ORCLPDB1(3):Resize operation completed for file# 203, old size 45056K, new size 46080K
ORCLPDB1(3):Resize operation completed for file# 203, old size 46080K, new size 47104K
ORCLPDB1(3):Resize operation completed for file# 203, old size 47104K, new size 48128K
ORCLPDB1(3):Resize operation completed for file# 203, old size 48128K, new size 49152K
ORCLPDB1(3):Resize operation completed for file# 203, old size 49152K, new size 50176K
ORCLPDB1(3):Resize operation completed for file# 203, old size 50176K, new size 51200K
ORCLPDB1(3):Resize operation completed for file# 203, old size 51200K, new size 52224K
ORCLPDB1(3):Resize operation completed for file# 203, old size 52224K, new size 53248K
ORCLPDB1(3):Resize operation completed for file# 203, old size 53248K, new size 54272K
ORCLPDB1(3):Resize operation completed for file# 203, old size 54272K, new size 55296K
ORCLPDB1(3):Resize operation completed for file# 203, old size 55296K, new size 56320K
ORCLPDB1(3):Resize operation completed for file# 203, old size 56320K, new size 57344K
ORCLPDB1(3):Resize operation completed for file# 203, old size 57344K, new size 58368K
ORCLPDB1(3):Resize operation completed for file# 203, old size 58368K, new size 59392K
ORCLPDB1(3):Resize operation completed for file# 203, old size 59392K, new size 60416K
ORCLPDB1(3):Resize operation completed for file# 203, old size 60416K, new size 61440K
ORCLPDB1(3):Resize operation completed for file# 203, old size 61440K, new size 62464K
ORCLPDB1(3):Resize operation completed for file# 203, old size 62464K, new size 63488K
ORCLPDB1(3):Resize operation completed for file# 203, old size 63488K, new size 64512K
ORCLPDB1(3):Resize operation completed for file# 203, old size 64512K, new size 65536K
ORCLPDB1(3):Resize operation completed for file# 203, old size 65536K, new size 66560K
ORCLPDB1(3):Resize operation completed for file# 203, old size 66560K, new size 67584K
ORCLPDB1(3):Resize operation completed for file# 203, old size 67584K, new size 68608K
ORCLPDB1(3):Resize operation completed for file# 203, old size 68608K, new size 69632K
ORCLPDB1(3):Resize operation completed for file# 203, old size 69632K, new size 70656K
ORCLPDB1(3):Resize operation completed for file# 203, old size 70656K, new size 71680K
ORCLPDB1(3):Resize operation completed for file# 203, old size 71680K, new size 72704K
ORCLPDB1(3):Resize operation completed for file# 203, old size 72704K, new size 73728K
ORCLPDB1(3):Resize operation completed for file# 203, old size 73728K, new size 74752K
ORCLPDB1(3):Resize operation completed for file# 203, old size 74752K, new size 75776K
ORCLPDB1(3):Resize operation completed for file# 203, old size 75776K, new size 76800K
ORCLPDB1(3):Resize operation completed for file# 203, old size 76800K, new size 77824K
ORCLPDB1(3):Resize operation completed for file# 203, old size 77824K, new size 78848K
ORCLPDB1(3):Resize operation completed for file# 203, old size 78848K, new size 79872K
ORCLPDB1(3):Resize operation completed for file# 203, old size 79872K, new size 80896K
ORCLPDB1(3):Resize operation completed for file# 203, old size 80896K, new size 81920K
ORCLPDB1(3):Resize operation completed for file# 203, old size 81920K, new size 82944K
ORCLPDB1(3):Resize operation completed for file# 203, old size 82944K, new size 83968K
ORCLPDB1(3):Resize operation completed for file# 203, old size 83968K, new size 84992K
ORCLPDB1(3):Resize operation completed for file# 203, old size 84992K, new size 86016K
ORCLPDB1(3):Resize operation completed for file# 203, old size 86016K, new size 87040K
ORCLPDB1(3):Resize operation completed for file# 203, old size 87040K, new size 88064K
ORCLPDB1(3):Resize operation completed for file# 203, old size 88064K, new size 89088K
ORCLPDB1(3):Resize operation completed for file# 203, old size 89088K, new size 90112K
ORCLPDB1(3):Resize operation completed for file# 203, old size 90112K, new size 91136K
ORCLPDB1(3):Resize operation completed for file# 203, old size 91136K, new size 92160K
ORCLPDB1(3):Resize operation completed for file# 203, old size 92160K, new size 93184K
ORCLPDB1(3):Resize operation completed for file# 203, old size 93184K, new size 94208K
ORCLPDB1(3):Resize operation completed for file# 203, old size 94208K, new size 95232K
ORCLPDB1(3):Resize operation completed for file# 203, old size 95232K, new size 96256K
ORCLPDB1(3):Resize operation completed for file# 203, old size 96256K, new size 97280K
ORCLPDB1(3):Resize operation completed for file# 203, old size 97280K, new size 98304K
ORCLPDB1(3):Resize operation completed for file# 203, old size 98304K, new size 99328K
ORCLPDB1(3):Resize operation completed for file# 203, old size 99328K, new size 100352K
ORCLPDB1(3):Resize operation completed for file# 203, old size 100352K, new size 101376K
ORCLPDB1(3):Resize operation completed for file# 203, old size 101376K, new size 102400K
ORCLPDB1(3):Resize operation completed for file# 203, old size 102400K, new size 103424K
ORCLPDB1(3):Resize operation completed for file# 203, old size 103424K, new size 104448K
ORCLPDB1(3):Resize operation completed for file# 203, old size 104448K, new size 105472K
ORCLPDB1(3):Resize operation completed for file# 203, old size 105472K, new size 106496K
ORCLPDB1(3):Resize operation completed for file# 203, old size 106496K, new size 107520K
ORCLPDB1(3):Resize operation completed for file# 203, old size 107520K, new size 108544K
ORCLPDB1(3):Resize operation completed for file# 203, old size 108544K, new size 109568K
ORCLPDB1(3):Resize operation completed for file# 203, old size 109568K, new size 110592K
ORCLPDB1(3):Resize operation completed for file# 203, old size 110592K, new size 111616K
ORCLPDB1(3):Resize operation completed for file# 203, old size 111616K, new size 112640K
ORCLPDB1(3):Resize operation completed for file# 203, old size 112640K, new size 113664K
ORCLPDB1(3):Resize operation completed for file# 203, old size 113664K, new size 114688K
ORCLPDB1(3):Resize operation completed for file# 203, old size 114688K, new size 115712K
ORCLPDB1(3):Resize operation completed for file# 203, old size 115712K, new size 116736K
ORCLPDB1(3):Resize operation completed for file# 203, old size 116736K, new size 117760K
ORCLPDB1(3):Resize operation completed for file# 203, old size 117760K, new size 118784K
ORCLPDB1(3):Resize operation completed for file# 203, old size 118784K, new size 119808K
ORCLPDB1(3):Resize operation completed for file# 203, old size 119808K, new size 120832K
ORCLPDB1(3):Resize operation completed for file# 203, old size 120832K, new size 121856K
ORCLPDB1(3):Resize operation completed for file# 203, old size 121856K, new size 122880K
2022-08-14T02:00:25.861561+00:00
TABLE SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P201 (44786) VALUES LESS THAN (TO_DATE(' 2022-08-15 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
TABLE SYS.WRI$_OPTSTAT_HISTGRM_HISTORY: ADDED INTERVAL PARTITION SYS_P204 (44786) VALUES LESS THAN (TO_DATE(' 2022-08-15 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2022-08-14T06:00:14.264557+00:00
Resize operation completed for file# 1, old size 911360K, new size 921600K
2022-08-14T06:01:07.075559+00:00
Thread 1 cannot allocate new log, sequence 8
Private strand flush not complete
  Current log# 1 seq# 7 mem# 0: /opt/oracle/oradata/ORCL/redo01.log
2022-08-14T06:01:10.115858+00:00
Thread 1 advanced to log sequence 8 (LGWR switch)
  Current log# 2 seq# 8 mem# 0: /opt/oracle/oradata/ORCL/redo02.log
2022-08-14T06:03:19.291451+00:00
Resize operation completed for file# 3, old size 532480K, new size 542720K

第三步、修改登录密码

另外开一个终端,通过docker命令让容器内部的oracle修改所有用户的密码为123456
oracle是上面的–name的容器名称叫oracle

docker exec oracle ./setPassword.sh 123456

第四步、登录

在这里插入图片描述


其它:

使用https访问oracle内部的web管理页面。将下面的192.168.117.128替换成虚拟机的地址

https://192.168.117.128:5500/em

前面修改了密码都是123456,那么这里可以用
system
sys
等用户登录进去,密码都是123456
容器名称是-e ORACLE_PDB=orclpdb1 中的启动参数值

在这里插入图片描述

Logo

华为开发者空间,是为全球开发者打造的专属开发空间,汇聚了华为优质开发资源及工具,致力于让每一位开发者拥有一台云主机,基于华为根生态开发、创新。

更多推荐