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用户来管理。