Recently I have upgraded Single node GI (Oracle Restart) from 220.127.116.11.0 to 18.104.22.168.0 and thought to share with you. Though it’s not something very interesting to share yet not that bad at all.J
In this blog I’ll use GI or Grid Infrastructure, which is also Oracle Restart in our case. Here are details of GI (Oracle Restart):
Grid Infra Version: 22.214.171.124.0
Grid Home: /u01/app/oracle/product/11.2.0/grid
Host Name: mask11g
DB Version: 126.96.36.199.0
Purpose: Upgrade GI from 188.8.131.52.0 to 184.108.40.206.0
Path for upgrade: Out of place (New location on same server) followed by removal of old GI home.
Going forward from 11gR2 oracle recommend to go with out of place upgrade though in place upgrade is still available. I tried both and both are almost similar except the few minor things. In place upgrade enables you to upgrade an existing installation of GI into the same directory by replacing the existing installation files. The patch set application requires more downtime and is not recommended. This upgrade type requires less disk space.
For out of place upgrade we need almost 5 GB extra space during upgrade and we would be able to release space by removing the old grid software.
In order to make it easily understandable as a step by step approach I am attaching snapshots of upgrade process.
Software is available on MOS with patch number 10404530 and could be easily downloadable. This patch contains total 7 files but we need only p10404530_112030_platform_3of7.zip (933 MB) to complete GI upgrade. This patch is actually full release so it could be used to perform new installation as well as upgrade from old versions.
I would suggest you to read the instructions from all aspects before you test the upgrade on your environment. I couldn’t share more details or else this blog looks like upgrade companion doc J.
- Download and unzip the p10404530_112030_platform_3of7.zip into staging location on your server.
- Take backup of existing environment
- Upgrade the GI software
- Once upgrade is done then you could remove the old GI installation as it’s of no use or could leave it as it is in case you have plenty of space on your server.
Read more of this post