oracle设置shm,【翻译自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

标签：

本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉 本文系统来源：http://blog.csdn.net/msdnchina/article/details/50901865