Chinaunix首页 | 论坛 | 博客
  • 博客访问: 664757
  • 博文数量: 168
  • 博客积分: 2928
  • 博客等级: 中校
  • 技术积分: 1904
  • 用 户 组: 普通用户
  • 注册时间: 2010-01-04 09:56
文章分类

全部博文(168)

文章存档

2010年(168)

我的朋友

分类: Oracle

2010-10-20 16:21:54

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) |
给主人留下些什么吧!~~