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 ~]#
然後再啟動資料庫,該問題解決。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/11590946/viewspace-1069877/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORA-00845 MEMORY_TARGET not supported on this system
- ORA-00845: MEMORY_TARGET not supported on this system
- startup ORA-00845: MEMORY_TARGET not supported on this system
- Oracle報錯:ORA-00845: MEMORY_TARGET not supported on this systemOracle
- ORA-00845: MEMORY_TARGET not supported on this system - Linux ServersLinuxServer
- 解決辦法:ORA-00845: MEMORY_TARGET not supported on thi
- ORA-00845: MEMORY_TARGET not supported on this system報錯解決
- Oracle11g ORA-00845: MEMORY_TARGET not supported on this systemOracle
- ORA-00845 MEMORY_TARGET not supported on this system報錯解決
- Oracle 11g報錯"ORA-00845: MEMORY_TARGET not supported on this system"Oracle
- oracle 11g報錯ORA-00845: MEMORY_TARGET not supported on this systemOracle
- HugePages與AMM不相容:ORA-00845: MEMORY_TARGET not supported on this system
- “ORA-00845: MEMORY_TARGET not supported on this system”不完全解決之道
- ORA-00845: MEMORY_TARGET not supported on this system 失敗的解決方案
- Oracle11g啟動報:ORA-00845: MEMORY_TARGET not supported on this systemOracle
- MEMORY_TARGET not supported on this system
- linux下/dev/shm的大小引發ORA-00845: MEMORY_TARGET not supported on this systemLinuxdev
- ORA-00845: MEMORY_TARGET
- MEMORY_TARGET not supported on this system for linuxLinux
- ORA-00845 : MEMORY_TARGET not supported on this system(調大資料庫記憶體無法啟動)大資料資料庫記憶體
- ORA-00845 memory_target needs larger /dev/shmdev
- memory_max_target/memory_target設定過大報ORA-00845錯誤
- Linux下安裝Oracle11g , MEMORY_TARGET(AMM)小於/dev/shm處理(ORA-00845)LinuxOracledev
- 解決The given version [xx] is not supported, only version 1 to 10 is supported in this buildUI
- ORA-00845 解決
- GoldenGate - What is supported and what is not ....Go
- SGA PGA MEMORY_TARGET 關係
- let definitions are not supported by current javascript versionJavaScript
- Project facet Java version 1.8 is not supportedProjectJava
- The ENU localization is not supported by this SQL Server mediaSQLServer
- KSQLException: The authentication type 10 is not supported.SQLException
- ORA-00845 錯誤處理
- Oracle11g修改MEMORY_TARGETOracle
- 如何解決ORA-00845錯誤
- 解決 Lumen 中 client charset is not supportedclient
- lambda expressions are not supported at this language level intellijExpressIntelliJ
- Project facet Java version 1.7 is not supported.ProjectJava
- Oracle 11gR2 RAC ORA-00845Oracle