Pages

Wednesday, January 6, 2016

Oracle Grid Infrastructure Upgrade to 12C using OUI with additional patches (Cluster upgrade 11.2.0.3 to 12.1.0.2 - tricky approach)

In our recent cluster upgrade, we moved from 11.2.0.3 to 12.1.0.2.
The upgrade approach we chose was simple using OUI, but with some bugs we hit in available installable, we were asked to go for fixes as well as latest available patch-sets.

The approach should be to install software and then apply patches. Then start upgrade manually or using OUI. Or other way upgrade and apply patches.
But trying all this were appearing time taking and troublesome.

We kept the same approach for upgrade and path to upgrade is moved a little bit with couple of steps introduced in mid.

1. Run OUI with install and upgrade.
2. Hold it post install and do not press next to go to configure.
3. Apply patches from other window on recently installed software home.
4. Press next to let OUI go and do configuration.

With above approach the upgrade went pretty smooth in one go. Following are the detailed step for the same.


1. Verify grid with cluster verify utility.
./runcluvfy.sh stage -pre crsinst -upgrade -rolling -src_crshome /d00/app/11.2.0/grid -dest_crshome /d00/app/12.1.0/grid -dest_version 12.1.0.2.0 -fixup –verbose

In case of any issues this generates a fixup script. Running that from root solves the issue.



2. Keep on pressing next with your desired options, and at the window for batches, preferable divide task in batches.



3. In case of any issues shown in pre requisites check. Solve the same and move ahead.


4. Let the installation go and hold this when this pops up for running configuration scripts. (For me this appeared around 81% and in steps installation went successful and it is about to start the configuration script for Batch1 ).


5. Keeping the installtion window as it is, I logged in from other session. There I updated opatch to latest version available, created response file and also applied few patches as required.

$ unzip p6880880_121010_Linux-x86-64.zip -d <12C_ORACLE_HOME>

$ <12C_ORACLE_HOME>/OPatch/ocm/bin/emocmrsp -no_banner -output <Response File Name With Path>

$ <12C_ORACLE_HOME>/OPatch/opatch apply -oh <12C_ORACLE_HOME> -local <PATCH_PATH>/<patch_no> -ocmrf <Response File Name With Path>

6. Once done you can verify the patches with opatch lsinventory. And then you can go to the already open screen of OUI and press Yes there to move with upgrade. Later go with desired inputs as and when asked.


7. This will do execution of batch scripts and configuration on nodes one by one, and then Management DB creation. You will not be asked for any more inputs if everything goes smooth, until the below screen appears.



Thus upgrade completed quite fast as this saved time in applying patches as well, and it was smooth with OUI as it supposed to be.