3.07.2020

Oracle GI upgrade from 12.1.0.2 to 12.2.0.1 on Exadata

Yet another successful Exadata  Grid Infrastructure upgrade to 12.2. Of course the v12.2.0.1 is bit older, but as per customer's request, we had to proceed. As usual there are some takeaway points from this assignment too.  I am going to share some of the challenges encountered and fixed during the course of this upgrade.

First thing is first. The 12.2 and above installation and upgrade is really cool with the golden image concept introduction. Even great to know that we can also apply the patch before running the root.sh or root upgrade. I really felt super cool about this.

As part of 2 node Cluster upgrade from 12.1, an 12.2 software gold image is extracted to the 12.2 location and started gridSetup.sh with applyPSU (JAN2020 patch). During OUI validation, gridSetup.sh failing with the following error:

[INS-42505] The installer has detected that the Oracle Grid Infrastructure home software at ($GRID_HOME) is not complete.

The installation was looking older version of jar files, hence, it couldn't find, the warning message appeared. It took very less time to figure out the issue. As JAN20 PSU was applied before the OUI startup, it wasn't reflected, hence, ignored the message and resumed with the setup.

After the successful rootupgrade.sh execution on node 1 and node 2, we found that the session (Xwindow) become inactive and OUI couldn't continue.

With >=12.2, you can easily resume the OUI from the point it failed. All you need to do is the following:

Find out the latest response file used during the failed upgrade in the following location (depending on your 12.2 grid home) shown as example:

/u01/app/12.2.0.1/grid/12.2.0.1_180116/gi_1/install/response

And resume the setup from the first node, as show in below:

gridSetup.sh -executeConfigTools -responseFile <responsefile.rsp>

And the setup resumed and managed to complete the upgrade successfully.



No comments: