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 2017
All dispatchers and shared servers shutdown
ALTER DATABASE CLOSE NORMAL
Wed Sep 20 12:28:38 2017
SMON: disabling tx recovery
SMON: disabling cache recovery
Wed Sep 20 12:28:39 2017
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 1121
Successful 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.

---

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