在11g的ASM实例下删除diskgroup报错ORA-15027
日期：2014-05-16 浏览次数：20463 次
在11g 的ASM 实例上删除diskgroup 操作。
(墙外：http://mikixiyou.blogspot.com/2012/05/11gasmdiskgroupora-15027.html )
（墙内:http://mikixiyou.iteye.com/blog/1511127 ）
删除时报错ORA-15027: active use of diskgroup precludes its dismount ，如下：
SQL> drop diskgroup webdg including contents;
drop diskgroup webdg including contents
*
ERROR at line 1:
ORA-15039: diskgroup not dropped
ORA-15027: active use of diskgroup "WEBDG" precludes its dismount
在删除之前我已经关闭了数据库实例，ASM 实例上还会有什么客户端连接呢？
SQL> select * from v$asm_client;
?
GROUP_NUMBER INSTANCE_NAME
------------ ----------------------------
DB_NAME ?STATUS
-------- ------------
SOFTWARE_VERSION
------------------------
COMPATIBLE_VERSION
------------------------
? ? ? ? ? ?1 +ASM2
+ASM ? ? CONNECTED
11.2.0.1.0
11.2.0.1.0
?
?
GROUP_NUMBER INSTANCE_NAME
------------ ----------------------------
DB_NAME ?STATUS
