ORA-00845 MEMORY_TARGET not supported-优快云博客

今天检查一个测试的11gRAC，发现2节点数据库没有启动。使用集群命令启动报如下错误

[grid@rac-1 ~]$ srvctl start instance -d oratest -i oratest2
PRCR-1013 : Failed to start resource ora.oratest.db
PRCR-1064 : Failed to start resource ora.oratest.db on node rac-2
CRS-5017: The resource action "ora.oratest.db start" encountered the following error:
ORA-00845: MEMORY_TARGET not supported on this system
. For details refer to "(:CLSN00107:)" in "/u02/11.2.0/grid/log/rac-2/agent/crsd/oraagent_oracle/oraagent_oracle.log".

CRS-2674: Start of 'ora.oratest.db' on 'rac-2' failed

在节点使用startup启动也报同样的错误

ORA-00845: MEMORY_TARGET not supported on this system

检查alert log 发现如下问题

Mon Jan 13 00:57:21 2014
Adjusting the default value of parameter parallel_max_servers
from 160 to 135 due to the value of parameter processes (150)
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 4294967296 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 3976802304 and used is 208900096 bytes.
Ensure that the mount point is /dev/shm for this directory.
memory_target needs larger /dev/shm

检查/dev/shm

[root@rac-2 ~]# df -h
Filesystem            Size Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol01
                      992M 360M 582M 39% /
/dev/mapper/VolGroup00-LogVol04
                      3.9G 1.9G 1.9G 51% /usr
/dev/mapper/VolGroup00-LogVol06
                      3.9G 138M 3.6G   4% /opt
/dev/mapper/VolGroup00-LogVol03
                      992M   38M 903M   5% /tmp
/dev/mapper/VolGroup00-LogVol02
                      496M   29M 442M   7% /home
/dev/mapper/VolGroup00-LogVol05
                      2.0G 160M 1.7G   9% /var
/dev/sda1              99M   13M   82M 14% /boot
tmpfs                 3.9G 200M 3.8G   5% /dev/shm
/dev/mapper/VolGroup00-u02
                       29G 8.9G   19G 33% /u02
[root@rac-2 ~]#

检查1节点

[root@rac-1 ~]# df -h
Filesystem            Size Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol01
                      992M 330M 612M 35% /
/dev/mapper/VolGroup00-LogVol04
                      3.9G 1.9G 1.8G 52% /usr
/dev/mapper/VolGroup00-LogVol06
                      3.9G 138M 3.6G   4% /opt
/dev/mapper/VolGroup00-LogVol03
                      992M   39M 903M   5% /tmp
/dev/mapper/VolGroup00-LogVol02
                      496M   57M 414M 13% /home
/dev/mapper/VolGroup00-LogVol05
                      2.0G 210M 1.7G 12% /var
/dev/sda1              99M   13M   82M 14% /boot
tmpfs                 5.0G 2.6G 2.5G 51% /dev/shm
/dev/mapper/VolGroup00-u02
                       29G   12G   16G 43% /u02
tmpfs                 5.0G 2.6G 2.5G 51% /dev/shm

看来肯定是tmpfs的问题了

重新挂载一下。

mount tmpfs /dev/shm -t tmpfs -o size=5120M

[root@rac-2 ~]# df -h
Filesystem            Size Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol01
                      992M 360M 582M 39% /
/dev/mapper/VolGroup00-LogVol04
                      3.9G 1.9G 1.9G 51% /usr
/dev/mapper/VolGroup00-LogVol06
                      3.9G 138M 3.6G   4% /opt
/dev/mapper/VolGroup00-LogVol03
                      992M   38M 903M   5% /tmp
/dev/mapper/VolGroup00-LogVol02
                      496M   29M 442M   7% /home
/dev/mapper/VolGroup00-LogVol05
                      2.0G 160M 1.7G   9% /var
/dev/sda1              99M   13M   82M 14% /boot
tmpfs                 5.0G     0 5.0G   0% /dev/shm
/dev/mapper/VolGroup00-u02
                       29G 8.9G   19G 33% /u02
tmpfs                 5.0G     0 5.0G   0% /dev/shm
[root@rac-2 ~]#