ORA-00845: MEMORY_TARGET not supported on this system

关注

转载最新推荐文章于 2026-07-07 12:32:42 发布 88 阅读 AI 写同款· GEO 优化 ›

昨天使用11g,修改了memory_max_target，memory_target到2885681152，重新启动报错：

ORA-00845: MEMORY_TARGET not supported on this system

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

查看alert.log文件，出现如下提示：

WARNING: You are trying to use the MEMORY_TARGET feature. This feature requires the /dev/shm file system to be mounted
for at least 2885681152 bytes. /dev/shm is either not mount ed or is mounted with available space less than this size.
Please fix this so that MEMORY_TARGET can work as expected. Current available is 2067841024 and used is 0 bytes.
memory_target needs larger /dev/shm

oracle11g的 MEMORY_TARGET feature需要/dev/shm file system被安装，大小要大于原来的设置.

各种系统的设计不同，我看了我的机器：

> df -h | grep shm
none                2.0G    0  2.0G 0% /dev/shm

有些是3.9G，好象与机器的配置有关，内存4G的分配缺省就是2G，8G的机器缺省就是3.9.

而且有些文件系统是Filesystem是NONE（rhel），有些是tmpfs（centos）。

仔细查看：
centos中fstab定义如下：
tmpfs                /dev/shm             tmpfs defaults       0 0

rhel中fstab定义如下：
none                   /dev/shm             tmpfs defaults       0 0

修改就很简单了，
tmpfs /dev/shm tmpfs defaults 0 0
为
tmpfs /dev/shm tmpfs defaults,size=3G 0 0

umount /dev/shm
mount /dev/shm

> df -h | grep shm
tmpfs                3.0G    0  3.0G 0% /dev/shm

这样再启动DB，就OK了。
> df -h | grep shm
tmpfs                3.0G  1.2G  1.9G  40% /dev/shm

再执行ls -l /dev/shm

total 1237888
-rw-r----- 1 oracle oinstall 16777216 Oct 19 16:20 ora_orcl_32768_0
-rw-r----- 1 oracle oinstall       0 Oct 19 16:20 ora_orcl_32768_1
-rw-r----- 1 oracle oinstall       0 Oct 19 16:20 ora_orcl_32768_10
-rw-r----- 1 oracle oinstall 16777216 Oct 19 16:20 ora_orcl_32768_100
-rw-r----- 1 oracle oinstall 16777216 Oct 19 16:20 ora_orcl_32768_101
-rw-r----- 1 oracle oinstall 16777216 Oct 19 16:20 ora_orcl_32768_102
-rw-r----- 1 oracle oinstall 16777216 Oct 19 16:20 ora_orcl_32768_103
-rw-r----- 1 oracle oinstall 16777216 Oct 19 16:20 ora_orcl_32768_104
-rw-r----- 1 oracle oinstall 16777216 Oct 19 16:20 ora_orcl_32768_105
-rw-r----- 1 oracle oinstall 16777216 Oct 19 16:20 ora_orcl_32768_106
-rw-r----- 1 oracle oinstall 16777216 Oct 19 16:20 ora_orcl_32768_107

[ 本帖最后由 lfree 于 2009-10-19 16:35 编辑 ]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/267265/viewspace-616894/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/267265/viewspace-616894/