DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Sunday, May 6, 2018

ORA-15260 While Creating an ASM Diskgroup in 11gR2

APPLIES TO :

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.4 [Release 11.2]

SYMPTOMS :

Running an ASM command and getting ORA-15260

SQL> conn / as sysdba 
Connected.
SQL> create diskgroup dg5 external redundancy disk '/dev/sda10','/dev/sda11';
create diskgroup dg5 external redundancy disk '/dev/sda10','/dev/sda11'
*
ERROR at line 1:
ORA-15260: permission denied on ASM disk group

SQL> alter diskgroup data rebalance power 11; 
alter diskgroup data rebalance power 11
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15260: permission denied on ASM disk group

CAUSE :

We have logged in with SYSDBA privilege, that is not allowed for ASM operations

SOLUTION :

Login with SYSASM credentials for ASM operations

SQL> conn / as sysasm 
Connected.


SQL> create diskgroup dg5 external redundancy disk '/dev/sda10','/dev/sda11'; 
Diskgroup created.

No comments: