ORA-00845: MEMORY_TARGET not supported on this system報錯解決
11g資料庫修改pfile引數後啟動資料庫報錯ora-00845
SQL> startup
ORA-00845: MEMORY_TARGET not supported on this system
查詢資料後發現問題如下,見metalinikID 460506.1
在oracle 11g中新增的記憶體自動管理的引數MEMORY_TARGET,它能自動調整SGA和PGA,這個特性需要用到/dev/shm共享檔案系統,而且要求/dev/shm必須大於MEMORY_TARGET,如果/dev/shm比MEMORY_TARGET小就會報錯
解決方案
1.初始化引數MEMORY_TARGET或MEMORY_MAX_TARGET不能大於共享記憶體(/dev/shm),為了解決這個問題,可以增大/dev/shm
如:
# mount -t tmpfs shmfs -o size=2g /dev/shm
2.為了確保作業系統重啟之後能生效,需要修改/etc/fstab檔案
shmfs /dev/shm tmpfs size=2g 0
3.如果/dev/shm沒有掛載也會報上面的錯,所認需要確保已經掛載
[root@pxboracle ~]#$ df -h | grep tmpfs
tmpfs /dev/shm tmpfs defaults,size=1024M 0 0
[root@pxboracle ~]#mount -o remount,size=2G /dev/shm
[root@pxboracle ~]# cat /etc/fstab | grep tmpfs
tmpfs /dev/shm tmpfs defaults,size=1g 0 0
[root@pxboracle ~]# vi /etc/fstab
[root@pxboracle ~]# df -h|grep shm
tmpfs 2G 0 2G 0% /dev/shm
SQL> startup
ORACLE instance started.
Total System Global Area 9420095488 bytes
Fixed Size 2236248 bytes
Variable Size 2315255976 bytes
Database Buffers 7046430720 bytes
Redo Buffers 56172544 bytes
Database mounted.
Database opened.
SQL> exit
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/12798004/viewspace-1144633/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORA-00845 MEMORY_TARGET not supported on this system報錯解決
- Oracle報錯:ORA-00845: MEMORY_TARGET not supported on this systemOracle
- Oracle 11g報錯"ORA-00845: MEMORY_TARGET not supported on this system"Oracle
- oracle 11g報錯ORA-00845: MEMORY_TARGET not supported on this systemOracle
- 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”不完全解決之道
- ORA-00845: MEMORY_TARGET not supported on this system 失敗的解決方案
- startup ORA-00845: MEMORY_TARGET not supported on this system
- ORA-00845: MEMORY_TARGET not supported on this system - Linux ServersLinuxServer
- Oracle11g啟動報:ORA-00845: MEMORY_TARGET not supported on this systemOracle
- Oracle11g ORA-00845: MEMORY_TARGET not supported on this systemOracle
- 解決辦法:ORA-00845: MEMORY_TARGET not supported on thi
- ORA-00845 MEMORY_TARGET not supported
- MEMORY_TARGET not supported on this system
- HugePages與AMM不相容:ORA-00845: MEMORY_TARGET not supported on this system
- MEMORY_TARGET not supported on this system for linuxLinux
- linux下/dev/shm的大小引發ORA-00845: MEMORY_TARGET not supported on this systemLinuxdev
- ORA-00845 : MEMORY_TARGET not supported on this system(調大資料庫記憶體無法啟動)大資料資料庫記憶體
- 解決報錯error the @annotation pointcut expression is only supported at Java 5ErrorExpressJava
- ORA-00845: MEMORY_TARGET
- memory_max_target/memory_target設定過大報ORA-00845錯誤
- hive報system:java.io.tmpdir錯誤解決HiveJava
- ORA-00845的錯誤與解決方案
- /system/bin/sh: screenrecord: inaccessible or not found 報錯解決方案
- ORACLE11G解決ORA-00845錯誤Oracle
- ORA-00845 memory_target needs larger /dev/shmdev
- ORA-00845 解決
- 如何解決ORA-00845錯誤
- 解決The given version [xx] is not supported, only version 1 to 10 is supported in this buildUI
- 解決Linux上11g的ORA-00845錯誤Linux
- 解決 Lumen 中 client charset is not supportedclient
- mybatis報錯解決MyBatis
- Mac新建資料夾報錯,mkdir():Operation not supportedMac
- 解決fitz模組報錯
- SS報錯的解決
- 解決eslint報錯EsLint
- iText中文,報錯解決