SHUTDOWN: waiting for active calls to complete.

今天有个数据库很繁忙，开发反应调度跑的很慢，
去os上观察，发现os的IO非常高，停掉调度任务后，仍然很高，
关掉所有应用，关掉监听，io依然很高，于是乎
决定关闭数据库重启，

结果遇到如下报错:

SHUTDOWN: waiting for active calls to complete.

Active call for process 26348 user 'oracle' program 'oracle@bi137'SHUTDOWN: waiting for active calls to complete.

解决过程：

[oracle@bi137 ~]$ ps -ef |grep  26348 oracle   26348     1 38 10:42 ?        00:40:04 oracleorcl (LOCAL=NO)oracle   32452 32397  0 12:27 pts/4    00:00:00 grep 26348[oracle@bi137 ~]$ kill -9 26348然后再去alert日志Wed Sep 20 12:28:30 2017All dispatchers and shared servers shutdownALTER DATABASE CLOSE NORMALWed Sep 20 12:28:38 2017SMON: disabling tx recoverySMON: disabling cache recoveryWed Sep 20 12:28:39 2017Shutting down archive processesArchiving is disabledArchive process shutdown avoided: 0 activeThread 1 closed at log sequence 1121Successful close of redo thread 1

官网的解释

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.

---

如果作者的文章帮助到您，您可以选择赞赏！