ORA-00845 MEMORY_TARGET not supported on this system 的解决

2018-01-03 11:02:35来源:oschina作者:bz_z人点击

分享

oracle11g数据库在执行dbca或者调整sga后重启oracle的时候可能会出现ORA-00845 MEMORY_TARGET not supported on this system 错误。 究其原因就是Linux系统的shm的大小比SGA设置的小,造成的,距离来说,SGA设置4G,而shm可能只有1G


网上提供两种解决办法: 01、调整sga的大小,这个明显不是我们所希望的 02、调整shm的大小,这样相对简单,具体操作如下 vi /etc/fstab 修改如下行的设置 tmpfs /dev/shm tmpfs defaults 0 0 改成 tmpfs /dev/shm tmpfs defaults,size=6G 0 0 保存退出 重新mount下shm使其生效 mount -o remount /dev/shm 通过df可以查看下,没有问题就可以继续安装数据库或者启动数据库了!


说明:服务器上有两个不同数据库实例,启动一个实例的时候没问题。在启动第二个INSTANCE的时候报ORA-00845错误。该测试服务器仅8G内存。tmpfs 默认是4G4.0G 1.6G 2.4G 40% /dev/shm. 两个实例的使用内存应该超过了4G,所以安装网上这篇文章进行修改tmpfs,问题解决了。 但是新问题tmpfs 大小的限制如何确定呢?观察一下内存使用在说吧


[oracle@BJRMANTS ~]$ su - root Password: [root@BJRMANTS ~]# vi /etc/fstab [root@BJRMANTS ~]# df -g df: invalid option -- 'g' Try `df --help' for more information. [root@BJRMANTS ~]# df -h FilesystemSize Used Avail Use% Mounted on /dev/sda220G 5.8G13G 31% / tmpfs4.0G 1.6G 2.4G 40% /dev/shm /dev/sda1485M51M 409M 12% /boot /dev/sda6197G 160G28G 86% /orabak /dev/sda820G 6.2G13G 34% /oracle /dev/sda5690G 549G 106G 84% /oradata /dev/sda7187G75G 104G 42% /oralog [root@BJRMANTS ~]# mount -o remount /dev/shm [root@BJRMANTS ~]# df -h FilesystemSize Used Avail Use% Mounted on /dev/sda220G 5.8G13G 31% / tmpfs6.0G 1.6G 4.5G 26% /dev/shm /dev/sda1485M51M 409M 12% /boot /dev/sda6197G 160G28G 86% /orabak /dev/sda820G 6.2G13G 34% /oracle /dev/sda5690G 549G 106G 84% /oradata /dev/sda7187G75G 104G 42% /oralog [root@BJRMANTS ~]#

[oracle@BJRMANTS ~]$ export ORACLE_SID=oelncbi [oracle@BJRMANTS ~]$ sqlplus / as sysdba


SQL*Plus: Release 11.2.0.3.0 Production on Wed Dec 5 10:48:51 2012


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


Connected to an idle instance.


SQL> startup; ORA-00845: MEMORY_TARGET not supported on this system SQL> exit Disconnected [oracle@BJRMANTS ~]$ export ORACLE_SID=oeldzdz [oracle@BJRMANTS ~]$ sqlplus / as sysdba


SQL*Plus: Release 11.2.0.3.0 Production on Wed Dec 5 10:49:33 2012


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


Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options


SQL> shutdown abort; ORACLE instance shut down. SQL> exit Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options [oracle@BJRMANTS ~]$ export ORACLE_SID=oelncbi [oracle@BJRMANTS ~]$ sqlplus / as sysdba


SQL*Plus: Release 11.2.0.3.0 Production on Wed Dec 5 10:49:51 2012


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


Connected to an idle instance.


SQL> startup; ORACLE instance started.


Total System Global Area 814227456 bytes Fixed Size 2232760 bytes Variable Size452988488 bytes Database Buffers352321536 bytes Redo Buffers 6684672 bytes Database mounted. Database opened. SQL> exit Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options [oracle@BJRMANTS ~]$ export ORACLE_SID=oeldzdz [oracle@BJRMANTS ~]$ sqlplus / as sysdba


SQL*Plus: Release 11.2.0.3.0 Production on Wed Dec 5 10:54:15 2012


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


Connected to an idle instance.


SQL> startup; ORACLE instance started.


Total System Global Area 2805977088 bytes Fixed Size 2231672 bytes Variable Size603980424 bytes Database Buffers 2181038080 bytes Redo Buffers 18726912 bytes Database mounted. Database opened. SQL>

最新文章

123

最新摄影

闪念基因

微信扫一扫

第七城市微信公众平台