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

Issue while converting memory parameter as following:

Note: I re-created the same issue in one of the test instance like below:

ORA-00845: MEMORY_TARGET not supported on this system

SQL> alter system set memory_max_target=8GB scope=spfile;
System altered.
SQL> alter system set memory_target=8GB scope=spfile;
System altered.

 SQL> startup ;
ORA-00845: MEMORY_TARGET not supported on this system

From the Oracle documents, I found to increase the "tmpfs" size to work. I did the same and it is working fine.

Check the following Space :
# df -h

Filesystem            Size  Used Avail Use% Mounted on
/dev/sda3              30G  459M   28G   2% /
/dev/sda9              20G  566M   18G   4% /var
/dev/sda8              20G  5.8G   13G  32% /usr
/dev/sda7              20G   13G  5.9G  69% /opt
/dev/sda6              25G  5.5G   18G  24% /home
/dev/sda2             126G   48G   72G  40% /oracle
/dev/sda1              99M   13M   82M  13% /boot
tmpfs                 3.0G     0  3.0G   0% /dev/shm


Increase the space
e.g.,

# mount -t tmpfs shmfs -o size=8192m /dev/shm

Now startup the database. Here I increased /dev/shm value as 8GB.

Note: memory_target value can be set upto current /dev/shm value. If you want to increase memory_target value then first increase /dev/shm value then increase memory_target value.



Hope it may help you.