Oracle 11gR2 RAC ORA-00845 MEMORY_TARGET not supported on this system 解决方法(二)

2014-11-24 09:11:52 · 作者: · 浏览: 2
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]

Modified 05-NOV-2010 Type BULLETIN Status PUBLISHED
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.6 and later ]
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 (see Note 460506.1 for 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 also Oracle 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




------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware