- 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.