实例启动时报ORA-00845的解决方法
来源:互联网 发布:ios软件编程 编辑:程序博客网 时间:2024/06/05 17:20
实例启动时报ORA-00845的解决方法
idle> startup
ORA-00845: MEMORY_TARGET not supported on this system
因为我一个库里有两个实例,启动时/dev/shm就不够用了。
在Oracle 11g中如果采用AMM内存管理,那么当MEMORY_TARGET的值大于/dev/shm的时候,就会报ORA-00845: MEMORY_TARGET not supported on this system错误,解决办法增加/dev/shm大小,在redhat系列系统中,/dev/shm的默认值是系统总内存的一半
1、修改/dev/shm大小
[oracle@rtest ~]$ df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda3 140G 57G 76G 43% /
/dev/sda1 99M 12M 82M 13% /boot
tmpfs 3.9G 995M 3.0G 25% /dev/shm
[oracle@rtest ~]$ mount -o size=8G -o nr_inodes=1000000 -o noatime,nodiratime -o remount /dev/shm
mount: only root can do that
[oracle@rtest ~]$ su -
Password:
[root@rtest ~]# mount -o size=8G -o nr_inodes=1000000 -o noatime,nodiratime -o remount /dev/shm
[root@rtest ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda3 140G 57G 76G 43% /
/dev/sda1 99M 12M 82M 13% /boot
tmpfs 8.0G 995M 7.1G 13% /dev/shm
2、 vi /etc/fstab
LABEL=/ / ext3 defaults 1 1
LABEL=/boot /boot ext3 defaults 1 2
tmpfs /dev/shm tmpfs defaults,size=8G 0 0
devpts /dev/pts devpts gid=5,mode=620 0 0
sysfs /sys sysfs defaults 0 0
proc /proc proc defaults 0 0
LABEL=SWAP-sda2 swap swap defaults 0 0
3、启动数据库验证:
[oracle@rtest ~]$ export ORACLE_SID=test0924
[oracle@rtest ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Mon Oct 28 14:41:13 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
idle> idle>
idle> conn /as sysdba
Connected to an idle instance.
idle> startup
ORACLE instance started.
Total System Global Area 3340451840 bytes
Fixed Size 2232960 bytes
Variable Size 3204451712 bytes
Database Buffers 117440512 bytes
Redo Buffers 16326656 bytes
Database mounted.
Database opened.
idle> conn /as sysdba
Connected.
sys@TEST0924> show parameter mem
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address integer 0
memory_max_target big integer 3200M
memory_target big integer 0
shared_memory_address integer 0
4、官方解析
Starting with Oracle Database 11g, the Automatic Memory Management feature requires more shared memory (/dev/shm)and file descriptors. The size of the shared memory should be at least the greater of MEMORY_MAX_TARGET and MEMORY_TARGET for each Oracle instance on the computer. If MEMORY_MAX_TARGET or MEMORY_TARGET is set to a non zero value, and an incorrect size is assigned to the shared memory, it will result in an ORA-00845 error at startup.
5、解决问题建议
5.1. If you are installing Oracle 11g on a Linux system, note that Memory Size (SGA and PGA), which sets the initialization parameter MEMORY_TARGET or MEMORY_MAX_TARGET, cannot be greater than the shared memory filesystem (/dev/shm) on your operating system. To resolve the current error, increase the /dev/shm file size.
5.2. If configuring AMM is not possible due to lack of space on /dev/shm mount point, you can configure ASMM instead of AMM, i.e. set SGA_TARGET, SGA_MAX_SIZE and PGA_AGGREGATE_TARGET instead of MEMORY_TARGET.
阅读全文
0 0
- 实例启动时报ORA-00845的解决方法
- 实例启动时报ORA-00845的解决方法
- windows 下的oracle实例启动时报错ora-28056
- Oracle建立实例时报【ORA-12638: 身份证明检索失败解决方法】错误的解决方法
- oracle 实例启动时报 ORA-01157,ORA-01110解决
- 11g R2 rac 启动时报错ora-17503的解决方法
- Oracle11g 启动时报错:ORA-00845
- 一个数据库实例在启动时报ORA-27140
- startup mount 时报ORA-12514错误的解决方法
- startup mount时报ORA-12514错误的解决方法
- oracle数据库启动时报ORA-03113的处理
- Eclipse启动时报错解决方法
- Tomcat启动时报错java.io.EOFException的解决方法
- Ehcache项目启动时报Update check failed异常的解决方法
- 关于oracle数据库启动报ORA-01122,ORA-01110,ORA-01203错误的解决方法
- linux下启动应用时报ORA-12505,连接的SID问题
- 关于启动数据库后提示ora-12505的解决方法
- 在启动DB时报错ORA-27154 ORA-27300 ORA-27301 ORA-27302
- ORA-01102 报错解决方法
- HTML5实战与剖析之触摸事件(touchstart、touchmove和touchend)
- 命令模式实现 Undo Redo
- linux下手工启动oracle centos下手动启动oracle
- Ubuntu搭建LDAP服务
- 实例启动时报ORA-00845的解决方法
- 解决Sublime Text 3中文显示乱码(tab中文方块)问题,sublime tab乱码
- python之解析最简单的xml
- 【Node.js-4】jade介绍、include、传递数据、定义变量、for等高级用法、ejs
- Oracle数据库报ORA-01078和LRM-00109错误解决方法
- shell脚本killoracle数据库指定用户
- CleanMyMac 破解版 真的好用吗?
- CentOS 7 下安装 chrome
- Android floatingSearchView 开源 仿谷歌搜索框