oerr ora 000845解决方法是扩大/dev/shm空间

iyuytre

打开虚拟机发现实例起不来

[iyunv@wenxi ~]# su - oracle
sq[oracle@wenxi ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Tue Aug 2 14:59:54 2016

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to an idle instance.

SYS@ odb>startup nomout
SP2-0714: invalid combination of STARTUP options



[oracle@wenxi ~]$ oerr ora 000845
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，这个特性需要用到/dev/shm共享文件系统，而且要求/dev/shm必须大于MEMORY_TARGET，如果/dev/shm比MEMORY_TARGET小就会报错

[oracle@wenxi ~]$ df -h /dev/shm/
Filesystem      Size  Used Avail Use% Mounted on
tmpfs           1.5G   72K  1.5G   1% /dev/shm


*.memory_target=1603272704     约为1.6G

解决办法是加大/dev/shm的空间

[oracle@wenxi ~]$  cat /etc/fstab | grep tmpfs
tmpfs                   /dev/shm                tmpfs   defaults        0 0

[iyunv@wenxi ~]#  mount -o remount,size=2G /dev/shm


[iyunv@wenxi ~]# df -h /dev/shm/
Filesystem      Size  Used Avail Use% Mounted on
tmpfs           2.0G   72K  2.0G   1% /dev/shm


[iyunv@wenxi ~]# vim /etc/fstab

tmpfs                   /dev/shm                tmpfs   defaults,size=2G


正常打开了

SYS@ odb>startup
ORACLE instance started.

Total System Global Area 1603411968 bytes
Fixed Size                  2253664 bytes
Variable Size             989858976 bytes
Database Buffers          603979776 bytes
Redo Buffers                7319552 bytes
Database mounted.
Database opened.