Skip to content

Instantly share code, notes, and snippets.

View freddenis's full-sized avatar

Fred Denis freddenis

44 followers · 0 following
View GitHub Profile
@freddenis
freddenis / rename_a_dg_1
Last active July 15, 2016 05:25
ASMCMD> lsdg
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED HIGH N 512 4096 4194304 358318080 358301384 11943936 115452482 0 Y DATAC1/
MOUNTED NORMAL N 512 4096 4194304 1730400 1729176 34608 847284 0 N DBFS_DG/
MOUNTED HIGH N 512 4096 4194304 89583360 89582016 2986112 28865301 0 N RECOC1/
ASMCMD> exit
@freddenis
freddenis / ORA-15418_1.txt
Created July 15, 2016 05:05
SQL> alter diskgroup DBFS_DG SET ATTRIBUTE 'compatible.asm' = '12.1';
alter diskgroup DBFS_DG SET ATTRIBUTE 'compatible.asm' = '12.1'
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15242: could not set attribute compatible.asm
ORA-15418: Appliance mode is not supported for compatible.asm 12.1.0.0.0.
SQL>
@freddenis
freddenis / ORA-15418_2.txt
Created July 15, 2016 05:10
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 TRUE
3 appliance.mode TRUE
SQL>
@freddenis
freddenis / ORA-15418_3.txt
Created July 15, 2016 05:12
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
@freddenis
freddenis / ORA-15418_4.txt
Created July 15, 2016 05:13
SQL> alter diskgroup DBFS_DG set attribute 'appliance.mode' = 'TRUE' ;
alter diskgroup DBFS_DG set attribute 'appliance.mode' = 'TRUE'
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15242: could not set attribute appliance.mode
ORA-15418: Appliance mode is not supported for compatible.asm 12.1.0.0.0.
SQL>
@freddenis
freddenis / rename_a_dg_2
Last active July 22, 2016 03:50
myclusterdb01:oracle \) srvctl stop diskgroup -diskgroup recoc1 # use the -g option instead of -diskgroup for 11g version
@freddenis
freddenis / rename_a_dg_3
Created July 15, 2016 05:29
myclusterdb01:oracle \) renamedg phase=both dgname=RECOC1 newdgname=RECO verbose=true keep_voting_files=true
Parsing parameters..
Parameters in effect:
Old DG name : RECOC1
New DG name : RECO
Phases :
Phase 1
Phase 2
Discovery str : (null)
@freddenis
freddenis / rename_a_dg_4
Last active July 22, 2016 03:52
myclusterdb01:oracle \) srvctl start diskgroup -diskgroup reco # use the -g option instead of -diskgroup for 11g version
@freddenis
freddenis / rename_a_dg_5
Created July 15, 2016 05:32
myclusterdb01:oracle \) srvctl status diskgroup -diskgroup reco
Disk Group reco is running on myclusterdb01,myclusterdb02,myclusterdb03,myclusterdb04
myclusterdb01:oracle \)
@freddenis
freddenis / rename_a_dg_6
Created July 15, 2016 05:35
myclusterdb01:oracle \) crsctl stat res -t
...
ora.RECOC1.dg
OFFLINE OFFLINE myclusterdb01 STABLE
OFFLINE OFFLINE myclusterdb02 STABLE
OFFLINE OFFLINE myclusterdb03 STABLE
OFFLINE OFFLINE myclusterdb04 STABLE
myclusterdb01:oracle \) srvctl remove diskgroup -g RECOC1
myclusterdb01:oracle \) asmcmd lsdg
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name