ORA-00845: MEMORY_TARGET not supported on this system

问题描述,安装好oracle 12c后,调整内存参数,启动时报错:
alter system set memory_max_target=1g scope=spfile;
alter system set memory_target=1g scope=spfile;
alter system set sga_target=0 scope=spfile;
alter system set pga_aggregate_target=0 scope=spfile;
shutdown immediate;
startup;


SQL> startup
ORA-00845: MEMORY_TARGET not supported on this system
初始化参数MEMORY_TARGET或MEMORY_MAX_TARGET不能大于共享内存(/dev/shm),为了解决这个问题,可以增大/dev/shm,如下:


解决办法:
mount -o remount,size=2G /dev/shm

加入到启动项，新增加如下项
# vi /etc/fstab
tmpfs                  /dev/shm              tmpfs  defaults,size=2g      0 0

可以尝试重启机器
[root@localhost ~]# df -h
Filesystem                 Size  Used Avail Use% Mounted on
/dev/mapper/vgroot-lvroot   38G   18G   21G  47% /
devtmpfs                   908M     0  908M   0% /dev
tmpfs                      2.0G     0  2.0G   0% /dev/shm
tmpfs                      920M  8.6M  911M   1% /run
tmpfs                      920M     0  920M   0% /sys/fs/cgroup
/dev/sda1                  497M  138M  360M  28% /boot
tmpfs                      184M     0  184M   0% /run/user/0
[root@localhost ~]#

ORA-00845: MEMORY_TARGET not supported on this system

原文：https://www.cnblogs.com/hxlasky/p/11994270.html