ITPub博客

首页 > 数据库 > Oracle > oracle11g要求在操作系统层设定共享内存/dev/shm,且大于MEMORY_TARGET

oracle11g要求在操作系统层设定共享内存/dev/shm,且大于MEMORY_TARGET

原创 Oracle 作者:xiaoli 时间:2013-02-16 16:05:47 0 删除 编辑

oracle11gR2:

SQL> startup nomount
ORA-00845: MEMORY_TARGET not supported on this system

告警日志:

WARNING: You are trying to use the MEMORY_TARGET feature. This feature requires the /dev/shm file system to be mounted for at least 788529152 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 517730304 and used is 464449536 bytes. Ensure that the mount point is /dev/shm for this directory.
memory_target needs larger /dev/shm

google:

11g特性的内存管理需要用到/dev/shm共享文件系统,且要求/dev/shm大于 TARGET_MEMORY,否则会报错。

[root@mosdb ~]# mount -t tmpfs shmfs -o size=3g /dev/shm
[root@mosdb ~]#

写入到fstab中:

vi /etc/fstab 增加如下:

shm /dev/shm tmpfs size=2g 0 0

#mount shm

[root@mosdb etc]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
37G 17G 18G 49% /
/dev/sda1 99M 13M 81M 14% /boot
shm 2.0G 0 2.0G 0% /dev/shm

在启动数据库:(可见内存加载成功)
SQL> startup nomount;
ORACLE instance started.

Total System Global Area 786759680 bytes
Fixed Size 1339400 bytes
Variable Size 528486392 bytes
Database Buffers 251658240 bytes
Redo Buffers 5275648 bytes
SQL>

[@more@]

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/60144/viewspace-1060206/ ,如需转载,请注明出处,否则将追究法律责任。

下一篇: 没有了~
请登录后发表评论 登录
全部评论

注册时间:2008-09-01

  • 博文量
    68
  • 访问量
    207163