oracle11g ORA-00845: MEMORY_TARGET not supported on this system
来源:互联网 发布:龙刀皮肤淘宝上多少钱 编辑:程序博客网 时间:2024/06/05 12:00
今天在升级oracle11g11.1.0.6版本数据库到11.1.0.7版本,在安装补丁p6890831_111070_Linux-x86.zip后,接着通过dbua升级数据库时,出现“MEMORY_TARGET not supported on this system”的提示,接着数据库升级就中止了,于是,仔细查阅了这个问题,原来oracle 11g版本不但在升级时会出现这个问题,如果设置MEMORY_TARGET不当,也会出现此问题。
其实,这个问题是SGA的设置超出了操作系统/dev/shm大小导致的。
下面是老杨写的关于此错误的一篇文章:
Oracle 11g的Linux版本在修改了MEMORY_TARGET或者SGA_TARGET后启动可能会报错:
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORA-00845: MEMORY_TARGET not supported on this system
这个问题是由于设置SGA的大小超过了操作系统/dev/shm的大小:
[root@enterprice64 ~]# df -k /dev/shm
Filesystem 1K-blocks Used Available Use% Mounted on
tmpfs 4089416 0 4089416 0% /dev/shm
Oracle在metalink的文档:Doc ID: Note:460506.1中进行了说明。解决这个问题只有两个方法,一种是修改初始化参数,使得初始化参数中SGA的设置小于/dev/shm的大小,另一种方法就是调整/dev/shm的大小。
修改/dev/shm的大小可以通过修改/etc/fstab来实现:
[root@enterprice64 ~]# vi /etc/fstab
LABEL=/ / ext3 defaults 1 1
LABEL=/boot /boot ext3 defaults 1 2
LABEL=/data /data 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=10240M 0 0
LABEL=/home /home ext3 defaults 1 2
LABEL=/opt /opt ext3 defaults 1 2
proc /proc proc defaults 0 0
sysfs /sys sysfs defaults 0 0
LABEL=/usr /usr ext3 defaults 1 2
LABEL=/var /var ext3 defaults 1 2
LABEL=SWAP-sda8 swap swap defaults 0 0
~
~
"/etc/fstab" 13L, 965C written
[root@enterprice64 ~]# umount /dev/shm
[root@enterprice64 ~]# mount /dev/shm
[root@enterprice64 ~]# df -k /dev/shm
Filesystem 1K-blocks Used Available Use% Mounted on
tmpfs 10485760 0 10485760 0% /dev/shm
[root@enterprice64 ~]# su - oracle
[oracle@enterprice64 ~]$ sqlplus "/ as sysdba"
SQL*Plus: Release 11.1.0.6.0 - Production on Tue Oct 23 15:42:42 2007
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 4743446528 bytes
Fixed Size 2143824 bytes
Variable Size 3892316592 bytes
Database Buffers 805306368 bytes
Redo Buffers 43679744 bytes
Database mounted.
Database opened.
修改/etc/fstab,重新mount /dev/shm,然后就可以启动数据库了。
原文链接:http://www.ixdba.net/article/9c/2121.html
- oracle11g ORA-00845: MEMORY_TARGET not supported on this system
- oracle11g ORA-00845: MEMORY_TARGET not supported on this system
- Oracle11g新引入的memory_target以及ORA-00845: MEMORY_TARGET not supported on this system的产生
- ORA-00845 MEMORY_TARGET not supported on this system (oracle11g for asianux3 )
- ORA-00845 MEMORY_TARGET not supported on this system (oracle11g for asianux3 )
- Oracle11g R2 ORA-00845的错误:MEMORY_TARGET not supported on this system
- ORA-00845: MEMORY_TARGET not supported on this system 错误解决方法!
- ORA-00845: MEMORY_TARGET not supported on this system - Linux Servers
- ORA-00845: MEMORY_TARGET not supported on this system
- ORA-00845: MEMORY_TARGET not supported on this system
- ora-00845 MEMORY_TARGET not supported on this system 的问题
- ORA-00845: MEMORY_TARGET not supported on this system
- ORA-00845: MEMORY_TARGET not supported on this system
- ORA-00845: MEMORY_TARGET not supported on this system
- ORA-00845: MEMORY_TARGET not supported on this system
- ORA-00845: MEMORY_TARGET not supported on this system
- ORA-00845: MEMORY_TARGET not supported on this system
- ORA-00845: MEMORY_TARGET not supported on this system
- oracle异常down机后,常见的01109错误,01507错误,01102错误
- 安卓学习第一弹-关于ListView的那点事
- C++离港篇
- 修改tomcat编码格式以及乱码的解决办法
- Search Results for: library How to trouble shooting Library cache lock/pin
- oracle11g ORA-00845: MEMORY_TARGET not supported on this system
- iOS开发笔记 - 界面调试神器Reveal
- symbol table meaning
- 11gR2游标共享新特性带来的一些问题以及_cursor_features_enabled、_cursor_obsolete_threshold和106001 event
- Android Caused by: java.lang.IllegalArgumentException: column '_id' does not exist
- 共享池部分-library cache、library cache object handle、library cache object、shared cursor、session cursor和解析
- 向SVN添加新项目的实践笔记
- Oracle内存详解之二 Library cache 库缓冲
- windows客户端开发--windows api大全