前两天在虚拟机上装的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=1024m        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>

Logo

华为开发者空间,是为全球开发者打造的专属开发空间,汇聚了华为优质开发资源及工具,致力于让每一位开发者拥有一台云主机,基于华为根生态开发、创新。

更多推荐