ORA-00845: MEMORY_TARGET not supported on this system

oracle 11.2.01+linux5.5

SQL>startup 

ORA-00845: MEMORY_TARGET not supported on this system

alert日志：

Wed Jun 05 23:17:44 2013
Starting ORACLE instance (normal)
WARNING: You are trying to use the MEMORY_TARGET feature. This feature requires the /dev/shm file system to be mounted for at least 943718400 bytes. /dev/shm is either not mounted or is mounted with available space less than this size. Please fix this so that MEMORY_TARGET can work as expected. Current available is 901324800 and used is 161312768 bytes. Ensure that the mount point is /dev/shm for this directory.
memory_target needs larger /dev/shm

出现问题的原因：设置了memory_target 的大小大于 /dev/shm 文件系统的大小

解决办法1：将memory_target的值减小，vi  pfile文件 ，startup pfile='';还是报同样的错

解决方法2：增大/dev/shm大小为2G

[root@rac2 ~]# vi /etc/fstab
/dev/VolGroup00/LogVol00 /                       ext3    defaults        1 1
LABEL=/boot             /boot                   ext3    defaults        1 2
#tmpfs                   /dev/shm                tmpfs   defaults        0 0
tmpfs                    /dev/shm                tmpfs    defaults,size=2048M  0 0
devpts                  /dev/pts                devpts  gid=5,mode=620  0 0
sysfs                   /sys                    sysfs   defaults        0 0
proc                    /proc                   proc    defaults        0 0
/dev/VolGroup00/LogVol01 swap                    swap    defaults        0 0

重新挂载 /dev/shm

[root@rac2 ~]# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
                       35G   25G  8.3G  75% /
/dev/sda1              99M   16M   79M  17% /boot
[root@rac2 ~]# umount /dev/shm
[root@rac2 ~]# mount /dev/shm
[root@rac2 ~]# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
                       35G   25G  8.3G  75% /
/dev/sda1              99M   16M   79M  17% /boot
tmpfs                 2.0G     0  2.0G   0% /dev/shm
tmpfs                 2.0G     0  2.0G   0% /dev/shm
tmpfs                 2.0G     0  2.0G   0% /dev/shm
[root@rac2 ~]#

小插曲：挂载了之后发现 出现三个 tmpfs 还有待研究~~

就直接重启：

[root@rac2 ~]# reboot

Broadcast message from root (pts/1) (Wed Jun  5 23:43:09 2013):

The system is going down for reboot NOW!
[root@rac2 ~]# Last login: Wed Jun  5 19:38:06 2013 from 192.168.15.88
[root@rac2 ~]# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
                       35G   25G  8.3G  75% /
/dev/sda1              99M   16M   79M  17% /boot
tmpfs                 2.0G  154M  1.9G   8% /dev/shm
 恢复正常！

启动数据库：

[oracle@rac2 ~]$ export ORACLE_SID=test2
[oracle@rac2 ~]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Wed Jun 5 23:48:22 2013

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

SQL> conn /as sysdba
Connected.
SQL> create pfile from spfile;

File created.
正常~

重新创建pfile，以免spfile出问题了是可以用

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

转载于:http://blog.itpub.net/28380626/viewspace-763092/