oerr ora 000845解決方法是擴(kuò)大/dev/shm空間

打開虛擬機(jī)發(fā)現(xiàn)實(shí)例起不來

[root@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中新增的內(nèi)存自動管理的參數(shù)MEMORY_TARGET,它能自動調(diào)整SGA和PGA，這個(gè)特性需要用到/dev/shm共享文件系統(tǒng)，而且要求 /dev/shm必須大于MEMORY_TARGET，如果/dev/shm比MEMORY_TARGET小就會報(bào)錯(cuò)

[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

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

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

[root@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.