• VMware

    Learn about VMware virtualization for its products like vsphere ESX and ESXi, vCenter Server, VMware View, VMware P2V and many more

  • Linux

    Step by step configuration tutorials for many of the Linux services like DNS, DHCP, FTP, Samba4 etc including many tips and tricks in Red Hat Linux.

  • Database

    Learn installation and configuration of databases like Oracle, My SQL, Postgresql, etc including many other related tutorials in Linux.

  • Life always offers you a second chance ... Its called tomorrow !!!

    Friday, September 28, 2012

    How to Fix [ORA-00845: MEMORY_TARGET not supported on this system]

    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.

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

    /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.

    Increase the size of /dev/shm

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

    To increase the size
    # mount -o remount,size=3G /dev/shm
    Verify the size
    # 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
    # vi /etc/fstab
    tmpfs  /dev/shm  tmpfs  defaults,size=3G  0 0

    Update the new fstab file
    # mount -a

    Follow the below links for more helpful tutorials


    1. check size of /dev/shm and then size memory_target accordingly if u dont want to resize the mountpoint

    2. Thank you Resolve the issue

    3. When I run "df -h" I see tmpfs mapped to /run device. I also see that /dev/shm is mapped to "none".

      What do I do - because I am getting this same MEMORY_TARGET error?

      Please help. It is Oracle 11g installation on Ubuntu.