Oracle關閉不了，SHUTDOWN: waiting for active calls to complete

Mon Aug 13 18:27:04 CST 2012
Shutting down instance (immediate)
Mon Aug 13 18:27:04 CST 2012
Shutting down instance: further logons disabled
Mon Aug 13 18:27:04 CST 2012
Stopping background process CJQ0
Mon Aug 13 18:27:04 CST 2012
Stopping background process QMNC
Mon Aug 13 18:27:05 CST 2012
Stopping background process MMNL
Mon Aug 13 18:27:06 CST 2012
Stopping background process MMON
License high water mark = 150
Mon Aug 13 18:27:08 CST 2012
Job queue slave processes stopped
Mon Aug 13 18:32:07 CST 2012
Active call for process 14447 user 'oracle' program
System State dumped to trace file /u01/oracle/app/admin/XXXXXX/udump/XXXXXX_ora_20315.trc
SHUTDOWN: waiting for active calls to complete.

 

[root@oracle arch]# ps -ef |grep oracle
oracle    1754     1  0 May11 ?        00:00:00 oracleXXXXXX (LOCAL=NO)
oracle    2404     1  0 May08 ?        00:00:00 oracleXXXXXX (LOCAL=NO)
oracle    3604     1  0  2011 ?        00:04:54 ora_pmon_XXXXXX
oracle    3606     1  0  2011 ?        00:00:34 ora_psp0_XXXXXX
oracle    3608     1  0  2011 ?        00:00:16 ora_mman_XXXXXX
oracle    3610     1  0  2011 ?        00:16:07 ora_dbw0_XXXXXX
oracle    3612     1  0  2011 ?        01:20:35 ora_lgwr_XXXXXX
oracle    3614     1  0  2011 ?        00:29:32 ora_ckpt_XXXXXX
oracle    3616     1  0  2011 ?        00:28:23 ora_smon_XXXXXX
oracle    3618     1  0  2011 ?        00:00:19 ora_reco_XXXXXX
oracle    3626     1  0  2011 ?        00:00:00 ora_d000_XXXXXX
oracle    3628     1  0  2011 ?        00:00:00 ora_s000_XXXXXX
oracle    3631     1  0  2011 ?        00:03:16 ora_rvwr_XXXXXX
oracle    3634     1  0  2011 ?        00:02:17 ora_arc0_XXXXXX
oracle    3636     1  0  2011 ?        00:02:19 ora_arc1_XXXXXX
oracle   14447     1  0 10:30 ?        00:00:00 oracleXXXXXX (LOCAL=NO)
oracle   18121     1  0 17:52 ?        00:00:00 oracleXXXXXX (LOCAL=NO)
oracle   18131     1  0 17:53 ?        00:00:00 oracleXXXXXX (LOCAL=NO)
oracle   18531     1  0 17:58 ?        00:00:00 oracleXXXXXX (LOCAL=NO)
oracle   18575     1  0 18:00 ?        00:00:00 oracleXXXXXX (LOCAL=NO)
oracle   18943     1  0 18:03 ?        00:00:00 oracleXXXXXX (LOCAL=NO)
oracle   19300     1  0 18:07 ?        00:00:00 oracleXXXXXX (LOCAL=NO)
oracle   19378     1  0 18:10 ?        00:00:00 oracleXXXXXX (LOCAL=NO)
root     20281 20253  0 18:23 pts/0    00:00:00 su - oracle
oracle   20282 20281  0 18:23 pts/0    00:00:00 -bash
oracle   20313 20282  0 18:23 pts/0    00:00:00 /usr/bin/perl -w /usr/bin/uniread sqlplus /nolog
oracle   20314 20313  0 18:23 pts/1    00:00:00 sqlplus      
oracle   20315 20314  1 18:23 ?        00:00:10 oracleXXXXXX (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle   20324     1  0 18:23 ?        00:00:00 oracleXXXXXX (LOCAL=NO)
oracle   20326     1  0 18:24 ?        00:00:00 oracleXXXXXX (LOCAL=NO)
root     20712 20684  0 18:26 pts/2    00:00:00 su - oracle
oracle   20713 20712  0 18:26 pts/2    00:00:00 -bash
oracle   20747 20713  0 18:27 pts/2    00:00:00 tail -f alert_XXXXXX.log
root     21125 20768  0 18:36 pts/3    00:00:00 grep oracle
oracle   30121     1  0  2011 ?        01:53:03 /u01/oracle/app/product/10.2.0/db_1/bin/tnslsnr LISTENER -inherit

 

[root@oracle arch]# ps -ef |grep oracle |grep 14447
oracle   14447     1  0 10:30 ?        00:00:00 oracleXXXXXX (LOCAL=NO)
[root@oracle arch]# kill -9  14447
[root@oracle arch]# ps -ef |grep oracle |grep 14447

 

上metalink查詢了一下這個問題，解決方法也是kill程式，對這個問題的解釋如下：

Explanation: 

============ 

The database is waiting for pmon to clean up processes, but pmon is unable to 

clean them. The client connections to the server are causing the shutdown 

immediate or normal to hang.  Killing them allows pmon to clean up and release 

the associated Oracle processes and resources.

 

reference: http://blog.vsharing.com/songtao1971/A784641.html