Upgrade grid to

I need to upgrade a RAC production set-up from grid to Since this is the first time I do that, I have first set-up a rehearsal environment on VMWare (to be documented in another post).

The upgrade went very smoothly. It consists of:

  • Creating the new home for Grid on all servers with the correct permissions (the old was /u01/app/12.0.1/grid and the new is /u01/app/;
  • Run the cluvfy: this checks and eventually fixes issues pro-actively;
  • Install the new soft on one of the server. During the install you can choose to have the upgrade taking place and so the nodes will be upgraded in a rolling fashion (and the new soft will be installed on both nodes).

There is a nice utility called cluvfy that must be downloaded from technet and installed in /home/grid (i.e. outside the ORACLE_HOME): this utility performs a lot of pre-check and generates fixup scripts.

So those are my two nodes


the grid home is /u01/app/12.1.0/grid. This is the content of /etc/oratab

+ASM1:/u01/app/12.1.0/grid:N:           # line added by Agent
-MGMTDB:/u01/app/12.1.0/grid:N:         # line added by Agent
DEVRACDB_MN:/u01/app/oracle/product/12.1.0/dbhome_1:N:          # line added by Agent

On both nodes, create the new home

sudo mkdir -p /u01/app/
sudo chown root:oinstall /u01/app/
sudo chown grid:oinstall /u01/app/

on node 1, unzip the soft in a staging directory

mkdir /u01/staging/grid12102 (owned by user grid)
cd /u01/staging/grid12102
unzip linuxamd64_12102_grid_1of2.zip 
unzip linuxamd64_12102_grid_2of2.zip

On node 1, run the cluvfy utility (downloaded from technet or metalink)

cd /home/grid/cvu
unzip cvupack_Linux_x86_64.zip
./bin/cluvfy stage -pre crsinst -upgrade -rolling -src_crshome /u01/app/12.1.0/grid -dest_crshome  /u01/app/ -dest_version -verbose

note that there is a similar utility in the grid directory when you unzip the soft. But the idea is that the cluvfy is more up to date. Anyway we can give it a run also. Change to the directory where it is located then

./runcluvfy.sh stage -pre crsinst -upgrade -src_crshome /u01/app/12.1.0/grid/ -dest_crshome /u01/app/ -dest_version -fixup -verbose

Get the current version (as user root)

crsctl query crs softwareversion -all

make sure there is no firewall blocking the communication on the interconnect

iptables -L

In case of doubts, remove all rules

iptables -F

Now we can do the install, as user grid on server 1 (where the soft files were unzipped)


export PATH=/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/grid/bin

the last command remove the current ORACLE_HOME from the PATH

cd /u01/staging/grid12102/grid
  • choose the option : Upgrade Oracle grid infrastructure or Oracle ASM (it is selected by default)
  • In software location, choose /u01/app/
  • when prompted run the /u01/app/ script on the first node and then on the second node (once finished on the first node). It takes time.

After the upgrade, check the active version, as root

crsctl query crs softwareversion -all

As you can see the oratab was also changed.

Written on July 19, 2016