ORA-00845: MEMORY_TARGET
新裝備庫一臺Oracle 11g的資料庫,SGA設5G,MEMORY_TARGET 6G,誰知報了個 ORA-00845
SQL> startup
ORA-00845: MEMORY_TARGET not supported on this system
來自Oracle的官方解析是:
Starting with Oracle Database 11g, the Automatic Memory Management feature requires more shared memory (/dev/shm)and file descriptors. The size of the shared memory should be at least the greater of MEMORY_MAX_TARGET and MEMORY_TARGET for each Oracle instance on the computer. If MEMORY_MAX_TARGET or MEMORY_TARGET is set to a non zero value, and an incorrect size is assigned to the shared memory, it will result in an ORA-00845 error at startup.
簡單來說就是 MEMORY_MAX_TARGET 的設定不能超過 /dev/shm 的大小:
[oracle@mi14 ~]$ df -h | grep shm
tmpfs 5.9G 80K 5.9G 1% /dev/shm
[oracle@mi14 ~]$ df -h
Filesystem Size Used Avail Use% Mounted on
/dev/vda1 18G 3.8G 14G 23% /
tmpfs 5.9G 80K 5.9G 1% /dev/shm
/dev/vdb 477G 8.7G 444G 2% /data
[oracle@mi14 ~]$ cat /etc/fstab | grep tmpfs
tmpfs /dev/shm tmpfs defaults 0 0
還真是撞到這個槍口上了:
馬上把它加大:
[root@mi14 ~]# vi /etc/fstab
tmpfs /dev/shm tmpfs defaults,size=7G 0 0
現在可以透過重啟使這個配置生效,也可以透過重新掛載來修改其大小:
[root@mi14 ~]# mount -o remount /dev/shm
[root@mi14 ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/vda1 18G 3.8G 14G 23% /
tmpfs 7.0G 80K 7.0G 1% /dev/shm
/dev/vdb 477G 8.7G 444G 2% /data
再次啟動資料庫,沒有報錯了。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29819001/viewspace-1409600/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORA-00845 MEMORY_TARGET not supported
- 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
- ORA-00845 memory_target needs larger /dev/shmdev
- 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_max_target/memory_target設定過大報ORA-00845錯誤
- linux下/dev/shm的大小引發ORA-00845: MEMORY_TARGET not supported on this systemLinuxdev
- ORA-00845 : MEMORY_TARGET not supported on this system(調大資料庫記憶體無法啟動)大資料資料庫記憶體
- Linux下安裝Oracle11g , MEMORY_TARGET(AMM)小於/dev/shm處理(ORA-00845)LinuxOracledev
- MEMORY_TARGET not supported on this system
- ORA-00845 解決
- SGA PGA MEMORY_TARGET 關係
- MEMORY_TARGET not supported on this system for linuxLinux
- ORA-00845 錯誤處理
- Oracle11g修改MEMORY_TARGETOracle
- 如何解決ORA-00845錯誤
- Oracle 11gR2 RAC ORA-00845Oracle
- ORA-00845的錯誤與解決方案
- ORA-00838: Specified value of MEMORY_TARGET is too small
- ORACLE11G解決ORA-00845錯誤Oracle
- 11g的MEMORY_TARGET和MEMORY_MAX_TARGET
- memory_target、sga_target、pga_target的設定
- oracle 12C RAC 啟動報錯 ORA-00845Oracle
- 【轉】Oracle 11gR2 RAC ORA-00845 解決方法Oracle
- 解決Linux上11g的ORA-00845錯誤Linux
- oracle 11g的新特性:memory_target的一些解析Oracle