Script to Check ASM Diskgroup Compatibility

advertisements

_____________________________________________________________________________________________________________________

COMPATIBLE.ASM (v$asm_diskgroup. COMPATIBILITY) – The minimum version of the ASM software that can access the disk group. In 11g, the default setting is 10.1. COMPATIBLE.RDBMS (v$asm_diskgroup. 

DATABASE_COMPATIBILITY) – The minimum COMPATIBLE database initialization parameter setting for any database instance that uses the disk group. In 11g, the default setting is 10.1. 

SQL Query

 

Set pages 1000 lines 120 
Col DATABASE_COMPATIBILITY for a30
Col COMPATIBILITY for a30
select GROUP_NUMBER,NAME,COMPATIBILITY,DATABASE_COMPATIBILITY from v$asm_diskgroup;

advertisements

 

Sample Output

 

SQL> Set pages 1000 lines 120
Col DATABASE_COMPATIBILITY for a30
Col COMPATIBILITY for a30
select GROUP_NUMBER,NAME,COMPATIBILITY,DATABASE_COMPATIBILITY from v$asm_diskgroup;

GROUP_NUMBER NAME            COMPATIBILITY                  DATABASE_COMPATIBILITY
------------ --------------- ------------------------------ ------------------------------
           1 DATA            12.1.0.2.0                     12.1.0.2.0
           2 INDEX           12.1.0.2.0                     12.1.0.2.0
           3 RECO            12.1.0.2.0                     12.1.0.2.0

_____________________________________________________________________________________________________________________

Website Stats