2 Replies Latest reply: Nov 29, 2012 7:49 PM by 747773 RSS

    linux redhat 5平台下,oracle 10.2.0.5 rac数据库关闭时hang住

    747773
      linux redhat 5平台下,oracle 10.2.0.5 rac数据库关闭时hang住

      alert日志:

      ......

      Sun Nov 18 23:14:39 CST 2012
      Shutting down instance (immediate)
      Starting background process EMN0
      Sun Nov 18 23:14:39 CST 2012
      Shutting down instance: further logons disabled
      Sun Nov 18 23:14:39 CST 2012
      Stopping background process QMNC
      Sun Nov 18 23:14:39 CST 2012
      Stopping background process CJQ0
      EMN0 started with pid=34, OS id=4968
      Sun Nov 18 23:14:41 CST 2012
      Stopping background process MMNL
      Sun Nov 18 23:14:42 CST 2012
      Stopping background process MMON
      License high water mark = 7
      Sun Nov 18 23:14:42 CST 2012
      Job queue slave processes stopped
      All dispatchers and shared servers shutdown
      此时,数据库shutdown immediate命令处于等待状态,oradebug hanganalyze信息如下:

      *** 2012-11-18 23:28:47.465
      ==============
      HANG ANALYSIS:
      ==============
      Open chains found:
      Other chains found:
      Chain 1 : <cnode/sid/sess_srno/proc_ptr/ospid/wait_event> :
      <0/147/36/0x3422e280/8668/ksdxexeother>
      Chain 2 : <cnode/sid/sess_srno/proc_ptr/ospid/wait_event> :
      <0/169/1/0x3422978c/13915/DIAG idle wait>
      Extra information that will be dumped at higher levels:
      [level  5] : 2 node dumps -- [SINGLE_NODE] [SINGLE_NODE_NW] [IGN_DMP]
      [level 10] : 15 node dumps -- [IGN]

      State of nodes
      ([nodenum]/cnode/sid/sess_srno/session/ospid/state/start/finish/[adjlist]/predecessor):
      [146]/0/147/36/0x3431b5f8/8668/SINGLE_NODE/1/2//none
      [148]/0/149/1/0x3431ddb8/13991/IGN/3/4//none
      [149]/0/150/1/0x3431f198/13981/IGN/5/6//none
      [151]/0/152/3/0x34321958/14087/IGN/7/8//none
      [153]/0/154/1/0x34324118/13972/IGN/9/10//none
      [155]/0/156/1/0x343268d8/13950/IGN/11/12//none
      [158]/0/159/1/0x3432a478/13944/IGN/13/14//none
      [159]/0/160/1/0x3432b858/13942/IGN/15/16//none
      [160]/0/161/1/0x3432cc38/13939/IGN/17/18//none
      [161]/0/162/1/0x3432e018/13937/IGN/19/20//none
      [162]/0/163/1/0x3432f3f8/13935/IGN/21/22//none
      [164]/0/165/1/0x34331bb8/13926/IGN/23/24//none
      [165]/0/166/1/0x34332f98/13924/IGN/25/26//none
      [166]/0/167/1/0x34334378/13922/IGN/27/28//none
      [167]/0/168/1/0x34335758/13917/IGN/29/30//none
      [168]/0/169/1/0x34336b38/13915/SINGLE_NODE/31/32//none
      [169]/0/170/1/0x34337f18/13911/IGN/33/34//none
      ====================
      END OF HANG ANALYSIS
      ====================

      会话147就是关闭数据库shutdown,ksdxexeother等待事件是什么?为何数据库无法关闭?

      麻烦大师帮分析下,感谢!