MEMORY_TARGET not supported on this system

I got this error when i reboot my OS linux system which contains an Oracle database instance. The database cannot start properly and the logs file shows this error:

SQL*Plus: Release 11.2.0.3.0 Production on Sat Nov 30 19:13:35 2013
Copyright (c) 1982, 2011, Oracle.  All rights reserved.
SQL> Connected to an idle instance.
SQL> ORA-00845: MEMORY_TARGET not supported on this system
SQL> Disconnected

To solve this issue, apply the following command as a root user

umount tmpfs
mount -t tmpfs shmfs -o size=16384m /dev/shm
service oracledb start

If you Oracle instance start correctly, make the change permanent in the /etc/fstab file

[root@localhost ~]# cat /etc/fstab 
/dev/VolGroup00/LogVol00 /                       ext3    defaults        1 1
LABEL=/boot             /boot                   ext3    defaults        1 2
tmpfs                   /dev/shm                tmpfs   size=16g        0 0
devpts                  /dev/pts                devpts  gid=5,mode=620  0 0
sysfs                   /sys                    sysfs   defaults        0 0
proc                    /proc                   proc    defaults        0 0
/dev/VolGroup00/LogVol01 swap                    swap    defaults        0 0
Advertisements

About Chenda Mok

19 years of hands on experience in software design and development with emphasis on Enterprise Application Integration (EAI), Services Oriented Architecture (SOA) and Identity Management (IDM) solutions. I’m a software engineer, member of the professional service delivery team working for Salesforce. Prior to this, I worked for Oracle as Solution Architect, through SeeBeyond(06/2005), then SUN’s acquisition (04/2009). After my master’s degree in computer science in 1997; I always delivered consulting on architecture, design, implementation on integration’s field. I’m interested in architecture using EAI/SOA/IDM/BPM/Cloud technologies, software development and Java’s related technologies. I may blog about my work/activities at Salesforce, but I do not speak for my employer, past, present or future.
This entry was posted in database, Linux, Operating System, oracle and tagged . Bookmark the permalink.