Hi, everyone.

Today in this article I will show you, how to upgrade Oracle Grid Infrastructure for Standalone without ASM instance (Oracle Restart).

Please find below the required steps to accomplish this task:

Prerequisites:

1. Download Oracle Grid Infrastructure 12.2.

2. Download latest or desired RU (Release Update).

3. Download latest OPatch version compatible with your current release.

Bug:

I came across a bug during the “gridSetup.sh” related to the upgrade option:

“Oracle Restart: Grid Infrastructure Upgrade from 12.1 to 12.2 Failed with ORA-01078 ORA-29701 CLSRSC-164 message while ASM was not in use (Doc ID 2369909.1)”

It happens if you are upgrading the Grid Infrastructure (Oracle Restart only) from 11.2 or 12.1 to 12.2 or beyond.

There is a bug fix for it: “Bug 26554987 fixed in 18.1. Apply patch 26554987 on 12.2 home and re-execute rootupgrade.sh”

In my case, I did not had the chance to find the bug fix to the platform I am working for: “Oracle Solaris Sparc x64.”

To solve it, we are going to apply the Release Update “12.2.0.1.190416” before run the gridSetup.sh.

Oracle Restart 12.2 installations steps:

1. unzip the Oracle Grid Infrastructure to the new ORACLE_HOME:

  • export ORACLE_HOME=/oracle/app/grid_122
  • cd /oracle/iso/
  • unzip Oracle_Grid_12.2.0.1_V840013-01.zip -d $ORACLE_HOME

2. unzip the new OPatch to the new ORACLE_HOME:

  • export ORACLE_HOME=/oracle/app/grid_122
  • cd $ORACLE_HOME
  • mv OPatch OPatch_old
  • unzip /oracle/iso/OPatch_p6880880_122010_SOLARIS64.zip -d $ORACLE_HOME

3. unzip the Release Update Patch:

  • cd /oracle/iso/
  • unzip GI_APR_2019_Release_Update_12.2.0.1.190416_p29301687_122010_SOLARIS64.zip

4. Apply the Release Update before complete the Grid Infrastructure Upgrade: (As grid user)

  • export ORACLE_HOME=/oracle/app/grid_122
  • $ORACLE_HOME/gridSetup.sh -applyPSU /oracle/iso/29301687

PS: DO NOT EXECUTE root.sh or rootupgrade.sh before follow up this procedure, only after apply the steps below.

e.g:

-bash-4.4$ $ORACLE_HOME/gridSetup.sh -applyPSU /oracle/iso/29301687

Preparing the home to patch…
Applying the patch /oracle/iso/29301687…
Successfully applied the patch.
The log can be found at: /oracle/app/oraInventory/logs/GridSetupActions2019-05-28_03-07-45PM/installerPatchActions_2019-05-28_03-07-45PM.log
Launching Oracle Grid Infrastructure Setup Wizard…

5. When the patching process is done, it automatically calls the installation wizard.

Please find below the installation process through installation wizard:

6. Done, installation successfully. 

See you in the next post!