在关闭呼叫中心生产库(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.1Platforms 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)
MiscellaneousDescription
"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
全都是码,
Aaron —— 2010年01月24日@15:28