Change ASM, RDBMS Diskgroup Compatiblity In Oracle 11g

Step 1) Check ASM Diskgroup compatibility (login as sqlplus / as sysasm)

$ . oraenv
ORACLE_SID = [XXXXXXXX] ? +ASM2


sqlplus / as sysasm

col name format a10
col COMPATIBILITY format a20
col DATABASE_COMPATIBILITY format a20
select name,COMPATIBILITY,DATABASE_COMPATIBILITY from v$asm_diskgroup;

OUTPUT:-
------------

NAME       COMPATIBILITY        DATABASE_COMPATIBILI
---------- -------------------- --------------------
FLASH01    10.1.0.0.0           10.1.0.0.0
PT1_ARCH01 10.1.0.0.0           10.1.0.0.0
PT1_DATA01 10.1.0.0.0           10.1.0.0.0
P_ARCH_1   10.1.0.0.0           10.1.0.0.0
P_DATA_1   10.1.0.0.0           10.1.0.0.0
P_DATA_2   10.1.0.0.0           10.1.0.0.0




Step 2) Upgrade the compatibility to 11.2 compatible.asm if not any disk group


SQL> alter diskgroup FLASH01 set attribute 'compatible.asm'='11.2';
Diskgroup altered.

SQL> alter diskgroup PT1_ARCH01 set attribute 'compatible.asm'='11.2';
Diskgroup altered.

SQL> alter diskgroup PT1_DATA01 set attribute 'compatible.asm'='11.2';
Diskgroup altered.

SQL> alter diskgroup P_ARCH_1 set attribute 'compatible.asm'='11.2';
Diskgroup altered.

SQL> alter diskgroup P_DATA_1 set attribute 'compatible.asm'='11.2';
Diskgroup altered.

SQL> alter diskgroup P_DATA_2 set attribute 'compatible.asm'='11.2';
Diskgroup altered.





Check Compatiblity :-

col name format a10
col COMPATIBILITY format a20
col DATABASE_COMPATIBILITY format a20
select name,COMPATIBILITY,DATABASE_COMPATIBILITY from v$asm_diskgroup;

OUTPUT:-
-------

NAME       COMPATIBILITY        DATABASE_COMPATIBILI
---------- -------------------- --------------------
FLASH01    11.2.0.0.0           10.1.0.0.0
PT1_ARCH01 11.2.0.0.0           10.1.0.0.0
PT1_DATA01 11.2.0.0.0           10.1.0.0.0
P_ARCH_1   11.2.0.0.0           10.1.0.0.0
P_DATA_1   11.2.0.0.0           10.1.0.0.0
P_DATA_2   11.2.0.0.0           10.1.0.0.0


Step 3) NOTE: Update compatible.rdbms  If applicable for database
-- Applicable only 11g Databases



SQL> alter diskgroup FLASH01 set attribute 'compatible.rdbms'='11.2';
Diskgroup altered.

SQL> alter diskgroup PT1_ARCH01 set attribute 'compatible.rdbms'='11.2';
Diskgroup altered.

SQL> alter diskgroup PT1_DATA01 set attribute 'compatible.rdbms'='11.2';
Diskgroup altered.

SQL> alter diskgroup P_ARCH_1 set attribute 'compatible.rdbms'='11.2';
Diskgroup altered.

SQL> alter diskgroup P_DATA_1 set attribute 'compatible.rdbms'='11.2';
Diskgroup altered.

SQL> alter diskgroup P_DATA_2 set attribute 'compatible.rdbms'='11.2';
Diskgroup altered.

6 rows selected.


Check Compatible again to make sure:-
##############################


NAME       COMPATIBILITY        DATABASE_COMPATIBILI
---------- -------------------- --------------------
FLASH01    11.2.0.0.0           11.2.0.0.0
PT1_ARCH01 11.2.0.0.0           11.2.0.0.0
PT1_DATA01 11.2.0.0.0           11.2.0.0.0
P_ARCH_1   11.2.0.0.0           11.2.0.0.0
P_DATA_1   11.2.0.0.0           11.2.0.0.0
P_DATA_2   11.2.0.0.0           11.2.0.0.0