ORA-00845: MEMORY_TARGET not supported on this system

加入收藏设为首页

备份与恢复: ORA-00845: MEMORY_TARGET not supported on this system
时间：2014/7/13 17:43:37 作者：说歌社区来源：www.solgle.com 查看：856 评论：0
内容摘要：今天重启了linux主机，并减少了linux主机的内存，在开机后启动Oracle数据库失败，报如下错误ORA-00845: MEMORY_TARGET not supported on this systemSQL*Plus: Release 11.2.0.1.0 Product...
今天重启了linux主机，并减少了linux主机的内存，在开机后启动Oracle数据库失败，报如下错误

ORA-00845: MEMORY_TARGET not supported on this system

本文出自：http://www.solgle.com/news/?140.html

SQL*Plus: Release 11.2.0.1.0 Production on Mon Sep 29 09:38:42 2014

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

Connected to an idle instance.

SQL> startup

ORA-00845: MEMORY_TARGET not supported on this system

SQL> create pfile='hao123.ora' from spfile;

File created.

---调整pfile中MEMORY_TARGET的大小

SQL> create spfile from pfile='hao123.ora';

File created.

---尝试启动

如果失败那继续修改/dev/shm

[oracle@sd1 dbs]$ df -h

Filesystem Size Used Avail Use% Mounted on

/dev/mapper/VolGroup-lv_root 36G 20G 15G 59% /

tmpfs 868M 0 868M 0% /dev/shm

/dev/sda1 477M 55M 397M 13% /boot

/dev/sdb1 50G 46G 1.1G 98% /u01/data

[oracle@sd1 dbs]$ cat /etc/fstab

#

# /etc/fstab

# Created by anaconda on Tue Sep 2 19:31:02 2014

#

# Accessible filesystems, by reference, are maintained under '/dev/disk'

# See man pages fstab(5), findfs(8), mount(8) and/or blkid(8) for more info

#

/dev/mapper/VolGroup-lv_root / ext4 defaults 1 1

UUID=23c511ac-11c9-4ad8-b0f3-9da40d64bfe1 /boot ext4 defaults 1 2

/dev/mapper/VolGroup-lv_swap swap swap defaults 0 0

tmpfs /dev/shm tmpfs defaults 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/sdb1 /u01/data ext4 defaults 0 0

[oracle@sd1 dbs]$ su - root

Password:

[root@sd1 ~]# vi /etc/fstab

# /etc/fstab

# Created by anaconda on Tue Sep 2 19:31:02 2014

#

# Accessible filesystems, by reference, are maintained under '/dev/disk'

# See man pages fstab(5), findfs(8), mount(8) and/or blkid(8) for more info

#

/dev/mapper/VolGroup-lv_root / ext4 defaults 1 1

UUID=23c511ac-11c9-4ad8-b0f3-9da40d64bfe1 /boot ext4 defaults 1 2

/dev/mapper/VolGroup-lv_swap swap swap defaults 0 0

tmpfs /dev/shm tmpfs defaults 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/sdb1 /u01/data ext4 defaults 0 0

####change to

tmpfs /dev/shm tmpfs defaults,size=2G 0 0

:wq!

Remount
方法一：

[root@sd1 ~]# mount -o remount,size=2G /dev/shm

方法二：

---reboot (此处不需要重启)

[root@sd1 ~]# df -h

Filesystem Size Used Avail Use% Mounted on

/dev/mapper/VolGroup-lv_root 36G 20G 15G 59% /

tmpfs 2.0G 190M 1.9G 10% /dev/shm

/dev/sda1 477M 55M 397M 13% /boot

/dev/sdb1 50G 46G 1.1G 98% /u01/data

[root@sd1 ~]#

---再次启动

SQL> startup

ORACLE instance started.

Total System Global Area 1039708160 bytes

Fixed Size 2259800 bytes

Variable Size 654312616 bytes

Database Buffers 377487360 bytes

Redo Buffers 5648384 bytes

Database mounted.

Database opened.

SQL>

--这样数据库已经正常启动

标签：ORA-00845 MEMORY_TARGET not supported on this system

solgle.com 版权所有，欢迎分享！！！

上一篇：部署Oracle 11g DataGuard 用Rman创建 standby database
下一篇：ORA-03113: 通信通道的文件结尾

相关文章

相关评论

本类更新

本类推荐

本类排行

: 国家数据 | 中证指数 | Oracle官方文档 | 沪深行情 | 流量统计 | 深交所 | 上交所 | 中国证券登记 | 同业拆放利率 | 巨潮资讯 | 指数估值 | 看财报 |

联系我们 - 关于我们 - 网站同盟