oracle 11g ORA-00845错误解决
oracle11g数据库，修改了内存参数memory_max_target=943718400,关闭数据库重新启动的时候报错$ sqlplus / as sysdba
SQL*Plus:> Copyright (c) 1982, 2011, Oracle.All rights reserved.
Connected to an> SQL> startup
ORA-00845: MEMORY_TARGET not supported on this system
SQL> exit
Disconnected
$ 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>
// *Action: Refer to documentation for a list of supported operating systems. Or,> 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> 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剩余的空间太小了
$ df -H
Filesystem > /dev/sda1 17G 15G 1.2G93% /
tmpfs 1.1G 209M 846M20% /dev/shm
$
Oracle在metalink的文档：Doc> 解决这个问题只有两个方法，
1.修改初始化参数，使得初始化参数中SGA的设置小于/dev/shm的大小
2.调整/dev/shm的大小。
修改/dev/shm的大小可以通过修改/etc/fstab来实现：
# vi /etc/fstab
LABEL=/ / ext3 defaults 1 1
tmpfs /dev/shm tmpfs defaults,size=2G 0 0
devpts /dev/pts devptsgid=5,mode=6200 0
sysfs /sys sysfs defaults 0 0
proc /proc proc defaults 0 0
LABEL=SWAP-sda2 swap swap defaults 0 0
~
~
# mount -o remount /dev/shm
# df -H
Filesystem > /dev/sda1 17G 15G 1.2G93% /
tmpfs 2.2G 209M 2.0G10% /dev/shm
扩大/dev/shm后，再次尝试启动数据库，没有问题。
$ sqlplus / as sysdba
SQL*Plus:> Copyright (c) 1982, 2011, Oracle.All rights reserved.
Connected to an> SQL> startup
ORACLE instance started.
Total System Global Area939495424 bytes
Fixed>
Variable> Database Buffers 314572800 bytes
Redo Buffers 6123520 bytes
Database mounted.
Database opened.
oracle视频教程请关注:http://u.youku.com/user_video/id_UMzAzMjkxMjE2.html
页:
[1]