docker 安装oracle 19c
参考在安装的过程中需要准备一台机器,这里用虚拟机演示;因为oracle 19c对内存和磁盘存储有限制。在安装的过程中发现没有符合oracle的要求,导致启动容器的时候,oracle安装报错。
·
在安装的过程中需要准备一台机器,这里用虚拟机演示;
因为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
中的启动参数值
更多推荐
已为社区贡献34条内容
所有评论(0)