ORA-00845: MEMORY_TARGET not supported on this system
May 23, 2017
Errors/Workarounds11g, Oracle Database Material
ERROR
SQL> startup nomount;
ORA-00845: MEMORY_TARGET not supported on this system
SOLUTION
[oracle@oel6 ~]$ df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/vg_oel6-lv_root
43G 15G 26G 37% /
tmpfs 1001M 212M 789M 22% /dev/shm
/dev/sda1 485M 55M 405M 12% /boot
.host:/ 245G 126G 119G 52% /mnt/hgfs
Change the size of that files System by issuing the following command:
mount -t tmpfs shmfs -o size=2g /dev/shm
The shared memory file system should be big enough to accommodate the MEMORY_TARGET and MEMORY_MAX_TARGET values, else Oracle will throw the ORA-00845 error.
Note: While changing something with the mount command, the changes are not permanent.
To make the change persistent, edit your /etc/fstab file
To make the change persistent, edit your /etc/fstab file
tmpfs /dev/shm tmpfs defaults,size=2G 0 0
Related Posts