ORA-15032: Not All Alterations Performed

Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
  • User AvatarANKUSH THAVALI
  • 03 Dec, 2023
  • 0 Comments
  • 24 Secs Read

ORA-15032: Not All Alterations Performed

SQL> alter diskgroup TEMPDG set attribute ‘compatible.asm’=’12.1.0.0.0’;
alter diskgroup TEMPDB set attribute ‘compatible.asm’=’12.1.0.0.0’
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15260: permission denied on ASM disk group

Solution:
Alter operations on ASM diskgroups need to be done from sysman user , instead of sysdba user.
SQL> connect / as sysasm
Connected.
SQL> SQL> alter diskgroup TEMPDG set attribute ‘compatible.asm’=’12.1.0.0.0’;
Diskgroup altered.
SQL> alter diskgroup TEMPDG set attribute ‘compatible.rdbms’=’12.1.0.0.0’;
Diskgroup altered.

Hope it Helps!