Alert Log: Shutdown Waiting for Active Calls to Complete (Doc ID 1039389.6)

描述：使用shutdown immediate关闭数据库夯住，后台日志有这样的信息

参考Alert Log: Shutdown Waiting for Active Calls to Complete (Doc ID 1039389.6)

Shutting down instance (immediate)
Stopping background process SMCO
Shutting down instance: further logons disabled
Stopping background process QMNC
Thu Apr 27 22:17:54 2017
Stopping background process CJQ0
Stopping background process MMNL
Stopping background process MMON
License high water mark = 7
Thu Apr 27 22:22:56 2017
Active call for process 42121 user 'oracle' program 'oracle@orcl_adg'
SHUTDOWN: waiting for active calls to complete.

解决方法：

杀掉后台日志中说明的进程号

[oracle@orcl_adg ~]$ ps -ef|grep LOCAL=NO
oracle    42111      1  0 21:58 ?        00:00:00 oracleorcl (LOCAL=NO)
oracle    42115      1  0 21:58 ?        00:00:00 oracleorcl (LOCAL=NO)
oracle    42121      1  0 21:58 ?        00:00:00 oracleorcl (LOCAL=NO)
oracle    43225  38470  0 22:29 pts/4    00:00:00 grep LOCAL=NO
[oracle@orcl_adg ~]$ kill -9 42121

原因：

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.