DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Friday, June 22, 2018

ORA-59303: The attribute compatible.asm (10.1.0.0.0) of the diskgroup being

Scenario : 
 I was assigned to do 12.2.0.1 upgrade from 12.1.0.1  for a Stand alone database .
After upgrading ASM instance to 12.2.0.1, we got the below issue.
SQL> startup
ASM instance started
Total System Global Area 1140850688 bytes
Fixed Size                  8629704 bytes
Variable Size            1107055160 bytes
ASM Cache                  25165824 bytes
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.
ORA-15221: ASM operation requires compatible.asm of 11.1.0.0.0 or higher
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.
ORA-15221: ASM operation requires compatible.asm of 11.1.0.0.0 or higher
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.
ORA-15221: ASM operation requires compatible.asm of 11.1.0.0.0 or higher

After checking the compatible for asm and DB using the below code.


  1* select name,DATABASE_COMPATIBILITY ,COMPATIBILITY from  v$asm_diskgroup
SQL> /
NAME                       DATABASE_COMPATIBILITY            COMPATIBILITY              
 DATA02                         0.0.0.0.0                       0.0.0.0.0                    REDO01                         0.0.0.0.0                       0.0.0.0.0              ARCHLOG01                      0.0.0.0.0                       0.0.0.0.0                  DATA01                         10.1.0.0.0                      12.1.0.0                           

Planned to change the compatible parameter to 12.2., We changed for all the disk group.
alter diskgroup ARCHLOG01 mount restricted;
alter diskgroup ARCHLOG01 set attribute 'compatible.asm'='12.2';
alter diskgroup ARCHLOG01 dismount;
alter diskgroup ARCHLOG01 mount;
SQL>  select name,DATABASE_COMPATIBILITY ,COMPATIBILITY from  v$asm_diskgroup;
NAME                           DATABASE_COMPATIBILITY        COMPATIBILITY     
 ARCHLOG01                      0.0.0.0.0                    0.0.0.0.0                          DATA01                         10.1.0.0.0                   12.1.0.0.0                          DATA02                         10.1.0.0.0                   12.2.0.0.0           REDO01                         10.1.0.0.0                   12.2.0.0.0                                                                                                                                                                                        

SQL> alter diskgroup ARCHLOG01 mount restricted;
Diskgroup altered.

SQL> alter diskgroup ARCHLOG01 set attribute 'compatible.asm'='12.2';
Diskgroup altered.

SQL> alter diskgroup ARCHLOG01 dismount;
Diskgroup altered.

SQL> alter diskgroup ARCHLOG01 mount;
Diskgroup altered.

No comments: