I have provided the high level steps to upgrade Oracle Clusterware and ASM from 10.2.0.5 to 11.2.0.3.
Upgrading from oracle 10gR2 clusterware and ASM to 11gR2 is always out of place upgrade and can’t be done in rolling upgrade options because in 11gR2 we have single “Grid Infrastructure Home" for both Clusterware and ASM.
Grid Infrastructure --> Clusterware & ASM
Below are the Steps to upgrade to your Clusterware and ASM
1) Download the following software from Oracle support site
p10404530_112030_Linux-x86-64_1of7.zip
p10404530_112030_Linux-x86-64_2of7.zip
p10404530_112030_Linux-x86-64_3of7.zip
2) After unzipping the grid software, run the cluvfy to verify whether the nodes are ready for the upgrade. If the check was unsuccessful, rectify and run it again.
./runcluvfy.sh stage -pre crsinst -n coltdb01,coltdb02 -fixup -fixupdir /opt/oracle –verbose
3) Check for the clusterware active and software version. It should be same
crsctl query crs activeversion
crsctl query crs softwareversion
4) Configure the SCAN IP in the DNS ( pls refer my previous post to configure SCAN IP on DNS server). You can also configure the SCAN IP in your ‘host’ file. But oracle does not recommend it.
5) Unset ORACLE_BASE,ORACLE_HOME,ORACLE_CRS_HOME,TNS_ADMIN,ORA_NLS10
My current 10.2.0.3 home
ASM_HOME = /opt/oracle/product/10.2.0/asm
CRS_HOME= /u01/crs/oracle/product/10.2.0/crs
6) Backup VOTING DISK,OCR,CLUSTER HOME AND ORACLE HOME
OCR Backup
ocrconfig -export /u01/crs/oracle/product/10.2.0/crs/cdata/crs/ocr_backup.ocr -s online
Voting disk Backup
dd if=/dev/raw/raw3 of=/u01/crs/oracle/product/10.2.0/crs/cdata/crs/votedisk.dmp
Similarly backup the Cluster and Oracle Homes
7) Once the backup is taken, you can start the installation by executing the runInstaller.sh from
the grid software location.
Note – The existing 10g cluster & ASM is still up and running on both the nodes
8) Once the installation is started, you can see that oracle automatically selects the upgrade option of the installation
9) You will be asked to select the node names and given a option to select whether you want to upgrade your ASM too
11) You will be asked for the SCAN name and the port number. Provide the scan name which we created earlier in our DNS server.
12) You have provide your new Gird Base home and software home, as you can see the Base home will be different from software home.
13) After this oracle will perform a pre-requisite check for you installation. You can see there will be a failure for “OCR integrity”. It seems to be a bug and you can ignore it.
Check the following note - Checklist for PRVF-10037 : Failed to retrieve storage type for xx on node xx [ID 1233505.1]
14) You will get a summary window before the installation starts, please review it and clink on the install
15) At the end of the installation, you will be asked to execute rootupgrade.sh on all the nodes as root user. Rootupgrade.sh is an important script which does the upgrade of the cluster
16) You can see the message stating “succeed” at the end of the script execution. If the scripts fails for various reason, you need to refer the Oracle support note to fix it (How to Proceed from Failed Upgrade to 11gR2 Grid Infrastructure on Linux/Unix [ID 969254.1])
17) After rootupgrade.sh is successfully executed, the installation proceeds with ASM upgrade. Make sure your ASM is upgraded without any issue.
18) Once the upgrade of clusterware and ASM is completed successfully, you can validate using following scripts
Post-upgrade verification
[oracle@coltdb01 bin]$ ./crsctl query crs activeversion
Oracle Clusterware active version on the cluster is [11.2.0.3.0]
[oracle@coltdb01 bin]$ ./crsctl query crs softwareversion
Oracle Clusterware version on node [coltdb01] is [11.2.0.3.0]
In Oracle 11g R2 you can verify the cluster status from a single node
[oracle@coltdb01 bin]$ ./crsctl check cluster -all
**************************************************************
coltdb01:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
coltdb02:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
19) OCR and Voting disk checks. As you can see there are 5 OCR files in oracle 11gR2. Also voting disk files are listed in 11gR2
[oracle@coltdb01 bin]$ ./ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 3
Total space (kbytes) : 240480
Used space (kbytes) : 6320
Available space (kbytes) : 234160
ID : 1362593683
Device/File Name : /dev/raw/raw1
Device/File integrity check succeeded
Device/File Name : /dev/raw/raw2
Device/File integrity check succeeded
Device/File not configured
Device/File not configured
Device/File not configured
Cluster registry integrity check succeeded
Logical corruption check bypassed due to non-privileged user
[oracle@coltdb01 bin]$ ./crsctl query css votedisk
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE 2a87ecd7fedadfe9ff06de264773036e (/dev/raw/raw3) []
2. ONLINE 2ca3947acf51ffa2bf271bf037bc8779 (/dev/raw/raw4) []
3. ONLINE 1a72a3dca25eefabff869f8f5a661af3 (/dev/raw/raw5) []
20) Once the post upgrade checks are completed, you can detach the Old Oracle homes (cluster and ASM from the inventory)
Ex for Cluster Home-
/u01/crs/oracle/product/10.2.0/crs/oui/bin/runInstaller -detachHome -silent -local ORACLE_HOME=/u01/crs/oracle/product/10.2.0/crs
No comments:
Post a Comment