在Oracle 11g的ASM实例上删除diskgroup报错ORA-15027
在Oracle 11g 的ASM 实例上删除diskgroup 操作。
删除时报错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 CON