ORA-00845 MEMORY_TARGET not supported

super_sky發表於2014-01-13

今天檢查一個測試的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 ~]#

然後再啟動資料庫,該問題解決。

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/11590946/viewspace-1069877/,如需轉載,請註明出處,否則將追究法律責任。

相關文章