Here I would be discussing how to upgrade Oracle 11gR2 (11.2.0.4) Grid Infrastructure to Oracle 12cR2 (12.2.0.1) on the same server. This upgrade process was done on Linux 6 (x86_64). 1. Before the GI upgrade backup the OCR manually. This could be used in downgrading the GI from 12.2.0.1 to 11.2.0.4 later one. If you […]
Category: ORACLE RAC
How to check Cluster Name
To check the cluster name use, $ORA_CRS_HOME/bin/cemutlo -n
Restore and Backup the current OLR
Backup current OLR and all available OLR backups # ocrconfig -local -manualbackup rac1 2017/03/01 20:52:12 /u01/app/grid/cdata/rac1/backup_20170301_205212.olr Verify available backups # ocrconfig -local -showbackup rac1 2017/03/01 20:52:12 /u01/app/grid/cdata/rac1/backup_20170301_205212.olr Verify available backups from OS # ls -l /u01/app/grid/cdata/rac1/* -rw——-. 1 root root 6803456 Feb 12 13:04 /u01/app/grid/cdata/rac1/backup_20170212_130457.olr -rw——-. 1 root root 7016448 Mar 01 09:08 /u01/app/grid/cdata/rac1/backup_20170301_090842.olr […]
Relocate Voting Disk to a different ASM diskgroup in 11gR2
Check current status : $GRID_HOME/bin/crsctl query css votedisk ## STATE File Universal Id File Name Disk group — —– —————– ——— ——— 1. ONLINE 7dgdhsgijfgy7gsuugeydcbo0qoeijll (/dev/asm1_sdb1) [DATA] 2. ONLINE 6590ede5237e4f37bfe6aa3d196fe972 (/dev/asm2_sdc1) [DATA] 3. ONLINE 3a7c7b334faf4fdcbf05a246eddf5404 (/dev/asm3_sdd1) [DATA] Located 3 voting disk(s). Relocate Voting Disks $GRID_HOME/bin/crsctl replace votedisk +OCR Successful addition of voting disk 4f789813cef6d5d6f965cbef6de2ef6d. Successful […]
Relocate OCR to a different ASM diskgroup in 11gR2
Create a new diskgroup for OCR Use ascma and create new Data group named OCR and verify that this datagroup is mounted $ 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 NORMAL N 512 4096 1048576 40944 25698 10236 7731 0 Y DATA/ MOUNTED NORMAL N 512 […]