ORA-00845: MEMORY_TARGET not supported on this system
来源:互联网 发布:java redis集群 编辑:程序博客网 时间:2024/06/05 19:56
在RHL6.6 的Oralce11204 :
修改内存参数的时候启动报错
SQL> startup
ORA-00845: MEMORY_TARGET not supported on this system
原因是oracle SGA的大小超过了系统shm的大小。
解决方案:修改shm的大小 .
建议修改shm等于操作系统内存大小
解决方案是自定义shm的大小,需要修改/etc/fstab文件:
[root@llmj-xedb-50-20 ~]# vi /etc/fstab
把文件中:
tmpfs /dev/shm tmpfs defaults 0 0
修改为:
tmpfs /dev/shm tmpfs defaults,size=30G 0 0
然后保存退出,重新挂载shm
[root@llmj-xedb-50-20 ~]# umount /dev/shm
[root@llmj-xedb-50-20 ~]# mount /dev/shm
查看shm大小
[root@llmj-xedb-50-20 ~]# df -h |grep shm
tmpfs 30G 1.7G 29G 6% /dev/shm
重新启动数据库,正常启动!
0 0
- ORA-00845: MEMORY_TARGET not supported on this system 错误解决方法!
- ORA-00845: MEMORY_TARGET not supported on this system - Linux Servers
- 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
- 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 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
- 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
- ORA-00845: MEMORY_TARGET not supported on this system
- ORA-00845: MEMORY_TARGET not supported on this system
- HDU 4821 String(字符串哈希)
- C++中运算符的优先级(供查阅)
- Maven、gradle、Ant、Eclipse IDE之间的关系
- 求连续子数组的最大和
- TortoiseSVN中分支和合并
- ORA-00845: MEMORY_TARGET not supported on this system
- [HDU 4135] Co-prime · 容斥原理
- iOS7之定制View Controller切换效果
- 动态规划——砝码称重
- 5-19 求链式线性表的倒数第K项 (20分)
- ActiveMQ入门实例
- jQuery中的$(window).load()与$(document).ready()
- java之静态初始化块
- 网站广告收入反正要发动群众的力量,来创造利润--小黄人软件