暂无图片
PMON failed to acquire latch, see PMON dump instance crash
我来答
分享
用户5935
2020-05-18
PMON failed to acquire latch, see PMON dump instance crash
暂无图片 5M

Sat May 16 11:55:50 2020
Archived Log entry 58025 added for thread 1 sequence 121377 ID 0x4bd15c34 dest 1:
Sat May 16 12:00:00 2020
Setting Resource Manager plan SCHEDULER[0x334B]:DEFAULT_MAINTENANCE_PLAN via scheduler window
Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
Sat May 16 12:00:00 2020
Starting background process VKRM
Sat May 16 12:00:00 2020
VKRM started with pid=914, OS id=165411
Sat May 16 12:00:07 2020
Thread 1 advanced to log sequence 121379 (LGWR switch)
Current log# 1 seq# 121379 mem# 0: /u01/app/oracle/oradata/atlas/redo1atlas.dbf
Current log# 1 seq# 121379 mem# 1: /u01/app/oracle/oradata/atlas/redo1atlas.bak
Sat May 16 12:00:08 2020
Archived Log entry 58026 added for thread 1 sequence 121378 ID 0x4bd15c34 dest 1:
Sat May 16 12:01:18 2020
PMON failed to acquire latch, see PMON dump
Sat May 16 12:02:18 2020
PMON failed to acquire latch, see PMON dump
Sat May 16 12:52:41 2020

数据库12:02分左右发生重启

我来答
添加附件
收藏
分享
问题补充
7条回答
默认
最新
用户5935
暂无图片 评论
暂无图片 有用 0
用户5935
上传附件:orac_pmon_39939.trc
暂无图片 评论
暂无图片 有用 0
盖国强

Trace 里没有详细的信息,无法判断。

你从 awr 里生成个报告分析一下,同时生成最后的时点ash报告。应该能看出问题。

暂无图片 评论
暂无图片 有用 0
用户5935

盖老师 您好:我们数据库是standard版的 没办法收集awr日志。

暂无图片 评论
暂无图片 有用 0
用户5935
暂无图片 评论
暂无图片 有用 0
用户5935
暂无图片 评论
暂无图片 有用 0
用户5935

According to alert log, Sat May 16 12:01:18 PMON failed to acquire latch. 
 According to the PMON trace, PMON appears to be blocked by orapid=517 ospid=38298, 
and blocker session appears to be doing heap allocation during PARSE phase. 
And blocker process 38298 disappeared after May 16 10:59:57, and no information 
dump in systemstate trace file. No error happen around May 16 10:59:57 in alert log.

Action Plan 1 
------------------------------------------------------------

  1. Please confirm if there is any session killing around May 16 11:00.

  2. If possible, collect systemstate dump trac earlier when reoccurring next time.

For possible reason, the parsing session was terminated abnormally, and its share pool 
latch holden did not be released properly, and caused PMON process cannot acquire 
the latch. So it seems to be session cleanup problem. Based on this symptom, I found 
following bug, that may cause dead session not being cleanup properly.

Action Plan 2 
------------------------------------------------------------ 
1.If possible, please consider to apply patch of Bug 24739928 that may help to avoid this problem.

2.If session was killed, please avoid to kill session in future.

[Reference] 
Bug 24739928 - ORA-7445 [kglMutexCleanupAll] with fix for Bug 13542050 ( Doc ID 24739928.8 )

暂无图片 评论
暂无图片 有用 0
回答交流
提交
问题信息
请登录之后查看
附件列表
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏