Oracle 11gR2 RAC ORA-00845 MEMORY_TARGET not supported on th-mysql教程-PHP中文网

首页

数据库

mysql教程

Oracle 11gR2 RAC ORA-00845 MEMORY_TARGET not supported on th

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 07, 2016 pm 05:11 PM

公司刚上线一套Oracle 11gR2 的RAC。将MEMORY_TARGET内存设置为12G后，启动的时候报了错误：ORA-00845: MEMORY_TARGET not supp

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.

/dev/shm是一个临时文件系统（tmpfs) 。从/etc/fstab中mount支持标准的参数"size"，可以用size来增加或者减少在/dev/shm上的tmpfs大小.如果没有设置size，它的大小大于MEMORY_TARGET。

如果想立即生效，方法如下：

# umount tmpfs

# mount -t tmpfs shmfs -o size=14G /dev/shm

让以后每次重启OS 都自动mount，，修改文件 /etc/fstab 将tmpfs 修改成以下值：

tmpfs /dev/shm tmpfs defaults,size=14G 0 0

如果直接修改/etc/fstab，通过重启OS 也可以让参数生效。

注意：这个size 的大小需要设置为整数。

/dev/mapper/vg00-lv_root

20G 11G 7.7G 59% /

/dev/mapper/vg00-lv_home

97G 6.8G 86G 8% /home

/dev/sda1 97M 13M 80M 14% /boot

tmpfs 14G 0 14G 0% /dev/shm

Oracle 官网的说明：

ORA-00845 When Starting Up An 11g Instance With AMM Configured. [ID 460506.1]

Modified 18-FEB-2010 Type PROBLEM Status PUBLISHED

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 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 and used is 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.