[ORA-00845] MEMORY_TARGET not supported on this system

-  데이터베이스를 새로 생성 할 때 데이터베이스를 기동하며 만난 에러

* 11g 기능 중 하나인 AMM 을 사용하기위해 memory_target, memory_max_size 세팅 후 DB기동할 때.

* 원인 마운트된 /dev/shm 크기가 memory_target 혹은 memory_max_size 보다 작은 경우.

 

[oracle@edydr1p0-PROD ~]$ sqlplus /nolog @create_db   SQL*Plus: Release 11.2.0.1.0 Production on Mon Jun 15 11:14:50 2015   Copyright (c) 1982, 2009, Oracle.  All rights reserved.   Connected to an idle instance.   File created.   ORA-00845: MEMORY_TARGET not supported on this system CREATE DATABASE PROD * ERROR at line 1: ORA-01034: ORACLE not available Process ID: 0 Session ID: 0 Serial number: 0     DOC>###################################################################### DOC>###################################################################### DOC> The following statement will cause an "ORA-01722: invalid number" DOC> error and terminate the SQLPLUS session if the user is not SYS. DOC> Disconnect and reconnect with AS SYSDBA. DOC>###################################################################### DOC>###################################################################### DOC># SELECT TO_NUMBER('MUST_BE_AS_SYSDBA') FROM DUAL * ERROR at line 1: ORA-01034: ORACLE not available Process ID: 0 Session ID: 0 Serial number: 0       Disconnected

 

- 해결방법

* 마운트된  /dev/shm 용량 확인 [root@edydr1p0 ~]# df -h Filesystem            Size  Used Avail Use% Mounted on /dev/sda3              92G   48G   40G  55% / /dev/sda1              99M   26M   69M  27% /boot tmpfs                 500M  156M  345M  32% /dev/shm .host:/               465G   78G  387G  17% /mnt/hgfs * 용량증설을 위해 /dev/shm umount [root@edydr1p0 ~]# umount /dev/shm umount: /dev/shm: device is busy umount: /dev/shm: device is busy     ** device busy 상태로, umount가 되지않는다.   -l 옵션으로 umount, umount 확인.  [root@edydr1p0 ~]# umount -l tmpfs [root@edydr1p0 ~]# df -h Filesystem            Size  Used Avail Use% Mounted on /dev/sda3              92G   48G   40G  55% / /dev/sda1              99M   26M   69M  27% /boot   .host:/               465G   78G  387G  17% /mnt/hgfs * 용량 1기가로 증설 후 mount. [root@edydr1p0 ~]# mount -t tmpfs shmfs -o size=1g /dev/shm [root@edydr1p0 ~]# df -h Filesystem            Size  Used Avail Use% Mounted on /dev/sda3              92G   48G   40G  55% / /dev/sda1              99M   26M   69M  27% /boot .host:/               465G   78G  387G  17% /mnt/hgfs   shmfs                 1.0G     0  1.0G   0% /dev/shm *PROD DB 접속확인. SQL> startup force ORACLE instance started. Total System Global Area  417546240 bytes Fixed Size     2213936 bytes Variable Size   314574800 bytes Database Buffers   96468992 bytes Redo Buffers     4288512 bytes Database mounted. Database opened. SQL> select instance_name from v$instance;   INSTANCE_NAME ---------------- PROD