/dev/shm应该设置多大Oracle 实例启动时才能不报ORA-00845
来源:互联网 发布:金融类软件测试 编辑:程序博客网 时间:2024/05/12 03:03
原文出处:http://blog.csdn.net/msdnchina/article/details/50901865
/dev/shm应该设置多大Oracle 实例启动时才能不报ORA-00845
来源于:ORA-00845 - Which value for /dev/shm is needed to startup database without ORA-00845 (文档 ID 1399209.1)
适用于:
Oracle Database - Standard Edition - Version 11.1.0.6 and later
Information in this document applies to any platform.
***Checked for relevance on 17-Jul-2015***
目标:
从Oracle database 11g开始, the Automatic Memory Management(AMM)特性需要更多的shared memory(/dev/shm)和文件描述符
Shared memory 的大小必须至少大于该台主机上每个Oracle Instance的 MEMORY_MAX_TARGET参数值和MEMORY_TARGET参数值。
如果MEMORY_MAX_TARGET参数或者MEMORY_TARGET参数被设置为了一个非零值,并且一个不正确的值被指定给了shared memory,这会导致Oracle instance启动失败:会报 ORA-00845 错误
在Linux系统中,如果操作系统系统的/dev/shm mount size 相对于Oracle SGA和PGA来说太小,你会遇到下面的错误:
- ORA-00845: MEMORY_TARGET not supported on this system.
这个错误的原因是不充足的/dev/shm分配。SGA 和PGA的总内存大小,即:在初始化参数中设置的MEMORY_TARGET 或者 MEMORY_MAX_TARGET,不能大于你的操作系统上的shared memory file system (/dev/shm)大小。
细节
The alert log will provide the expected value for /dev/shm.
- WARNING: You are trying to use the MEMORY_TARGET feature.
- This feature requires the /dev/shm file system to be mounted for at least 1073741824 bytes.
- /dev/shm is either not mounted or is mounted with available space less than this size.
- Please fix this so that MEMORY_TARGET can work as expected.
- Current available is 1049145344 and used is 430080 bytes.
- Ensure that the mount point is /dev/shm for this directory. memory_target needs larger /dev/shm
Here the alert log confirms:
- current size : 1049145344 bytes
- expected size: 1073741824 bytes (at least)
The current size of /dev/shm is also confirmed by the 'df' command -- Current value
- # df -k /dev/shm
- Filesystem 1K-blocks Used Available Use% Mounted on
- tmpfs 1024976 420 1024556 1% /dev/shm
To fix the current issue the solution would be to allocate at least 1073741824 bytes for /dev/shm.
- # mount -t tmpfs shmfs -o size=1073741824 /dev/shm
- # df -k /dev/shm
- Filesystem 1K-blocks Used Available Use% Mounted on
- shmfs 1048576 0 1048576 0% /dev/shm
To retain the value across machine startups, make sure that the /etc/fstab mount database contains a reference to this new value, like in:
- shmfs /dev/shm tmpfs size=1073741824 0
- /dev/shm应该设置多大Oracle 实例启动时才能不报ORA-00845
- 【翻译自mos文章】/dev/shm应该设置多大Oracle 实例启动时才能不报ORA-00845
- 【问题记录】数据库打不开 报ORA-00845错误 /dev/shm设置过小
- 初识/dev/shm & oracle
- Oracle启动报错:memory_target needs larger /dev/shm
- CentOS 下修改/dev/shm 大小解决ORA-00845
- ORA-000845 与 /dev/shm(tempfs)
- /dev/shm
- /dev/shm
- /dev/shm
- /dev/shm
- /dev/shm
- 新特性:/dev/shm对oracle 11g的影响
- Oracle 11g AMM: MEMORY_TARGET, MEMORY_MAX_TARGET and /dev/shm
- 新特性:/dev/shm对Oracle 11g的影响!
- Oracle SVG自动管理 修改/dev/shm大小
- 新特性:/dev/shm对Oracle 11g的影响
- 初识/dev/shm & oracle(转)
- iOS 左右两列按钮之间进行连线
- IOS9需要升级提升的点
- JSON的输出方式
- 电子商务网站商品推荐案例分析
- C++第六次实验—循环(实验)
- /dev/shm应该设置多大Oracle 实例启动时才能不报ORA-00845
- CodeForces 509B Painting Pebbles
- 0.1 Spark Streaming 实现思路与模块概述
- LeetCode 43. Multiply Strings(乘法)
- AfinalHttp的AjaxBack简单封装
- Java 连接hbase 进行简单操作
- C++第6次实验——项目一输出星号图
- 简谈快速排序
- 对象检测之行人检测(1)