MEMORY_TARGET not supported on this system

今天是2021-04-18，在安装12c emcc的时候，配置参数提示：MEMORY_TARGET not supported on this system

SQL> startup force;
ORA-00845: MEMORY_TARGET not supported on this system
SQL>

该问题是/dev/shm设置台下oracle不允许自动内存分配。

SQL> alter system set memory_target=2G scope=spfile;

System altered.

linux system：
[oracle@ocmhost2 ~]$ df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/vg_ocmhost1-lv_root
                       36G   17G   18G  48% /
tmpfs                 2.0G   72K  2.0G   1% /dev/shm
/dev/sda1             477M   82M  366M  19% /boot
[oracle@ocmhost2 ~]$

更改/dev/shm 大小。

#
# /etc/fstab
# Created by anaconda on Sun Apr 11 12:50:48 2021
#
# Accessible filesystems, by reference, are maintained under /dev/disk
# See man pages fstab(5), findfs(8), mount(8) and/or blkid(8) for more info
#
/dev/mapper/vg_ocmhost1-lv_root /                       ext4    defaults        1 1
UUID=0b51d4dc-2b99-4e51-a58c-17733d500c60 /boot                   ext4    defaults        1 2
/dev/mapper/vg_ocmhost1-lv_swap swap                    swap    defaults        0 0
tmpfs                   /dev/shm                tmpfs   defaults,size=4G        0 0
devpts                  /dev/pts                devpts  gid=5,mode=620  0 0

修改为4GB
[root@ocmhost2 ~]# mount -o remount /dev/shm
[root@ocmhost2 ~]# df -Th /dev/shm
Filesystem     Type   Size  Used Avail Use% Mounted on
tmpfs          tmpfs  4.0G   72K  4.0G   1% /dev/shm
[root@ocmhost2 ~]# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/vg_ocmhost1-lv_root
                       36G   17G   18G  48% /
tmpfs                 4.0G   72K  4.0G   1% /dev/shm
/dev/sda1             477M   82M  366M  19% /boot
[root@ocmhost2 ~]#

重新启动数据库：

[root@ocmhost2 ~]# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/vg_ocmhost1-lv_root
                       36G   17G   18G  48% /
tmpfs                 4.0G   72K  4.0G   1% /dev/shm
/dev/sda1             477M   82M  366M  19% /boot
[root@ocmhost2 ~]# su - oracle
[oracle@ocmhost2 ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.1.0 Production on Sun Apr 18 16:01:30 2021

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

Connected to an idle instance.

SQL> startup;
ORACLE instance started.

Total System Global Area 2137886720 bytes
Fixed Size                  2290416 bytes
Variable Size            1459621136 bytes
Database Buffers          671088640 bytes
Redo Buffers                4886528 bytes
Database mounted.
Database opened.
SQL>

问题解决、