Category Archives: Oracle

In this we are handling Oracle Database Administration and development task. If provide solution of ORA Errors and configuration Steps for setup in Oracle.

Check the compatibility of ASM diskgroup in Oracle

Check the compatibility of ASM diskgroup in Oracle

Oracle 11g introduce the ASM Attributes which help in finding ASM and Database software version to access diskgroups.

Compatibile.ASM = Defines the minimum version of ASM software instance that can access disk group.
Compatibile.RDBMS = Defines the minimum COMPATIBLE parameter setting for database instance that can access diskgroup.

For example, if the Oracle ASM compatibility setting is 12.1, and RDBMS compatibility is set to 11.2, then the Oracle ASM software version must be at least 12.1, and the Oracle Database client software version must be at least 11.2.

1. Value of COMPATIBLE.ASM must always be greater than or equal to the value of COMPATIBLE.RDBMS.
2. Compatibility versions of a diskgroup only be increased,it’s not decreased. If you increased it and want to decrease it then you need to drop and create it again.

Check the compatibility of a ASM diskgroup

SELECT name AS diskgroup, substr(compatibility,1,12) AS asm_compat,
substr(database_compatibility,1,12) AS db_compat FROM V$ASM_DISKGROUP;

--------- ---------- ----------

Check the ASM attribute

column value for a20
column name for a20
SELECT group_number, name, value FROM v$asm_attribute ORDER BY group_number, name;

NUMBER       NAME                 VALUE
------------ -------------------- --------------------
           1 au_size              1048576
           1 compatible.asm
           1 compatible.rdbms     11.1
           1 disk_repair_time     3.6h

Create diskgroup defines tha attribute

CREATE DISKGROUP data01 DISK '/dev/raw/disk*'
ATTRIBUTE 'compatible.rdbms' = '11.1', 'compatible.asm' = '11.1';

Alter command only used to increased value

ALTER DISKGROUP data01 SET ATTRIBUTE 'compatible.asm' = '11.1';
ALTER DISKGROUP data01 SET ATTRIBUTE 'compatible.rdbms' = '11.1';