ORA-15032: not all alterations performed

Error: While operating from the grid user in the EXADATA, We are getting this permission denied error.

[grid@qr01dbadm01 ~]$ sqlplus / as sysdba



SQL*Plus: Release 19.0.0.0.0 - Production on Thu Jan 25 06:43:24 2024

Version 19.9.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.9.0.0.0

SQL> alter diskgroup reco resize all size 608m rebalance power 1024;

alter diskgroup reco resize all size 608m rebalance power 1024

*

ERROR at line 1:

ORA-15032: not all alterations performed

ORA-15260: permission denied on ASM disk group

Cause: Not login with sysasm role

Solution: To perform ASM diskgroup activity, we must login with SYSASM role with SYS user:

sqlplus / as sysasm

[grid@qr01dbadm01 ~]$ sqlplus / as sysasm

SQL*Plus: Release 19.0.0.0.0 - Production on Thu Jan 25 06:43:24 2024

Version 19.9.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.9.0.0.0