修改 memory_max_target 为1G后,重启数据库出现以下错误提示:
SQL> startup
ORA-00845:
MEMORY_TARGET not supported on this system
修改tmpfs,增加size=1024M
[root@demo ~]# cat /etc/fstab
LABEL=/
/ ext3 defaults 1 1
LABEL=/boot
/boot ext3 defaults 1 2
tmpfs
/dev/shm tmpfs defaults,size=1024M 0 0
重新加载:
umount /dev/shm
mount /dev/shm
重新检查:
[root@demo ~]# df -h
Filesystem Size Used Avail Use%
Mounted on
/dev/sda3 32G 16G 15G 51% /
/dev/sda1
99M 12M 83M 13% /boot
tmpfs 1.0G 523M 502M 52%
/dev/shm
可正常启动数据库.
参考:
http://2358205.blog.51cto.com/2348205/1001537