11G的SYS在同一窗口连接阻止SHUTDOWN IMMEDIATE关闭数据库

11G的SYS在同一窗口连接阻止SHUTDOWN IMMEDIATE关闭数据库

现象：
在同一个终端里，首先用sqlplus / as sysdba,用！或host退出sqlplus，再用sqlplus / as sysdba进

入时用shutdown immediate来关闭数据库时。会hang住，关闭不了。

*这时开另外一个终端用sqlplus / as sysdba进入进，会提示下面的结果：
[oracle@rac1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Wed Oct 20 16:02:58 2010

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

Connected.
SQL>
*用ctrl+c取消shutdown immediate;操作如下：
SQL> shutdown immediate;
ORA-01013: user requested cancel of current operation

*这时在另外一个终端用sqlplus / as sysdba进入，提示如下：

[oracle@rac1 trace]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Wed Oct 20 16:04:39 2010

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, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options

SQL> select status from v$instance;

STATUS
------------
OPEN

前面运行的shutdown immediate不管理运行了多久，也就是等于没有运行过一样。

*alter_rac.log文件里有如下的信息。
Shutting down instance: further logons disabled
Wed Oct 20 15:46:21 2010
Stopping background process CJQ0
Stopping background process QMNC
Stopping background process MMNL
Stopping background process MMON
License high water mark = 23
All dispatchers and shared servers shutdown
Wed Oct 20 15:51:26 2010
SHUTDOWN: Active processes prevent shutdown operation

处理方法：

ctrl+c取消shutdown immediate;

取消后打开一个新的终端。再运行：shutdown immediate;就可以了。

 

 

 

还要说明一点是。10.2.5也是这样子的。