/dev/shm Filled Up With Files In Format JOXSHM_EXT_xxx_SID_xxx

简介:

  Oracle Server - Enterprise Edition - Version: 11.1.0.6 to 11.1.0.7 - Release: 11.1 to 11.1 Symptoms   /dev/shm is being filled up with files in the format JOXSHM_EXT_???_SID_???? and eventually causing the DB to restart. Oracle is not automatically cleaning those files. Please note that it is OS specific whether such segments are visible on a filesystem or not, and if so where they get placed. eg: On Solaris shm_open() internally creates a file in /tmp with the prefix .SHMD and less the leading "/" from the shm_open argument whereas on Linux it creates an entry in /dev/shm Changes Most probably the database has not been closed cleanly. Cause This issue has been described in << Bug.6820987 >> /DEV/SHM IS NOT BEING CLEANED UP ON NODE 1 which was closed as duplicate of Unpulished Bug.6662381 JOXSHM_EXT LEFT AFTER SHUTDOWN IMMEDIATE which was closed as duplicate of Unpublished Bug 9021155 APPSST GSI 11G: NATIVE PL/SQL CACHE FILES MAKES /TMP SLOW AND UNUSABLE It has been determined by development that the cause of such issue is due to the fact that the database has not be closed cleanly at some point in time. This has also been documented in the following documentation: http://download.oracle.com/docs/cd/E17116_01/doc/readmes.112/e11015/toc.htm#BABBCFHJ Solution The shared object files are only freed up by the oracle executable if you do a normal shutdown. They will build up if you shutdown abort or shutdown immediate. This behaviour is NOT changed in any version - or changed by the fix for unpublished Bug 9021155. 1. Check if the one off Patch 9021155 is available on My Oracle Support for your Oracle version and platform. The fix for Bug 902115 allows you to specify a directory so that if you have more then one instance on a machine you are able to identify the shared files associated with a particular instance, so that you do not inadvertently clean up files from another running instance.OR 2. Use one of the workarounds provided below: a. Rebooting the server from time to time as this clears those files OR b. In 11.1.0.7 the "id" part of the name is the shared memory id of the shared memory for the instance. eg: "ipcs -ma" ID column value is the "id" part of the name. This is not documented / guaranteed but does give a way to see if a file corresponds to a running instance. For the files that you have you should first check if the tail number matches to a valid SHM ID (as reported by ipcs -ma) .If not then the files are probably stale old copies and you can go ahead and delete those files. If so then those files are related to a currently running instance and deleting those files can lead to unpredictable results. Instead you can add the following code before you startup or after you shutdown the instance: rm -f /dev/shm/JOXSHM_EXT_*_<instance name>_* rm -f /dev/shm/PESHM_EXT_*_<instance name>_* Again please note that the directories referenced above are OS specific and should be modified according to your OS. The above applies to Linux.



本文转自maclean_007 51CTO博客,原文链接:http://blog.51cto.com/maclean/1277778

相关文章
|
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
262 1
|
7月前
|
Linux 固态存储
linux ext4-fs error,[求助]EXT4-fs error (device sdb4) ext4_find_entry
linux ext4-fs error,[求助]EXT4-fs error (device sdb4) ext4_find_entry
linux ext4-fs error,[求助]EXT4-fs error (device sdb4) ext4_find_entry
|
6月前
|
Java
Files.find 去除部分目录/dev/fd,/proc如何操作
在使用 `Files.find` 方法时,如果你想在搜索过程中排除特定目录,如 `/dev/fd` 和 `/proc`,可以在 `BiPredicate` 实现中添加相应的逻辑。以下是一个示例,演示如何在 `Files.find` 中排除这些目录: ```java import java.io.IOException; import java.nio.file.Files; import java.nio.file.Path; import java.nio.file.Paths; import java.nio.file.attribute.BasicFileAttributes; imp
|
Unix 应用服务中间件 nginx
安装nginx:src/os/unix/ngx_user.c:26:7: error: ‘struct crypt_data’ has no member named ‘curren
安装nginx:src/os/unix/ngx_user.c:26:7: error: ‘struct crypt_data’ has no member named ‘curren
1014 1
安装nginx:src/os/unix/ngx_user.c:26:7: error: ‘struct crypt_data’ has no member named ‘curren
完美解决common_define.h: No such file or directory
完美解决common_define.h: No such file or directory
242 0
完美解决common_define.h: No such file or directory
ROOT_DIR=os.path.abspath(os.path.join(p, '..', 'data/raw/'))代码含义
这行代码的作用是设置一个名为 ROOT_DIR 的变量,其值为指向项目根目录下的"data/raw/"目录的绝对路径。下面是对每个部分的详细解释: os.path.abspath():这个函数返回参数路径的绝对路径,也就是完整路径,包括盘符或根目录和所有子目录。 os.path.join(p, '..', 'data/raw/'):这个函数使用操作系统特定的路径分隔符将参数连接起来,并返回一个新的路径。这里,它连接了当前工作目录(也就是代码所在的目录)的父目录("..") 和"data/raw/",生成了一个相对路径。 p:这是一个之前定义过的变量,代表了当前工作目录的路径。 ROOT_DI
152 0
configure: error: Can‘t find ext2fs library
configure: error: Can‘t find ext2fs library
246 0
|
Ubuntu Shell
解决dpkg: warning: files list file for package(libboost-dev libpcl-dev)
解决dpkg: warning: files list file for package(libboost-dev libpcl-dev)
304 0
CentOS cp 复制隐藏文件提示 cp: cannot stat ?.xxx*?. No such file or directory
执行的命令与错误信息: # cp -a /etc/skel/* /home/postgrescp: cannot stat ?.etc/skel/*?. No such file or directory 使用cp复制普通文件时,可以使用 * 号通配符,而在复制隐藏文件时,需要使用.
4693 0
|
Linux
【Linux】locate: can not stat () `/var/lib/mlocate/mlocate.db‘: No such file or directory
【Linux】locate: can not stat () `/var/lib/mlocate/mlocate.db‘: No such file or directory
211 0
【Linux】locate: can not stat () `/var/lib/mlocate/mlocate.db‘: No such file or directory