公司刚上线一套Oracle 11gR2的RAC。将MEMORY_TARGET内存设置为12G后,启动的时候报了错误:
ORA-00845: MEMORY_TARGET not supported on this system
00845, 00000, "MEMORY_TARGET not supported on this system"
// *Cause: The MEMORY_TARGET parameter was not supported on this operating system or /dev/shm was not sized correctly on Linux.
// *Action: Refer to documentation for a list of supported operating systems. Or, size /dev/shm to be at least the SGA_MAX_SIZE on each Oracle instance running on the system.
在Oracle 11g里,通过MEMORY_TARGET参数自动管理SGA和PGA。但是在Oracle 11gR2里如果MEMORY_TARGET参数值设定的过大,可能就会出现这个错误。
解决方法:增加/dev/shm, /dev/shm通常用做共享内存。
/dev/shm是一个临时文件系统(tmpfs)。从/etc/fstab中mount支持标准的参数"size",可以用size来增加或者减少在/dev/shm上的tmpfs大小.如果没有设置size,它的大小是系统RAM的一半。
修改文件/etc/fstab将tmpfs修改成以下值:
tmpfs/dev/shmtmpfsdefaults,size=14G0 0
umount /dev/shm
mount /dev/shm
df -h在查查修改后的/dev/shm的大小
文件系统容量已用可用已用%挂载点
/dev/mapper/vg00-lv_root
20G11G7.7G59% /
/dev/mapper/vg00-lv_home
97G6.8G86G8% /home
/dev/sda197M13M80M14% /boot
tmpfs14G014G0% /dev/shm
Oracle官网的说明:
ORA-00845 When Starting Up An 11g Instance With AMM Configured. [ID 460506.1]
|
|
|
Modified18-FEB-2010TypePROBLEMStatusPUBLISHED
|
|
In this Document
Symptoms
Changes
Cause
Solution
References
Applies to:
Oracle Server - Enterprise Edition - Version: 11.1.0.6 to 11.2.0.2.0 - Release: 11.1 to 11.2
Linux x86
Linux x86-64
Symptoms
On a Linux system, trying to start up an 11g instance could fail with the following error:
ORA-845: MEMORY_TARGET not supported on this system
In the alert log, you could or could not see the below messages:
ORA-04031 errors
OR
Starting ORACLE instance (normal)
WARNING: You are trying to use the MEMORY_TARGET feature.
This feature requires the /dev/shm file system to be mounted for at
Least <size> bytes.The /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 <size> and used is <size> bytes.memory_target needs larger /dev/shm
If ORA-04031 is seen in the alert log, sometimes you can not establish new connections due to this problem.
Changes
Installed 11g, or created a new database on 11g and is starting to use the AMM (Automatic Memory Management) feature.
Cause
This feature requires the /dev/shm file system to be mounted for at least %llu bytes.
/dev/shm is either not mounted or is mounted with available space less than this size.
Explanation:
AMM (Automatic Memory Management) is a new feature in 11 which manages both SGA and PGA.
MEMORY_TARGET is used instead of SGA_TARGET and MEMORY_MAX_TARGET is used instead of SGA_MAX_SIZE (defaults to MEMORY_TARGET ).
It uses /dev/shm on Linux. If max_target set over /dev/shm size, you get the error messages.
Solution
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. For example:
# mount -t tmpfs shmfs -o size=7g /dev/shm
Also, to make this change persistent across system restarts, add an entry in /etc/fstab similar to the following:
shmfs /dev/shm tmpfs size=7g 0
2. This error may also occur if /dev/shm is not properly mounted. Make sure your df output is similar to the following:
$ df -k
Filesystem 1K-blocks Used Available Use% Mounted on
...
shmfs 6291456 832356 5459100 14% /dev/shm
3. 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.
HugePages and Oracle Database 11g Automatic Memory Management (AMM) on Linux [ID 749851.1]
|
|
|
Modified05-NOV-2010TypeBULLETINStatusPUBLISHED
|
|
In this Document
Purpose
Scope
and Application
HugePages
and Oracle Database 11g Automatic Memory Management (AMM) on Linux
References
Applies to:
Oracle Server - Enterprise Edition - Version: 11.1.0.6 and later[Release: 11.1 and later ]
Linux OS - Version: 2.6andlater ]
Linux x86
IBM: Linux on System z
IBM: Linux on POWER Systems
IBM S/390 Based Linux (31-bit)
Linux x86-64
Linux Itanium
Purpose
This document discusses the interoperability of the Automatic Memory Management (AMM) feature introduced by Oracle DB 11g and the HugePages (HugeTLB) feature of the Linux OS kernel.
Scope and Application
This document is to be used by Linux system administrators and Oracle database administrators that work with Oracle Database Server 11g on Linux Operating System.
HugePages and Oracle Database 11g Automatic Memory Management (AMM) on Linux
The 11g AMM feature is enabled by the MEMORY_TARGET / MEMORY_MAX_TARGET instance initialization parameters (seeNote 460506.1for further information). That is also the
case with a default database instance created using Database Configuration Assistant (DBCA).
With AMM all SGA memory is allocated by creating files under /dev/shm. When Oracle DB does SGA allocations that way HugePages are not reserved/used. The use of AMM is absolutely incompatible with HugePages.
Please also note that ramfs (instead of tmpfs mount over /dev/shm) is not supported for AMM at all. With AMM the Oracle database needs to grow and reduce the size of SGA dynamically. This is not possible with ramfs where it possible and supported with tmpfs
(which is the default for the OS installation).
If you want to use HugePages make sure that both MEMORY_TARGET / MEMORY_MAX_TARGET initialization parameters are disabled (set to 0) for the database instance.(See alsoOracle�Database Administrator's Guide 11g)
References
NOTE:460506.1- ORA-00845 When Starting Up An 11g Instance With AMM Configured.
Related
Products
- Oracle Database Products > Oracle Database > Oracle Database > Oracle Server - Enterprise Edition
- Unbreakable Linux and Virtualization > Unbreakable Linux > Operating System > Linux OS
Keywords
HUGETLB; HUGEPAGES; DATABASE CONFIGURATION ASSISTANT; DBCA
|
|
------------------------------------------------------------------------------
分享到:
相关推荐
rhel 6中搭建oracle 11gr2 rac环境。
Oracle 11gR2 RAC + ASM on AIX-6.1安装指导手册
oracle11gR2-Rac-for-linux安装手册
oracle linux 6.4上安装部署 oracle RAC 11G R2,oracle linux上安装oracle是最简便的。
错误描述:oracle远程连接服务器出现 ORA-12170 TNS:连接超时 错误检查:有很多是oracle自身安装的问题,但是我这里服务器配置正常,监听正常,服务正常,远程可以ping通服务器。 这里主要是防火墙问题,解决办法: ...
Oracle_11gR2_RAC_+_ASM_on_AIX-6.1安装指导手册
deploying-oracle-11gr2-rac-on-rhel6.pdf
【Oracle-RAC】Linux--Oracle-11g-R2-RAC-安装配置详细过程V3.0(图文并茂)
《构建最高可用Oracle数据库系统:Oracle 11gR2 RAC管理、维护与性能优化》从硬件和软件两个维度系统且全面地讲解了Oracle 11g R2 RAC的架构、工作原理、管理及维护的系统理论和方法,以及性能优化的技巧和最佳实践...
Oracle 11.2.0.3 单实例 迁移到 11gR2 RAC 案例-- 使用RMAN 异机恢复 注:文档打开密码见压缩包注释
构建最高可用Oracle数据库系统 Oracle 11gR2 RAC管理、维护与性能优化.part1.rar
Oracle_11gR2_RAC_+_ASM_on_AIX-6.1安装指导手册.pdf
某客户需要将一套Oracle 10gR2 双节点RAC 生产数据库升级至Oracle 11gR2 RAC,所以便有了本系列实战的教程。 为更贴切还原生产过程中的实际操作,本系列教程一个分两大部分: 第一部分已发 一步一步在Linux上部署...
客户端进行连接的时候,系统不定期出现ora-12520,ora-12516的连接问题, 问题解决方案建议: 1、增加process和session的连接数。 2、检查连接的应用,是不是有没有释放的连接。 3、将修改参数local_listener中的vip为...
利用VMware_Workstation11安装Oracle_11gR2_RAC,ASM
第1章 认识Oracle RAC 1.1 RAC产生的背景 1.2 RAC体系结构 1.2.1整体结构 1.2.2物理层次结构 1.2.3逻辑层次结构 1.3 RAC的特点 1.3.1双机并行 1.3.2高可用性 1.3.3易伸缩性 1.3.4低成本 1.3.5高吞吐量 ...
oracle 11g r2 rac setup and show
浦东机场货运站核心数据库升级至Oracle RAC 11gR2。操作系统采用RedHat Enterprice Linux 6.3 x64,操作系统平台为x86-64。 Oracle网格管理器和数据库安装版本为11.2.0.3.,并且升级GI和DB至PSU 6,数据共享存储采用...
ORACLE_10gR2_RAC升级ORACLE_10gR2_RAC升级