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
啟動成功。