background img
banner
May 2, 2013
491 Views
0 0

ORA-00845: MEMORY_TARGET not supported on this system

Written by
banner

Getting ORA-00845: MEMORY_TARGET not supported on this system, while trying to start a database.

Error
sql> startup
ORA-00845: MEMORY_TARGET not supported on this system

Reason:

This is a very common error which you might face while starting up your oracle database. This happens when your system is out of temporary storage. While starting up the database oracle uses /dev/shm to store temporary files but when it runs out of memory you get this error.

/dev/shm is also know as tmpfs i.e. temporary file system which keeps all the file system in virtual memory to speed up several processes.

Solution:

Increase the size of /dev/shm

To check the size of /dev/shm
root@localhost# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda3 10G 4.4G 2.9G 61% /
tmpfs 504M 76K 504M 1% /dev/shm
/dev/sda1 194M 25M 160M 14% /boot

To increase the size
root@localhost# mount -o remount,size=3G /dev/shm
Verify the size
root@localhost# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda3 7.6G 4.4G 2.9G 61% /
tmpfs 3G 1007M 2.1G 33% /dev/shm
/dev/sda1 194M 25M 160M 14% /boot

To make permanent changes to your file system update your fstab
root@localhost# vi /etc/fstab
tmpfs /dev/shm tmpfs defaults,size=3G 0 0

 

Update the new fstab file
root@localhost# mount -a
 

Article Tags:
·
Article Categories:
Databases · Errors · Linux · oracle
banner

Comments to ORA-00845: MEMORY_TARGET not supported on this system

  • Hi sandeep,

    Please post some common topics which people may face often in production such as,

    increasing ulimit value,
    About configuring Load Balancer,
    File system tuning,
    Analysing Workload on linux server.

    Thanks
    Nandu

    nandu May 7, 2013 12:39 pm Reply
  • Thank you 🙂

    Prakash Yaji October 26, 2013 11:04 am Reply
  • does it works on the mount points u01 ,u02 ,u03

    kranthi December 5, 2013 8:37 am Reply
  • hi sundeep
    thanks out put is good

    Pawan Kumar sharma

    Pawan kumar sharma May 7, 2014 4:13 pm Reply

Leave a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.