重庆思庄Oracle、Redhat认证学习论坛

标题: "lsof" Output Shows Many 'oraagent_oracle.l10 (deleted)' [打印本页]

作者: 郑全    时间: 2016-7-22 22:21
标题: "lsof" Output Shows Many 'oraagent_oracle.l10 (deleted)'
[size=130%]
High Space Usage and "lsof" Output Shows Many  'oraagent_oracle.l10 (deleted)' in GI environment (文档 ID 1598252.1)

                               
登录/注册后可看大图



                               
登录/注册后可看大图

In this Document
Symptoms
Cause
Solution
References

Applies to:   Oracle Database - Enterprise Edition - Version 11.2.0.3 to 12.1.0.1 [Release 11.2 to 12.1]
Information in this document applies to any platform.
Symptoms
GI home high space usage observed from command "df", however, command "du" doesn't show which file is using all the space.
In this case, "df" shows it's 95% used (89GB), but "du" shows only 34GB.
"lsof" output shows many "oraagent_oracle.l10" were marked deleted, but since the handle is still open OS can not reclaim the space.
oracle 121508 oracle 5w REG 253,3 10564931 6178664 /u01/app/11.2.0.3/grid/log/dm01db01/agent/crsd/oraagent_oracle/oraagent_oracle.l10 (deleted)
oracle 121510 oracle 5w REG 253,3 10564931 6178664 /u01/app/11.2.0.3/grid/log/dm01db01/agent/crsd/oraagent_oracle/oraagent_oracle.l10 (deleted)

CauseThis is due to bug 17305100
While database was started by oraagent, the database processes inherit open file handles from the oraagent, but when the oraagent_oracle.l10 was deleted as expected with the normal GI log file rotation policy, those handles are not closed by the database processes
Duplicates: bug 14062031 bug 17034444
SolutionThe bug fix is included in 11.2.0.3 GI PSU9, 11.2.0.4 GI PSU1. For 12c, at the time of this writing, the issue is still being worked via bug 17387523
The workaround is to restart database or GI














欢迎光临 重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/) Powered by Discuz! X3.2