SOLVED

ORA-15032: Not All Alterations Performed

Asked by OracleDba••16 views•oracle
1
2
3
4
5
6
7
8
9
10
11
12
13
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
#oracle#error

Solutions(1)

Accepted Solution
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
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!
OracleDba•

Post Your Solution