今天在做实验时,发现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=9803Setting 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