Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.


ORA-00845: MEMORY_TARGET not supported on this system

ORA-00845: MEMORY_TARGET not supported on this system

I have a RH5.0 Linux server that has oracle11g server running on it. I have just created a new database and when I try to start it I'm getting the following error message:-

ORA-00845: MEMORY_TARGET not supported on this system

I have increased the size of /dev/shm to 50GB and I'm still getting this error message, what can I do to resolve this issue?

In /etc/fstab i have made the following change:-

tmpfs                   /dev/shm                tmpfs   defaults,size=50G        0 0

and then did the following:-

mount -o remount /dev/shm

Or do I actually need to physically reboot the server?

RE: ORA-00845: MEMORY_TARGET not supported on this system

What is the output of a "df -k" command?  That should tell you whether /dev/shm is mounted and its current size.

RE: ORA-00845: MEMORY_TARGET not supported on this system


The output is below:-

tmpfs                  50G   26G   25G  52% /dev/shm

RE: ORA-00845: MEMORY_TARGET not supported on this system

My only 11g databases are on SLES 10, so I don't have a directly comparable setup to yours.  For me automatic memory management worked without a hitch.  For comparison, this is what I see on the O/S.


Filesystem           1K-blocks      Used Available Use% Mounted on
shmfs                  8388608    300560   8088048   4% /dev/shm

How much RAM do you have on your server?  50G seems like an awfully lot to allocate to shared memory, but it certainly looks as if your system is allowing it.

RE: ORA-00845: MEMORY_TARGET not supported on this system

The following is a link to an interesting article on Oracle 11g automatic memory management.  The author claims that /dev/shm has to be configured to be at least as large as MEMORY_MAX_TARGET.  If true and you set this parameter high enough, I suppose it's possible that you simply don't have a large enough /dev/shm.  Also, there is apparently an alert log entry when you get the ORA-00845 error.  What message is in your alert log?  Did it say how much shared memory Oracle thinks is available?

RE: ORA-00845: MEMORY_TARGET not supported on this system

I finally got round to solving this issue. When creating the databases using dbca I did not notice that the memory being allocated to the db's was 40% of the physical RAM ( this is 64GB ). I created four of these databases like this before I noticed what was going on. To resolve this I perfromed the following from within each database:-

Alter system set memory_target= 2000M scope=spfile;

then bounced the database and all was fixedsmile

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close