PROBLEM:

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


[oracle@19c]$ sqlplus / as SYSDBA

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:
ORA-15260: permission denied on ASM disk group

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]$ sqlplus / as sysasm

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';

Diskgroup created.

SEE ALSO: