标题: 关闭数据库时SHUTDOWN: waiting for active calls to complete [打印本页] 作者: mahan 时间: 2023-7-16 15:51 标题: 关闭数据库时SHUTDOWN: waiting for active calls to complete 有时候在关闭数据库时,发出shutdown immediate;命令后一直未关闭,查看ALERT日志,在等待一段时间后日志中有提示:
SHUTDOWN: waiting for active calls to complete.
原因是有些进程无法被PMON进程清理,导致SHUTDOWN时无法关闭而HANG住。
==》根据观察,在ORACLE10G及以上版本,会是如下提示: (2015/11/24最新验证ORACLE9206中也会提示进程号)
Active call for process 12345 user 'oracle' program 'oracle@abcd'
SHUTDOWN: waiting for active calls to complete.
也就是指出哪个进程引起的等待,此时kill -9 12345 进程即可。
Sun Jul 26 21:42:38 2015
ARC0: Beginning to archive log# 6 seq# 393635
ARC0: Completed archiving log# 6 seq# 393635
Sun Jul 26 21:42:54 2015
Shutting down instance (immediate)
License high water mark = 235
Sun Jul 26 21:48:02 2015
SHUTDOWN: waiting for active calls to complete.
这种情况下,只好查找 ps -ef|grep LOCAL=NO 相关进程都kill掉等处理思路。