ORA-15260: permission denied on ASM disk group

今天在用vbox安装11g R2 +ASM的时候，

由于在创建虚拟磁盘的时候，不小心划成了动态分配空间大小的，导致在安装数据库的时候，出现了报错。重新创建磁盘，并且重新创建ASM磁盘组。

 

[grid@odd ~]$ sqlplus / as sysdba

 

SQL*Plus: Release 11.2.0.1.0 Production on Sun Aug 18 15:22:40 2013

 

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

 

 

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Automatic Storage Management option

 

SQL> drop diskgroup DATA force including contents;

drop diskgroup DATA force including contents

*

ERROR at line 1:

ORA-15260: permission denied on ASM disk group

 

 

SQL> show user

USER is "SYS"

SQL> drop diskgroup FRA force including contents;

drop diskgroup FRA force including contents

*

ERROR at line 1:

ORA-15260: permission denied on ASM disk group

 

 

SQL>  conn / as sysasm

Connected.

SQL> drop diskgroup DATA force including contents;

 

Diskgroup dropped.

 

原因：

SYSDBA privilege不允许进行ASM操作。