ORACLE 11g的ORA-00845错误解决(原创)

今天在虚拟机上装oracle 11g，启动的时候突然报
SQL> startup
ORA-00845: MEMORY_TARGET not supported on this system

matelink上的解释是：

This feature requires the /dev/shm file system to be mounted for at least %llu bytes.
/dev/shm is either not mounted or is mounted with available space less than this size.

可以通过下面的方法修改/dev/shm

[root@server ~]# df -k /dev/shm
Filesystem           1K-blocks      Used Available Use% Mounted on
tmpfs                   359816         0    359816   0% /dev/shm
[root@server ~]# vi /etc/fstab

#tmpfs                   /dev/shm                tmpfs   defaults        0 0

/dev/VolGroup00/LogVol00 /                       ext3    defaults        1 1
LABEL=/boot             /boot                   ext3    defaults        1 2
devpts                  /dev/pts                devpts  gid=5,mode=620  0 0
#tmpfs                   /dev/shm                tmpfs   defaults        0 0
tmpfs                   /dev/shm                tmpfs   defaults,size=20480m        0 0
proc                    /proc                   proc    defaults        0 0
sysfs                   /sys                    sysfs   defaults        0 0
/dev/VolGroup00/LogVol01 swap                    swap    defaults        0 0
"/etc/fstab" 8L, 622C written
[root@server ~]# umount /dev/shm
[root@server ~]# mount /dev/shm
[root@server ~]# df -k /dev/shm
Filesystem           1K-blocks      Used Available Use% Mounted on
tmpfs                  1048576         0   1048576   0% /dev/shm

再启动数据库

$ sqlplus '/as sysdba'

SQL*Plus: Release 11.1.0.6.0 - Production on Fri Sep 5 06:43:32 2008

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

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area  393375744 bytes
Fixed Size                  1300156 bytes
Variable Size             327158084 bytes
Database Buffers           58720256 bytes
Redo Buffers                6197248 bytes
Database mounted.
Database opened.
SQL>