ORACLE – ORA-15260: permission denied on ASM disk group
Problema:
Você está conectado como SYSDBA e ao tentar interagir com o ASM recebe uma mensagem de access denied.
Ex:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production
With the Real Application Clusters and Automatic Storage Management optionsSQL> alter diskgroup VOTING rebalance;
alter diskgroup VOTING rebalance
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15260: permission denied on ASM disk group
Solução:
Ao invés de se conectar como SYSDBA, se conecte como SYSASM:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production
With the Real Application Clusters and Automatic Storage Management optionsSQL> alter diskgroup VOTING rebalance;
Diskgroup altered.
