程序師世界是廣大編程愛好者互助、分享、學習的平台,程序師世界有你更精彩!
首頁
編程語言
C語言|JAVA編程
Python編程
網頁編程
ASP編程|PHP編程
JSP編程
數據庫知識
MYSQL數據庫|SqlServer數據庫
Oracle數據庫|DB2數據庫
 程式師世界 >> 數據庫知識 >> Oracle數據庫 >> Oracle教程 >> ORA-00845-MEMORY_TARGETnotsupportedonthissystem

ORA-00845-MEMORY_TARGETnotsupportedonthissystem

編輯:Oracle教程

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

啟動成功。

  1. 上一頁:
  2. 下一頁:
Copyright © 程式師世界 All Rights Reserved