SHUTDOWN: Active processes prevent shutdown operation

今天在做实验时，发现Oracle 没法shutdown immediate, 

查看alert log, 发现SHUTDOWN: Active processes prevent shutdown operation. 

[oracle@localhost trace]$ tail -f alert_yang01.log 

CJQ0 started with pid=21, OS id=9803 
Setting Resource Manager plan SCHEDULER[0x3007]:DEFAULT_MAINTENANCE_PLAN via scheduler window
Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
Starting background process VKRM
Sat Mar 29 00:04:23 2014
VKRM started with pid=22, OS id=9805 
Sat Mar 29 00:09:19 2014
Starting background process SMCO
Sat Mar 29 00:09:19 2014
SMCO started with pid=23, OS id=9844 
Sat Mar 29 00:16:54 2014
Shutting down instance (immediate)
Stopping background process SMCO
Shutting down instance: further logons disabled
Sat Mar 29 00:16:55 2014
Stopping background process CJQ0
Stopping background process QMNC
Stopping background process MMNL
Stopping background process MMON
License high water mark = 4
All dispatchers and shared servers shutdown
Sat Mar 29 00:22:00 2014

SHUTDOWN: Active processes prevent shutdown operation

Google下，原因在于，有其他的session 连到了数据库，并切换到了host OS命令行下。

断开其他的session 连接后，DB shutdown 成功

SHUTDOWN: Active processes prevent shutdown operation
Sat Mar 29 00:31:14 2014
ALTER DATABASE CLOSE NORMAL
Sat Mar 29 00:31:14 2014
SMON: disabling tx recovery
SMON: disabling cache recovery
Sat Mar 29 00:31:14 2014
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 7
Successful close of redo thread 1
Completed: ALTER DATABASE CLOSE NORMAL
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Sat Mar 29 00:31:14 2014
Stopping background process VKTM: 
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Sat Mar 29 00:31:16 2014
Instance shutdown complete