ORA-15260: permission denied on ASM disk group

If you are connected to your ASM instance with SYSDBA & try to add disk to your existing diskgroup then mentioned error will be appeared.

Workaround for the oracle error: ‘ORA-15260: permission denied on ASM disk group’ & ‘ORA-15032: not all alterations performed’ is to connect your ASM instance as SYSASM.

// Please consider following example, in which i was failed to alter existing ASM diskgroup with as SYSDBA: ( In my case DATA is my existing DG )
[root@database1 ~]# su – oracle
[oracle@database1 ~]$ grid_env
[oracle@database1 grid]$ echo $ORACLE_HOME
/u01/app/11.2.0/grid
[oracle@database1 ~]$ sqlplus “/ as sysdba”

SQL*Plus: Release 11.2.0.3.0 Production on Tue May 20 14:54:00 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
With the Real Application Clusters and Automatic Storage Management options

SQL> ALTER DISKGROUP DATA ADD DISK ‘/dev/oracleasm/disks/RMAN’ NAME DATA_0003 REBALANCE POWER 11;
ALTER DISKGROUP DATA ADD DISK ‘/dev/oracleasm/disks/RMAN’ NAME DATA_0003 REBALANCE POWER 11
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15260: permission denied on ASM disk group

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
With the Real Application Clusters and Automatic Storage Management options
// Now connect ASM instance as SYSASM as follow:

[oracle@database1 ~]$ grid_env

[oracle@database1 ~]$ sqlplus “/ as sysasm”

SQL*Plus: Release 11.2.0.3.0 Production on Tue May 20 14:54:38 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
With the Real Application Clusters and Automatic Storage Management options

SQL> ALTER DISKGROUP DATA ADD DISK ‘/dev/oracleasm/disks/RMAN’ NAME DATA_0003 REBALANCE POWER 11;

Diskgroup altered.

SQL>

 

Enjoy… 🙂

***********************************************************************
Note: Please don’t hesitate to revert in case of any query OR feedback.

Thanking you.

Have a easy life ahead.

One thought on “ORA-15260: permission denied on ASM disk group

Leave a Reply to GF Cancel reply

%d bloggers like this: