【ORACLE】ORA-00845 MEMORY_TARGET not supported on this system
来源:互联网 发布:sql for循环 编辑:程序博客网 时间:2024/04/26 05:06
SQL> startupORA-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=7g /dev/shm2.为了确保操作系统重启之后能生效,需要修改/etc/fstab文件shmfs /dev/shm tmpfs size=7g 03.如果/dev/shm没有挂载也会报上面的错,所认需要确保已经挂载oracle@aaaprod-db ~]$ df -h……tmpfs 16G 8.9G 7.2G 56% /dev/shm……下面为一次操作的记录[root@aaaprod-db ~]# cat /etc/fstab | grep tmpfstmpfs /dev/shm tmpfs defaults,size=8g 0 0[root@aaaprod-db ~]#[root@aaaprod-db ~]# mount -o remount,size=16G /dev/shm[root@aaaprod-db ~]#[root@aaaprod-db ~]# cat /etc/fstab | grep tmpfstmpfs /dev/shm tmpfs defaults,size=8g 0 0[root@aaaprod-db ~]# vi /etc/fstab/dev/rootvg/LogVol02 / ext3 defaults 1 1/dev/rootvg/LogVol01 /tmp ext3 defaults 1 2/dev/rootvg/lvol0 /ebao ext3 defaults 1 2/dev/rootvg/lvol1 /backup ext3 defaults 1 2LABEL=/boot /boot ext3 defaults 1 2tmpfs /dev/shm tmpfs defaults,size=16g 0 0devpts /dev/pts devpts gid=5,mode=620 0 0sysfs /sys sysfs defaults 0 0proc /proc proc defaults 0 0/dev/rootvg/LogVol00 swap swap defaults 0 0"/etc/fstab" 10L, 769C written[root@aaaprod-db ~]# df -h|grep shmtmpfs 16G 0 16G 0% /dev/shmSQL> startupORACLE instance started.Total System Global Area 9420095488 bytesFixed Size 2236248 bytesVariable Size 2315255976 bytesDatabase Buffers 7046430720 bytesRedo Buffers 56172544 bytesDatabase mounted.Database opened.SQL> exit
0 0
- [Oracle]ORA-00845: MEMORY_TARGET not supported on this system解决
- [Oracle] ORA-00845: MEMORY_TARGET not supported on this system
- 【ORACLE】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 - 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
- js构造函数
- Bootstrap学习-CSS样式
- 元素的隐藏和显示(v-show指令)
- Android ZXing(二维码)库的全面使用解析
- maven整合springmvvc项目遇到的一些问题及解决方
- 【ORACLE】ORA-00845 MEMORY_TARGET not supported on this system
- Java进阶----EL表达式和JSTL
- How do I force a query to use bind-aware cursor sharing?
- Qt连接Sqlserv数据库设置端口号问题
- 寻找手机(本人自编题)
- PAT_A 1023. Have Fun with Numbers (20)
- Python实现冒泡排序
- Google要用机器学习检测恶意评论
- 深入理解C语言指针(四)之 函数