[oracle@ /root]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on 水 7月 27 08:52:11 2022
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
SQL> startup
ORA-00845: MEMORY_TARGET not supported on this system
找到错误原因是MEMORY_MAX_TARGET 的设置不能超过 /dev/shm 的大小
[oracle@ /root]$ df -h
devtmpfs 1.1G 0 1.1G 0% /dev
tmpfs 1.2G 544M 590M 48% /dev/shm
tmpfs 1.2G 9.5M 1.1G 1% /run
tmpfs 1.2G 0 1.2G 0% /sys/fs/cgroup
/dev/mapper/rhel-root 50G 29G 22G 58% /
/dev/mapper/rhel-home 27G 1.2G 26G 5% /home
/dev/sda1 1014M 183M 832M 19% /boot
tmpfs 227M 32K 227M 1% /run/user/54321
/dev/sr0 83M 83M 0 100% /run/media/oracle/VBox_GAs_6.0.8
tmpfs 227M 0 227M 0% /run/user/0
切换到root用户,使用命令增加内存
mount -o remount,size=2G /dev/shm/
[oracle@ /root]$ su root
密码:
[root@CSILO-GR ~]# mount -o remount,size=2G /dev/shm/
[root@CSILO-GR ~]# df -h | grep shm
tmpfs 2.0G 544M 1.5G 27% /dev/shm
[root@CSILO-GR ~]# su oracle
[oracle@CSILO-GR /root]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on 水 7月 27 10:43:48 2022
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
连接成功
SQL> startup
ORACLE instance启动成功
Total System Global Area 952105680 bytes
Fixed Size 8903376 bytes
Variable Size 629145600 bytes
Database Buffers 310378496 bytes
Redo Buffers 3678208 bytes