PROBLEM:

While creating a diskgroup , got ORA-15260: permission denied on ASM disk group error.


[oracle@19c]$ <span style="color: #ff0000;"><strong>sqlplus / as <span style="font-size: 20px;">SYSDBA</span></strong></span>

SQL*Plus: Release 19.0.0.0.0 - Production on Fri Jun 18 18:42:58 2021
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle. All rights reserved.

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> create diskgroup ARCH external redundancy disk '/dev/oracleasm/disks/ARCH';
create diskgroup ARCH external redundancy disk '/dev/oracleasm/disks/ARCH'
*
ERROR at line 1:
<span style="color: #ff0000;"><strong>ORA-15260: permission denied on ASM disk group
</strong></span>

SOLUTION:

We were connected to the ASM instance with SYSDBA. So it was throwing error.

While creating diskgroup , you should always connect with SYSASM.

[oracle@19c]$ <span style="color: #ff0000;"><strong>sqlplus / as <span style="font-size: 20px;">sysasm</span></strong></span>

SQL*Plus: Release 19.0.0.0.0 - Production on Fri Jun 18 18:42:58 2021
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle. All rights reserved.

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> <span style="color: #ff0000;"><strong>create diskgroup ARCH external redundancy disk '/dev/oracleasm/disks/ARCH';</strong></span>

Diskgroup created.

SEE ALSO: