【翻译自mos文章】/dev/shm应该设置多大Oracle 实例启动时才能不报ORA-00845

WARNING: You are trying to use the MEMORY_TARGET feature. 
This feature requires the /dev/shm file system to be mounted for at least 1073741824 bytes. 
/dev/shm is either not mounted or is mounted with available space less than this size. 
Please fix this so that MEMORY_TARGET can work as expected. 
Current available is 1049145344 and used is 430080 bytes. 
Ensure that the mount point is /dev/shm for this directory. memory_target needs larger /dev/shm

Here the alert log confirms:

current size : 1049145344 bytes
expected size: 1073741824 bytes (at least)

The current size of /dev/shm is also confirmed by the ‘df‘ command -- Current value

# df -k /dev/shm
Filesystem 1K-blocks Used Available Use% Mounted on
tmpfs 1024976 420 1024556 1% /dev/shm

To fix the current issue the solution would be to allocate at least 1073741824 bytes for /dev/shm.

# mount -t tmpfs shmfs -o size=1073741824 /dev/shm 
# df -k /dev/shm
Filesystem 1K-blocks Used Available Use% Mounted on
shmfs 1048576 0 1048576 0% /dev/shm

To retain the value across machine startups, make sure that the /etc/fstab mount database contains a reference to this new value, like in:

shmfs /dev/shm tmpfs size=1073741824 0

【翻译自mos文章】/dev/shm应该设置多大Oracle 实例启动时才能不报ORA-00845

标签：