oracle关闭不了,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 14447oracle   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 toclean them. The client connections to the server are causing the shutdownimmediate or normal to hang. Killing them allows pmon to clean up and releasethe associated Oracle processes and resources.