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.