ORA-15260: permission denied on ASM disk group

环境 oracle 11.2.0.1.0 rac

添加ASM磁盘组时报错 ora-15260 permission denied on ASM disk group,操作过程如下

[grid@test1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Mon Jul 21 14:32:40 2014
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 Real Application Clusters and Automatic Storage Management options

SQL> create diskgroup dg_ext1 external redundancy
  2  disk '/dev/asm-diskg';
create diskgroup dg_ext1 external redundancy
*
ERROR at line 1:
ORA-15260: permission denied on ASM disk group

SQL> select status from v$instance;
STATUS
------------
STARTED
SQL> show user
USER is "SYS"

 

解决方法

SQL> conn / as sysasm
SQL> create diskgroup dg_ext1 external redundancy
  2  disk '/dev/asm-diskg';
Diskgroup created.

 

说明

　　sysasm用户是11g r2中引入的新的用户，用于专门管理ASM，对应的OS用户是OSASM。在11g r1还是可以使用sysdba用户连接ASM实例的，到了11g r2 就完全由sysasm用户来管理。