"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