MEMORY_TARGET not supported on this system

原创

于 2021-04-18 17:07:58 发布 · 613 阅读

2 ·

CC 4.0 BY-SA版权

今天是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