【oracle案例】ORA-00845

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

启动成功。