Hi,
Sometimes you can get “ORA-15221: ASM operation requires compatible.asm of string or higher ” error.
Details of error are as follows.
ORA-15221: ASM operation requires compatible.asm of string or higher Cause: The ASM operation specified requires a higher disk group attribute value for compatible.asm. Action: Set the disk group attribute compatible.asm to or above the requested version. ORA-15221: ASM operation requires compatible.asm of 12.1.0.0.0 or higher
Check the database and ASM Compatibility.
SQL> select group_number, name,compatibility, database_compatibility from v$asm_diskgroup; GROUP_NUMBER NAME COMPATIBILITY DATABASE_COMPATIBILITY ------------ ----- ------------- ------------------------- 1 DATAC1 11.2.0.0.0 11.2.0.0.0 2 RECOC1 11.2.0.0.0 11.2.0.0.0
Change compatibility and database compatibility attributes of disk group as follows.
SQL> alter diskgroup DATAC1 set attribute 'compatible.asm'='12.1.0.0.0'; Diskgroup altered. SQL> alter diskgroup RECOC1 set attribute 'compatible.asm'='12.1.0.0.0'; Diskgroup altered. SQL> alter diskgroup DATAC1 set attribute 'compatible.rdbms'='12.1.0.0.0'; Diskgroup altered. SQL> alter diskgroup RECOC1 set attribute 'compatible.rdbms'='12.1.0.0.0'; Diskgroup altered.
Check disk groups attributes again, they are changed.
SQL> select group_number, name,compatibility, database_compatibility from v$asm_diskgroup; GROUP_NUMBER NAME COMPATIBILITY DATABASE_COMPATIBILITY ------------ ---- ------------- ------------------------- 1 DATA 12.1.0.0.0 12.1.0.0.0 2 FRA 12.1.0.0.0 12.1.0.0.0
Problem has been solved.
Do you want to learn Oracle Database for Beginners, then read the following articles.
https://ittutorial.org/oracle-database-19c-tutorials-for-beginners/