This article is about upgrade of oracle database 11.2.0.1_to 11.2.0.4).
[oracle@india2 grid]$ ./runcluvfy.sh stage -pre crsinst -upgrade -n india1,india2 -rolling -src_crshome /u01/11.2.0/grid -dest_crshome /u01/11.2.4/grid -dest_version 11.2.0.4.0 -fixup -fixupdir /home/oracle/logs -verbose |tee /home/oracle/logs/runcluvfy1210.out [oracle@india2 logs]$ more runcluvfy.out |grep -i 'failed' india2 missing 9413827 or 9706490 failed india1 missing 9413827 or 9706490 failed Result: Check for Oracle patch "9413827 or 9706490" in home "/u01/11.2.0/grid" failed india2 failed india1 failed [oracle@india2 logs]$ more runcluvfy.out |grep -i 'failed' india2 missing 9413827 or 9706490 failed india1 missing 9413827 or 9706490 failed Result: Check for Oracle patch "9413827 or 9706490" in home "/u01/11.2.0/grid" failed india2 failed india1 failed
Download the 9413827 or 9706490 patch from oracle support and get apply
# Bugs fixed by this bundle # ========================= # CRS HOME # ======== # 9706490 lnx64-11202-ud 11201 -> 11202, dg offline after restart crs stack during upgrade # RDBMS_HOME # ========== # 9706490 lnx64-11202-ud 11201 -> 11202, dg offline after restart crs stack during upgrade
Below are attachment to findout patch steps.
Now we can update the grid home and oracle home from 11.2.0.1 to 11.2.0.4 .
[root@india2 oracle]# cd oracle114/ [root@india2 oracle114]# ls -lrth total 3.5G drwxrwxr-x 7 oracle oinstall 4.0K Aug 27 2013 grid drwxrwxr-x 7 oracle oinstall 4.0K Aug 27 2013 database -rwxrwxr-x 1 oracle oinstall 1.2G Dec 8 2016 p13390677_112040_Linux-x86-64_3of7.zip -rwxrwxr-x 1 oracle oinstall 1.1G Dec 9 2016 p13390677_112040_Linux-x86-64_2of7.zip -rwxrwxr-x 1 oracle oinstall 1.3G Dec 9 2016 p13390677_112040_Linux-x86-64_1of7.zip [root@india2 oracle114]# cd grid/ [root@india2 grid]# pwd /oracle/oracle114/grid [root@india2 grid]# ls -lrth total 68K drwxrwxr-x 2 oracle oinstall 4.0K Aug 26 2013 sshsetup -rwxrwxr-x 1 oracle oinstall 3.2K Aug 26 2013 runInstaller -rwxrwxr-x 1 oracle oinstall 4.8K Aug 26 2013 runcluvfy.sh drwxrwxr-x 2 oracle oinstall 4.0K Aug 26 2013 rpm drwxrwxr-x 2 oracle oinstall 4.0K Aug 26 2013 response drwxrwxr-x 4 oracle oinstall 4.0K Aug 26 2013 install drwxrwxr-x 14 oracle oinstall 4.0K Aug 26 2013 stage -rwxrwxr-x 1 oracle oinstall 30K Aug 27 2013 readme.html -rwxrwxr-x 1 oracle oinstall 500 Aug 27 2013 welcome.html
1) check the pre-req before upgrading the grid home using runcluvfy.sh script .
./runcluvfy.sh stage -pre crsinst -upgrade -n india1,india2 -rolling -src_crshome /u01/11.2.0/grid -dest_crshome /u01/11.2.4/grid -dest_version 11.2.0.4.0 -fixup -fixupdir /home/oracle/logs -verbose |tee /home/oracle/logs/runcluvfy1210.out
2) Run the runInstaller and start upgrading grid home .
3) select skip software updates and click on next button.
[root@india1 ~]# /u01/11.2.4/grid/rootupgrade.sh Performing root user operation for Oracle 11g The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /u01/11.2.4/grid Enter the full pathname of the local bin directory: [/usr/local/bin]: The contents of "dbhome" have not changed. No need to overwrite. The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n) [n]: y Copying oraenv to /usr/local/bin ... The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n) [n]: y Copying coraenv to /usr/local/bin ... Entries will be added to the /etc/oratab file as needed by Database Configuration Assistant when a database is created Finished running generic part of root script. Now product-specific root actions will be performed. Using configuration parameter file: /u01/11.2.4/grid/crs/install/crsconfig_params Creating trace directory User ignored Prerequisites during installation Installing Trace File Analyzer CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'india1' CRS-2673: Attempting to stop 'ora.crsd' on 'india1' CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'india1' CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'india1' CRS-2673: Attempting to stop 'ora.OCRVOTE.dg' on 'india1' CRS-2673: Attempting to stop 'ora.registry.acfs' on 'india1' CRS-2673: Attempting to stop 'ora.DATA.dg' on 'india1' CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'india1' CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'india1' succeeded CRS-2673: Attempting to stop 'ora.india1.vip' on 'india1' CRS-2677: Stop of 'ora.india1.vip' on 'india1' succeeded CRS-2672: Attempting to start 'ora.india1.vip' on 'india2' CRS-2677: Stop of 'ora.registry.acfs' on 'india1' succeeded CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'india1' succeeded CRS-2673: Attempting to stop 'ora.scan1.vip' on 'india1' CRS-2677: Stop of 'ora.scan1.vip' on 'india1' succeeded CRS-2672: Attempting to start 'ora.scan1.vip' on 'india2' CRS-2676: Start of 'ora.india1.vip' on 'india2' succeeded CRS-2676: Start of 'ora.scan1.vip' on 'india2' succeeded CRS-2672: Attempting to start 'ora.LISTENER_SCAN1.lsnr' on 'india2' CRS-2676: Start of 'ora.LISTENER_SCAN1.lsnr' on 'india2' succeeded CRS-2677: Stop of 'ora.OCRVOTE.dg' on 'india1' succeeded CRS-2677: Stop of 'ora.DATA.dg' on 'india1' succeeded CRS-2673: Attempting to stop 'ora.asm' on 'india1' CRS-2677: Stop of 'ora.asm' on 'india1' succeeded CRS-2673: Attempting to stop 'ora.eons' on 'india1' CRS-2673: Attempting to stop 'ora.ons' on 'india1' CRS-2677: Stop of 'ora.ons' on 'india1' succeeded CRS-2673: Attempting to stop 'ora.net1.network' on 'india1' CRS-2677: Stop of 'ora.net1.network' on 'india1' succeeded CRS-2677: Stop of 'ora.eons' on 'india1' succeeded CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'india1' has completed CRS-2677: Stop of 'ora.crsd' on 'india1' succeeded CRS-2673: Attempting to stop 'ora.cssdmonitor' on 'india1' CRS-2673: Attempting to stop 'ora.ctssd' on 'india1' CRS-2673: Attempting to stop 'ora.evmd' on 'india1' CRS-2673: Attempting to stop 'ora.asm' on 'india1' CRS-2673: Attempting to stop 'ora.mdnsd' on 'india1' CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'india1' CRS-2677: Stop of 'ora.cssdmonitor' on 'india1' succeeded CRS-2677: Stop of 'ora.evmd' on 'india1' succeeded CRS-2677: Stop of 'ora.mdnsd' on 'india1' succeeded CRS-2677: Stop of 'ora.drivers.acfs' on 'india1' succeeded CRS-2677: Stop of 'ora.ctssd' on 'india1' succeeded CRS-2677: Stop of 'ora.asm' on 'india1' succeeded CRS-2679: Attempting to clean 'ora.asm' on 'india1' ORA-01089: immediate shutdown in progress - no operations are permitted Process ID: 0 Session ID: 0 Serial number: 0 CRS-2681: Clean of 'ora.asm' on 'india1' succeeded CRS-2673: Attempting to stop 'ora.cssd' on 'india1' CRS-2677: Stop of 'ora.cssd' on 'india1' succeeded CRS-2673: Attempting to stop 'ora.gpnpd' on 'india1' CRS-2673: Attempting to stop 'ora.diskmon' on 'india1' CRS-2677: Stop of 'ora.gpnpd' on 'india1' succeeded CRS-2673: Attempting to stop 'ora.gipcd' on 'india1' CRS-2677: Stop of 'ora.gipcd' on 'india1' succeeded CRS-2677: Stop of 'ora.diskmon' on 'india1' succeeded CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'india1' has completed CRS-4133: Oracle High Availability Services has been stopped. OLR initialization - successful Replacing Clusterware entries in inittab clscfg: EXISTING configuration version 5 detected. clscfg: version 5 is 11g Release 2. Successfully accumulated necessary OCR keys. Creating OCR keys for user 'root', privgrp 'root'.. Operation successful. Started to upgrade the Oracle Clusterware. This operation may take a few minutes. Started to upgrade the CSS. Started to upgrade the CRS. The CRS was successfully upgraded. Successfully upgraded the Oracle Clusterware. Oracle Clusterware operating version was successfully set to 11.2.0.4.0 ASM upgrade has finished on last node. Configure Oracle Grid Infrastructure for a Cluster ... succeeded [root@india1 ~]#
Upgrade the oracle home and database from 11.2.0.1 to 11.2.0.4
[root@india2 database]# pwd /oracle/oracle114/database [root@india2 database]# ls -lrth total 60K drwxrwxr-x 2 oracle oinstall 4.0K Aug 27 2013 sshsetup -rwxrwxr-x 1 oracle oinstall 3.2K Aug 27 2013 runInstaller drwxrwxr-x 2 oracle oinstall 4.0K Aug 27 2013 rpm drwxrwxr-x 2 oracle oinstall 4.0K Aug 27 2013 response -rwxrwxr-x 1 oracle oinstall 30K Aug 27 2013 readme.html drwxrwxr-x 14 oracle oinstall 4.0K Aug 27 2013 stage -rwxrwxr-x 1 oracle oinstall 500 Aug 27 2013 welcome.html drwxrwxr-x 4 oracle oinstall 4.0K Aug 27 2013 install [root@india2 database]#
- Run the runInstaller
Thank you for your kind attention on the article.