oracle 11.2.01+linux5.5
SQL>startup
ORA-00845: MEMORY_TARGET not supported on this system
alert日志:
Wed Jun 05 23:17:44 2013
Starting ORACLE instance (normal)
WARNING: You are trying to use the MEMORY_TARGET feature. This feature requires the /dev/shm file system to be mounted for at least 943718400 bytes. /dev/shm is either not mounted or is mounted with available space less than this size. Please fix this so that MEMORY_TARGET can work as expected. Current available is 901324800 and used is 161312768 bytes. Ensure that the mount point is /dev/shm for this directory.
memory_target needs larger /dev/shm
出现问题的原因:设置了memory_target 的大小大于 /dev/shm 文件系统的大小
解决办法1:将memory_target的值减小,vi pfile文件 ,startup pfile='';还是报同样的错
解决方法2:增大/dev/shm大小为2G
[root@rac2 ~]# vi /etc/fstab
/dev/VolGroup00/LogVol00 / ext3 defaults 1 1
LABEL=/boot /boot ext3 defaults 1 2
#tmpfs /dev/shm tmpfs defaults 0 0
tmpfs /dev/shm tmpfs defaults,size=2048M 0 0
devpts /dev/pts devpts gid=5,mode=620 0 0
sysfs /sys sysfs defaults 0 0
proc /proc proc defaults 0 0
/dev/VolGroup00/LogVol01 swap swap defaults 0 0
重新挂载 /dev/shm
[root@rac2 ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
35G 25G 8.3G 75% /
/dev/sda1 99M 16M 79M 17% /boot
[root@rac2 ~]# umount /dev/shm
[root@rac2 ~]# mount /dev/shm
[root@rac2 ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
35G 25G 8.3G 75% /
/dev/sda1 99M 16M 79M 17% /boot
tmpfs 2.0G 0 2.0G 0% /dev/shm
tmpfs 2.0G 0 2.0G 0% /dev/shm
tmpfs 2.0G 0 2.0G 0% /dev/shm
[root@rac2 ~]#
小插曲:挂载了之后发现 出现三个 tmpfs 还有待研究~~
就直接重启:
[root@rac2 ~]# reboot
Broadcast message from root (pts/1) (Wed Jun 5 23:43:09 2013):
The system is going down for reboot NOW!
[root@rac2 ~]# Last login: Wed Jun 5 19:38:06 2013 from 192.168.15.88
[root@rac2 ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
35G 25G 8.3G 75% /
/dev/sda1 99M 16M 79M 17% /boot
tmpfs 2.0G 154M 1.9G 8% /dev/shm
恢复正常!
启动数据库:
[oracle@rac2 ~]$ export ORACLE_SID=test2
[oracle@rac2 ~]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on Wed Jun 5 23:48:22 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
SQL> conn /as sysdba
Connected.
SQL> create pfile from spfile;
File created.
正常~
重新创建pfile,以免spfile出问题了是可以用
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/28380626/viewspace-763092/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/28380626/viewspace-763092/