While setting attribute on a ASM diskgroup, we got below error.
oracle@crmcpredb1:~$ echo $ORACLE_SID +ASM1 oracle@crmcpredb1:~$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Fri Sep 16 11:19:25 2016 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production With the Real Application Clusters and Automatic Storage Management options SQL> 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.
