Home > Oracle Rac > ORA-00845: MEMORY_TARGET not supported on this system

ORA-00845: MEMORY_TARGET not supported on this system

encountered the oracle error “ORA-00845: MEMORY_TARGET not supported on this system” on a 12c database recently and occurs when an instance tries to use AMM and tmpfs mount point is less than the value specified  in  parameter memory_max_target

to solve this issue we need to  unmount the tmpfs and mount with increased space for tmps and make sure that this change is made permanent by adding the enty in /etc/fstab


As root

# unmount  tmpfs

umount: /dev/shm: device is busy.
(In some cases useful info about processes that use
the device is found by lsof(8) or fuser(1))

# umount -l tmpfs

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

# vi /etc/fstab

# cat /etc/fstab

tmps       /dev/shm        tmpfs    size=10240m    0    0

# exit

 

Advertisements
Categories: Oracle Rac
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: