By:Joel Perez( Oracle ACED )
In this article we will show 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.
2.Download theOracle Grid Infrastructureimage file , create the Grid home directory, and extract the image files in this Grid home directory.
$ mkdir -p /u01/app/12.2.0/grid
$ chown oracle:oinstall /u01/app/12.2.0/grid
$ cd /u01/app/12.2.0/grid
$ unzip -q linuxx64_12201_grid_home.zip
3. Before the upgrade check GI active version is 11.2.0.4 and upgrade state
“runcluvfy”
4. Verify the prerequisites with
runcluvfy.sh stage -pre crsinst -upgrade -rolling -src_crshome /u01/app/11.2.0/grid -dest_crshome /u01/app/12.2.0/grid -dest_version 12.2.0.1.0 -fixup -verbose
While pre-checking I found there were some prerequisites missing.
a) In 12cr2, we need 8GB of RAM per node
NTP (PRVG-13602)
b) There was a bug onconfirmed by support with bug numberbut unfortunately this bug fix is not release, they confirmed to ignore this and go further.
July 2016 PSU
c) There is must beor later installed before proceed for upgrading.
5. Run the installer and select upgrade GI to continue the upgrade on OUI.
gridSetup.sh
Starting with Oracle Grid Infrastructure 12c Release 2 (12.2), the Oracle Grid Infrastructure software is available as an image file for download and installation. You must extract the image software into the directory where you want your Grid home to be located, and then run thescript to start the Oracle Grid Infrastructure installation.
To use upgrade Oracle Grid Infrastructure for a cluster:
Start the Grid Setup Wizard:
$ Grid_home/gridSetup.sh
Upgrade Oracle Grid Infrastructure.
On the Select Installation Option page, select
On the Oracle Grid Infrastructure Node Selection page, review the nodes you want to upgrade. Additionally, you can choose not to upgrade nodes that are down.
Continue adding your information on the remaining wizard pages.
Note: we need to create same directory on the both the nodes so that remote operations will successfully completed.
As I told earlier we can ignore NTP related issues.
For the output log,Node1, Node2
CRS.
6. After upgrade we can status of software version and
As we completed the upgrade of grid infrastructure from 11204 to 12201.
About the Author
Joel Pérez is an Expert DBA ( Oracle ACE Director, Maximum Availability OCM, OCM Cloud Admin. & OCM12c/11g ) with over 17 years of Real World Experience in Oracle Technology, specialized in design and implement solutions of: High Availability, Disaster Recovery, Upgrades, Replication, Cloud and all area related to Oracle Databases. International consultant with duties, conferences & activities in more than 50 countries in 5 continents and countless clients around the world. Habitual and one of leading writers of Technical Oracle articles for: OTN Spanish & OTN Portuguese. Regular Speaker in worldwide Oracle events like: OTN LAD (Latin America), OTN MENA(Middle East & Africa), OTN APAC ( Asian Pacific), DTCC China and more. Joel has always been known for being a pioneer in Oracle technology since the early days of his career being the first Latin American awarded as “OTN Expert” at year 2003 by Oracle Corp., one of the first “Oracle ACE” globally in the Oracle ACE Program at year 2004 and as one of the biggest professional achievement in his career he was honoured as one of the first “OCM Database Cloud Administrator” & Maximum Availability OCM in the world. Currently Joel works as Chief Technologist in “Yunhe Enmo (Beijing) Technology Co.,Ltd”., company located in Beijing, China www.Enmotech.com