11g的ORA-00845错误解决
前两天在虚拟机上装的11g,启动的时候突然报SQL> startupORA-00845: MEMORY_TARGET not supported on this systemmatelink上的解释是:This feature requires the /dev/shm file system to be mounted for at least %llu bytes./dev/shm is ei
·
前两天在虚拟机上装的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>
更多推荐
已为社区贡献4条内容
所有评论(0)