欢迎来到网际学院,让您的头脑满载而归!

oracle 11g ORA-00845错误解决

发布日期:2017-08-20 10:50:43 作者:管理员 阅读:1349

oracle11g数据库,修改了内存参数memory_max_target=943718400,关闭数据库重新启动的时候报错

oracle 11g ORA-00845错误解决

oracle11g数据库,修改了内存参数memory_max_target=943718400,关闭数据库重新启动的时候报错
[oracle@instuctor shm]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Mon Nov 19 09:34:11 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@instuctor shm]$ oerr ora 00845
00845, 00000, "MEMORY_TARGET not supported on this system"
// *Cause: The MEMORY_TARGET parameter was not supported on this operating system or /dev/shm was not sized correctly on Linux.
// *Action: Refer to documentation for a list of supported operating systems. Or, size /dev/shm to be at least the SGA_MAX_SIZE on each

Oracle instance running on the system.


查看数据库的警告日志,同样看到了类似的报错信息

Mon Nov 19 09:34:14 2012
Starting ORACLE instance (normal)
WARNING: You are trying to use the MEMORY_TARGET feature. This feature requires the /dev/shm file system to be mounted for at least 943718400

bytes. /dev/shm is either not mounted or is mounted with available space less than this size. Please fix this so that MEMORY_TARGET can work

as expected. Current available is 845021184 and used is 208900096 bytes. Ensure that the mount point is /dev/shm for this directory.
memory_target needs larger /dev/shm

通过以上原因的分析,看来是/dev/shm剩余的空间太小了

 

[oracle@instuctor shm]$ df -H
Filesystem            Size  Used Avail Use% Mounted on
/dev/sda1              17G   15G  1.2G 93% /
tmpfs                 1.1G  209M  846M 20% /dev/shm
[oracle@instuctor shm]$


Oracle在metalink的文档:Doc ID:Note:460506.1中进行了说明。
解决这个问题只有两个方法,
1.修改初始化参数,使得初始化参数中SGA的设置小于/dev/shm的大小
2.调整/dev/shm的大小。

修改/dev/shm的大小可以通过修改/etc/fstab来实现:

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

LABEL=/                /                      ext3   defaults       1 1
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
LABEL=SWAP-sda2        swap                   swap   defaults       0 0
~
~
[root@instuctor ~]# mount -o remount /dev/shm
[root@instuctor ~]# df -H
Filesystem            Size  Used Avail Use% Mounted on
/dev/sda1              17G   15G  1.2G 93% /
tmpfs                 2.2G  209M  2.0G 10% /dev/shm


扩大/dev/shm后,再次尝试启动数据库,没有问题。
[oracle@instuctor ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Mon Nov 19 10:02:33 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 939495424 bytes
Fixed Size                 2233960 bytes
Variable Size            616565144 bytes
Database Buffers         314572800 bytes
Redo Buffers               6123520 bytes
Database mounted.
Database opened.

 



Copyright oneie ©2014-2017 All Rights Reserved. 所有资料来源于互联网对相关版权责任概不负责。如发现侵犯了您的版权请与我们联系。 网际学院 版权所有
免责声明  商务合作及投稿请联系 QQ:86662817