Oracle shutdown immedate: waiting for active calls to complete

今天在使用shutdown immediate命令关闭oracle数据库时停住不动了, 查看了一下bdump文件的内容:

show parameter background_dump_dest
tail $bdump_file

内容显示: SHUTDOWN: waiting for active calls to complete. 使用以下命令可解决该问题:

sqlplus / as sysdba
shutdown abort;
startup restrict;
shutdown immediate;

另外查询了oracle support上关于该问题的说明1039389.6:

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.

可以通过kill掉相关的进程来解决这个问题, 具体本人没有尝试过.

--EOF--