ORA-00845 MEMORY_TARGET not supported on this system
来源:互联网 发布:pe中如何查看mac地址 编辑:程序博客网 时间:2024/05/22 12:09
数据库启用了AMM,动态调整SGA和PGA。
启动库时候发现,系统提示ORA-00845: MEMORY_TARGET not supported on this system
检查数据库参数和系统内存,,发现都是够用的
如果是系统内存不够用,肯定是要修改memory_target。
但显然不是,那么根据官方文档就只能是另外一个原因了,shm大小不足。
通过以下命令:mount-o size=1500M -o nr_inodes=1000000 -o noatime,nodiratime -o remount /dev/shm多次调整后终于启动成功:
这个命令只是临时修改的,要永久修改得需要修改/etc/fstab
tmpfs /dev/shmtmpfs defaults,size=1.9G 0 0
#mount-o remount /dev/shm
不过相信企业的数据库也不是经常起停的,不容易遭遇这个问题。当然解决这个问题的方案肯定是多样的,调整memory_target的值,相信也是极好的。不过我觉得最简单的还是修改下shm大小。
原因探析:因为Oracle的amm技术就是用到的shm,所以shm大小至少要大于memory_target。。。。。然后shm默认为内存大小的一半,所以调整memory_target or memory_max_target的时候一定要注意调整/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
- Android--将Uri从file://改成content://
- Linux下which、whereis、locate、find 命令的区别
- mysql权限管理
- 新开始
- 专利查询网站(免费)
- ORA-00845 MEMORY_TARGET not supported on this system
- mysql存储引擎简析
- GDI+
- JAVA实现图结构
- ios中各种插件的使用
- 关于Mysql中实现随机查询
- Java堆、栈和常量池以及相关String的详细讲解
- 求二次、三次贝塞尔曲线的某个时间的位置及切线方向
- Linux系统挂载存储只读改成读写