实例启动时报ORA-00845的解决方法
来源:互联网 发布:linux怎么ping大包 编辑:程序博客网 时间:2024/06/10 03:46
在Oracle 11g中如果采用AMM内存管理,那么当MEMORY_TARGET的值大于/dev/shm的时候,就会报ORA-00845: MEMORY_TARGET not supported on this system错误,解决办法增加/dev/shm大小,在redhat系列系统中,/dev/shm的默认值是系统总内存的一半
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.
5、解决问题建议
5.1. If you are installing Oracle 11g on a Linux system, note that Memory Size (SGA and PGA), which sets the initialization parameter MEMORY_TARGET or MEMORY_MAX_TARGET, cannot be greater than the shared memory filesystem (/dev/shm) on your operating system. To resolve the current error, increase the /dev/shm file size.
5.2. If configuring AMM is not possible due to lack of space on /dev/shm mount point, you can configure ASMM instead of AMM, i.e. set SGA_TARGET, SGA_MAX_SIZE and PGA_AGGREGATE_TARGET instead of MEMORY_TARGET.
- 实例启动时报ORA-00845的解决方法
- 实例启动时报ORA-00845的解决方法
- windows 下的oracle实例启动时报错ora-28056
- Oracle建立实例时报【ORA-12638: 身份证明检索失败解决方法】错误的解决方法
- oracle 实例启动时报 ORA-01157,ORA-01110解决
- 11g R2 rac 启动时报错ora-17503的解决方法
- Oracle11g 启动时报错:ORA-00845
- 一个数据库实例在启动时报ORA-27140
- startup mount 时报ORA-12514错误的解决方法
- startup mount时报ORA-12514错误的解决方法
- oracle数据库启动时报ORA-03113的处理
- Eclipse启动时报错解决方法
- Tomcat启动时报错java.io.EOFException的解决方法
- Ehcache项目启动时报Update check failed异常的解决方法
- 关于oracle数据库启动报ORA-01122,ORA-01110,ORA-01203错误的解决方法
- linux下启动应用时报ORA-12505,连接的SID问题
- 关于启动数据库后提示ora-12505的解决方法
- 在启动DB时报错ORA-27154 ORA-27300 ORA-27301 ORA-27302
- path
- 基于BindingSource的WinForm开发
- zoj 3725 Painting Storages
- windows命令相关
- CoreText 使用教程
- 实例启动时报ORA-00845的解决方法
- Could not load file or assembly 'XXXXXXXX' or one of its dependencies. 试图加载格式不正确的程
- 2013C++第10周项目——循环结构程序设计
- GCD一些总结
- linux下 tcpdump 抓包工具
- redis.conf 配置参数说明
- Hadoop第一个程序,利用API向HDFS中写入数据
- 【MySQL】MySQL常用操作集合
- gcc以及Qt的DLL文件调用之总结