1.1. ORA-00845
ORA-00845: MEMORY_TARGET not supported onthis system
00845, 00000, "MEMORY_TARGET notsupported on this system"
// *Cause: The MEMORY_TARGET parameter wasnot supported on this operating system or /dev/shm was not sized correctly onLinux.
// *Action: Refer to documentation for alist of supported operating systems. Or, size /dev/shm to be at least theSGA_MAX_SIZE on each Oracle instance running on the system.
报错信息
在ASM环境中，启动oracle实例的时候报错
SQL> startup
ORA-00845: MEMORY_TARGET not supported onthis system
查看日志
Sun Mar 30 14:28:07 2014
Adjusting the default value of parameterparallel_max_servers
from 640 to 185 due to the value ofparameter processes (200)
Starting ORACLE instance (normal)
WARNING: You are trying to use theMEMORY_TARGET feature. This feature requires the /dev/shm file system to bemounted for at least 19327352832 bytes. /dev/shm is either not mounted or ismounted with available space less than this size. Please fix this so thatMEMORY_TARGET can work as expected. Current available is 16536903680 and usedis 288894976 bytes. Ensure that the mount point is /dev/shm for this directory.
memory_target needs larger /dev/shm
查看/dev/shm分区情况
Filesystem Type Size Used Avail Use% Mounted on
tmpfs tmpfs 16G 14.2G 1.8G 89% /dev/shm
调整/dev/shm分区大小：
# vim /etc/fstab
tmpfs /dev/shm tmpfs defaults,size=20G 0 0
查看使用/dev/shm分区的进程：
#lsof /dev/shm -- ASM实例在使用
关闭ASM实例（已经确认可以关闭）：
# sqlplus -S / as sysasm
-- 检查当前连接的会话
selectusername,status,server,type,program,action,logon_time,state from v$session;
-- 确认可以关闭ASM实例
shutdown normal
重新加载/dev/shm分区：
# mount -o remount /dev/shm
查看/dev/shm分区大小：
# df -hT |grep shm
tmpfs tmpfs 20G 19G 1.8G 92% /dev/shm
启动Oracle实例：
# id
oracle
# sqlplus -S / as sysdba
startup
启动成功。
本栏目更多精彩内容：http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/