环境 oracle 11.2.0.1.0 rac

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

[grid@test1 ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.1.0 Production on Mon Jul 21 14:32:40 2014Copyright (c) 1982, 2009, Oracle.  All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit ProductionWith the Real Application Clusters and Automatic Storage Management optionsSQL> 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 groupSQL> select status from v$instance;STATUS------------STARTEDSQL> show userUSER is "SYS"

 

解决方法

SQL> conn / as sysasmSQL> 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用户来管理。