Tuesday, 9 July 2019

ORA-00845: MEMORY_TARGET not supported on this system

Increasing memory_target/max to 8G encountered this error.

Reason:
[oracle@osmdbuat1001 shm]$ df -hP .
Filesystem      Size  Used Avail Use% Mounted on
tmpfs           7.8G     0  7.8G   0% /dev/shm    <====Undersized


ORA-00845: MEMORY_TARGET not supported on this system

Solution:
mount -t tmpfs shmfs -o size=10g /dev/shm <=any value above 8G should work.


After above the instance mount/opens with no issues.