Skip to content

Instantly share code, notes, and snippets.

@freddenis
Created July 15, 2016 05:12
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save freddenis/12c392d55b9088bb144bc1fde56d826e to your computer and use it in GitHub Desktop.
Save freddenis/12c392d55b9088bb144bc1fde56d826e to your computer and use it in GitHub Desktop.
SQL> alter diskgroup DBFS_DG set attribute 'appliance.mode' = 'FALSE' ;
Diskgroup altered.
SQL> SELECT group_number, name, value FROM v$asm_attribute where NAME like '%appliance%' ;
GROUP_NUMBER NAME VALUE
------------ ------------------------------ ------------------------------
1 appliance.mode TRUE
2 appliance.mode FALSE
3 appliance.mode TRUE
SQL> alter diskgroup DBFS_DG SET ATTRIBUTE 'compatible.asm' = '12.1';
Diskgroup altered.
SQL> SELECT group_number, name, value FROM v$asm_attribute where NAME like '%compatible.asm%' ;
GROUP_NUMBER NAME VALUE
------------ ------------------------------ ------------------------------
1 compatible.asm 11.2.0.4.0
2 compatible.asm 12.1.0.0.0
3 compatible.asm 11.2.0.4.0
SQL>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment