Errors and solution after Grid upgrade on standalone from 12.1.0.2.0 to 19.3.0.0.0.

ORA-15032: not all alterations performed

ORA-59303: The attribute compatible.asm (10.1.0.0.0) of the diskgroup being mounted should be 11.2.0.2.0 or higher

Overview of the issue

After successful grid upgrade from 12.1.0.2.0 to 19.3.0.0.0, ASM FRA disk group was not able to come to mount state.

SQL> select group_number, name, state, type from v$asm_diskgroup;

GROUP_NUMBER NAME STATE TYPE

———— —————————— ———– ——

0 FRA DISMOUNTED

1 DATA MOUNTED EXTERN

SQL> alter diskgroup FRA mount restricted;

Diskgroup altered.

SQL> select group_number, name, state, type from v$asm_diskgroup;

GROUP_NUMBER NAME STATE TYPE

———— —————————— ———– ——

1 DATA MOUNTED EXTERN

2 FRA RESTRICTED EXTERN

SQL> alter diskgroup FRA set attribute ‘compatible.asm’=’12.1.0.0.0’;

Diskgroup altered.

SQL>

SQL> col name for a10

SQL> col COMPATIBILITY for a12

SQL> set lines 100

SQL> select group_number, name,compatibility, database_compatibility from v$asm_diskgroup;

GROUP_NUMBER NAME COMPATIBILIT DATABASE_COMPATIBILITY

———— ———- ———— ————————————————————

1 DATA 12.1.0.0.0 10.1.0.0.0

2 FRA 12.1.0.0.0 10.1.0.0.0

SQL>