2010年01月24日 Bug 4632780@20100119

在关闭呼叫中心生产库(Oracle 10.2.0.1)时,数据库长时间挂起没有响应,告警日志持续报PMON failed to acquire latch:

Wed Jan 19 20:12:08 2010
Shutting down instance: further logons disabled
Wed Jan 19 20:12:08 2010
Stopping background process CJQ0
Wed Jan 19 20:12:08 2010
Stopping background process QMNC
Wed Jan 19 20:12:10 2010
Stopping background process MMNL
Wed Jan 19 20:12:11 2010
Stopping background process MMON
Wed Jan 19 20:12:13 2010
Shutting down instance (immediate)
License high water mark = 179
Wed Jan 19 20:12:13 2010
Stopping Job queue slave processes
Wed Jan 19 20:12:18 2010
Process OS id : 26272 alive after kill
Errors in file
Wed Jan 19 20:12:18 2010
Job queue slave processes stopped
All dispatchers and shared servers shutdown
Wed Jan 19 20:12:30 2010
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
Wed Jan 19 20:12:42 2010
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
Wed Jan 19 20:12:54 2010
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
Wed Jan 19 20:13:06 2010
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump

…………

metalink信息如下:

Bug 4632780 - PMON "failed to acquire latch" during shutdown

Affects:
Product (Component) Oracle Server (Rdbms)
Range of versions believed to be affected Versions < 11
Versions confirmed as being affected 9.2.0.7
10.1.0.5
10.2.0.1

Platforms affected Generic (all / most platforms affected)

Fixed:
This issue is fixed in 9.2.0.8 (Server Patch Set)
10.2.0.2 (Server Patch Set)
11g (Future version)
Symptoms: Related To:
(None Specified)
Miscellaneous

Description
"PMON failed to acquire latch" messages can appear in the alert log during shutdown.

对应的解决方法:

*Note: 345197.1

1. set INBOUND_CONNECT_TIMEOUT_(listener name)= 0 in listener.ora
2. set SQLNET.INBOUND_CONNECT_TIMEOUT = 0 in sqlnet.ora of server.
3. stop and start both listener and data base.
4. Re-run the Workflow Configuration Assistant

Rand Posts:



我们在天上的父
愿人都尊你的名为圣
愿你的国降临
愿你的旨意行在地上如同行在天上
我们将顺着你的指引前行
直至重归你的梯下


1 条评论



  1. 全都是码, 8) 8) 8)

    [ 引用 ]

发表评论

文明上网,共建和谐社会。