Upgrade Oracle 11gR2 (11.2.0.4) Grid Infrastructure to Oracle 12cR2 (12.2.0.1):

Grid Infrastructure Management Repository (GIMR),In 12.1.0.1 we had the option of installing the GIMR database – MGMTDB. But in 12.1.0.2 it is mandatory and the MGMTDB database is automatically created as part of the upgrade or initial installation process of 12.10.2 Grid Infrastructure.The GIMR primarily stores historical Cluster Health Monitor metric data. It runs as a container database on a single node of the RAC cluster.datafiles for the MGMTDB database are created on the same ASM disk group which holds the OCR and Voting Disk,at least 4 GB of free space in that ASM disk group – or an error INS-43100 will be returned as shown in the figure below.


1.To check GI active version and upgrade state:

crsctl query crs activeversion
crsctl query crs releaseversion
crsctl query crs softwareversion
crsctl query crs activeversion -f


2.Collect the crs status by running below commands[ grid owner]

/u01/oracle/11.2.0/grid/crsctl check crs
/u01/oracle/11.2.0/grid/crsctl stat res -t
/u01/oracle/11.2.0/grid/crsctl stat res -p
/u01/oracle/11.2.0/grid/oifcfg iflist -p -n
/u01/oracle/11.2.0/grid/oifcfg getif
/u01/oracle/11.2.0/grid/ocrcheck

3.Take OCR backup manually before GI upgrade. This could be used in downgrading the GI from 12.2.0.1 to 11.2.0.4 later on if required.

./ocrconfig -export /softdump/BACKUP/pre_upgrade_backup/ocr_file


4.Download the Oracle Grid Infrastructure image file , create the Grid home directory, and extract the image files in this Grid home directory.

$ mkdir -p /u01/oracle/12.2.0/grid
$ chown oracle:oinstall /u01/oracle/12.2.0/grid
$ cd /u01/oracle/12.2.0/grid
$ unzip -q linuxx64_12201_grid_home.zip

5.Run the cluvfy script for precheck and fix prerequisites missing.To verify all the prerequisites for the 12c GI upgrade are in place.
Verify the prerequisites with “runcluvfy”
runcluvfy.sh stage -pre crsinst -upgrade -rolling -src_crshome /u01/oracle/11.2.0/grid -dest_crshome /u01/oracle/12.2.0/grid -dest_version 12.2.0.1.0 -fixup -verbose

6.Stop the database/services running in grid

srvctl stop database -d PROD

7.Take backup of Grid binary:

tar -cvf grid_home_preupg.tar $GRID_HOME

8.Now start the upgrade using runInstaller.

GI Management repository is a new feature introduced with 12c. When this is selected with the GI installation a database is created (named -MGMTDB) and it's data files are stored in the same disk group where the OCR and vote disks are stored.

9.Run the scripts on the local node:[ from root]
root #/crsapp/app/oracle/product/grid12c/rootupgrade.sh

10.Now run the script on other node.