ORA-00845: MEMORY_TARGET not supported on this system
xixuefeng
ERR
2014-03-01 23:25:16
1,865 次浏览
ORA-00845
ORA-00845: MEMORY_TARGET not supported on this system已关闭评论
1:在测试手动建库时,数据库启动报如下错误。
1 2 3 4 5 6 7 8 9 10 11 |
[oracle@prod ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Fri Feb 28 16:38:22 2014 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to an idle instance. SQL> startup nomount; ORA-00845: MEMORY_TARGET not supported on this system SQL> |
原因:在oracle 11g中SGA和PGA都为自动调整,参数为MEMORY_TARGET,这个特性需要用到/dev/shm共享文件系统,而且要求/dev/shm必须大于MEMORY_TARGET,如果/dev/shm比MEMORY_TARGET小就会如上报错,MEMORY_TARGET大小为1G。
解决:
- 修改MEMORY_TARGET大小
- 加大shm大小(显然,这个是我们想要做的)
2:加大shm大小步骤如下:
1 2 3 4 5 6 7 8 |
--查看shm为998M [root@prod ~]# df -h Filesystem Size Used Avail Use% Mounted on /dev/mapper/VolGroup00-LogVol00 35G 9.3G 24G 28% / /dev/sda1 99M 23M 71M 25% /boot tmpfs 998M 0 998M 0% /dev/shm [root@prod ~]# |
3:编辑fstab配置文件
注:fstab是Linux下比较重要的配置文件,它包含了系统在启动时挂载文件系统和存储设备的详细信息
1 2 3 4 5 6 7 8 9 10 11 |
[root@prod ~]# vi /etc/fstab /dev/VolGroup00/LogVol00 / ext3 defaults 1 1 LABEL=/boot /boot ext3 defaults 1 2 tmpfs /dev/shm tmpfs defaults,size=2G 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 [root@prod ~]# |
4: 再次查看shm,此时加大shm还未生效
1 2 3 4 5 6 7 |
[root@prod ~]# df -h Filesystem Size Used Avail Use% Mounted on /dev/mapper/VolGroup00-LogVol00 35G 9.3G 24G 28% / /dev/sda1 99M 23M 71M 25% /boot tmpfs 998M 0 998M 0% /dev/shm [root@prod ~]# |
5:重新挂载使其生效
1 |
[root@prod ~]# mount -o remount /dev/shm |
1 2 3 4 5 6 7 |
[root@prod ~]# df -h Filesystem Size Used Avail Use% Mounted on /dev/mapper/VolGroup00-LogVol00 35G 9.3G 24G 28% / /dev/sda1 99M 23M 71M 25% /boot tmpfs 2.0G 0 2.0G 0% /dev/shm [root@prod ~]# |
6:再次startup nomount,成功启动
1 2 3 4 5 6 7 8 9 |
SQL> startup nomount; ORACLE instance started. Total System Global Area 1068937216 bytes Fixed Size 2260088 bytes Variable Size 671089544 bytes Database Buffers 390070272 bytes Redo Buffers 5517312 bytes SQL> |