shutdown immediate关不了

SQL> shutdown immediate

。。。。。一直等待

 

警报日志：
[oracle@liumujing trace]$ more alert_bianxueqing.log
Thu Feb 21 16:34:55 2013
Shutting down instance (immediate)
Stopping background process SMCO
Shutting down instance: further logons disabled
Thu Feb 21 16:34:56 2013
Stopping background process CJQ0
Stopping background process QMNC
Stopping background process MMNL
Stopping background process MMON
License high water mark = 9
All dispatchers and shared servers shutdown
Thu Feb 21 16:36:05 2013
Instance shutdown cancelled
Shutting down instance (immediate)
Shutting down instance: further logons disabled
License high water mark = 9
All dispatchers and shared servers shutdown
Thu Feb 21 16:41:23 2013
SHUTDOWN: Active processes prevent shutdown operation
Thu Feb 21 16:46:33 2013
SHUTDOWN: Active processes prevent shutdown operation
Thu Feb 21 16:51:40 2013
SHUTDOWN: Active processes prevent shutdown operation
Thu Feb 21 16:56:49 2013
SHUTDOWN: Active processes prevent shutdown operation

从中可看出每隔5分钟出现一条
SHUTDOWN: Active processes prevent shutdown operation

模拟情境如下：

打开两个sqlplus 并以sys身份连接上去
以sqlplus1、sqlplus2表示

sqlplus2内容:

[oracle@liumujing ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Thu Feb 21 17:06:12 2013

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> host
[oracle@liumujing ~]$

sqlplus1内容:

SQL> shutdown immediate

---- 一直在等待，shutdown immediate被hang住

 

解决方法：

sqlplus2退出sys连接

[oracle@liumujing ~]$ exit
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@liumujing ~]$

sqlplus1:

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>