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也是这样子的。
阅读(1505) | 评论(0) | 转发(0) |