/dev/shm过小导致ORA-00845错误解决方法

简介: The workaround, if you encounter the ORA-00845 error, is to increase the /dev/shmmountpoint size.For example:# mount -t tmpfs shmfs -o size=7g /dev/sh...

The workaround, if you encounter the ORA-00845 error, is to increase the /dev/shm
mountpoint size.
For example:
# mount -t tmpfs shmfs -o size=7g /dev/shm
To make this change persistent across system restarts, add an entry in /etc/fstab
similar to the following:
shmfs /dev/shm tmpfs size=7g 0

 

Starting with Oracle Database 11g, the Automatic Memory Management feature
requires more shared memory (/dev/shm)and file descriptors. The size of the shared
memory must be at least the greater of the MEMORY_MAX_TARGET and MEMORY_
TARGET parameters for each Oracle instance on the computer. If the MEMORY_MAX_
TARGET parameter or the MEMORY_TARGET parameter is set to a non-zero value, and
an incorrect size is assigned to the shared memory, it results in an ORA-00845 error at
startup. On Linux systems, if the operating system /dev/shm mount size is too small
for the Oracle system global area (SGA) and program global area (PGA), it will result
in an ORA-00845 error.
The number of file descriptors for each Oracle instance must be at least
512*PROCESSES. The limit of descriptors for each process must be at least 512. If file
descriptors are not sized correctly, you will see an ORA-27123 error from various
Oracle processes and potentially Linux Error EMFILE (Too many open
files)in non-Oracle processes.
To determine the amount of shared

目录
相关文章
|
Docker 容器
Docker错误:inotify_add_watch(7, /dev/dm-4, 10) failed: No such file or directory
Docker错误:inotify_add_watch(7, /dev/dm-4, 10) failed: No such file or directory
266 1
|
4月前
crash命令 —— dev
crash命令 —— dev
|
网络协议
VFS: Cannot open root device "nfs" or unknown-block(0,255)错误解决
VFS: Cannot open root device "nfs" or unknown-block(0,255)错误解决
578 0
|
存储 Oracle 关系型数据库
Linux 一键配置 Oracle 主机 /dev/shm
首先可以看出来/dev/shm是一个设备文件, 可以把/dev/shm看作是系统内存的入口, 可以把它看做是一块物理存储设备,一个tmp filesystem, 可以通过这个设备向内存中读写文件, 以加快某些I/O高的操作,比如对一个大型文件频繁的open, write, read!
|
Linux 虚拟化
【Centos】 kernel panic-not syncing:VFS:Unable to mount root fs on unknown block
背景: VMware虚拟机下 原因: 在命令执行(update)途中,强制中断并直接运行poweroff命令关机。再次开机出现如图所示故障指示: 根据提示信息分析,可能因为执行更新命令未完成导致系统内核信息混乱。
4000 0