Author: dbalifeeasy

Running runcluvfy.sh Fails with PRVG-11250 : The check “RPM Package Manager database” was not performed because it needs ‘root’ user privileges.

Before upgrading Oracle 18c GI to 19c GI, to check the readiness of your Oracle Clusterware installation for upgrading, running runcluvfy.sh gets PRVG-11250 errors:

[grid@racnode1 grid]$ ./runcluvfy.sh stage -pre crsinst -upgrade -rolling \
-src_crshome /u01/app/18.0.0/grid -dest_crshome /u01/app/19.0.0/grid \
-dest_version 19.6.0.0 -verbose 
...
..
.
Verifying RPM Package Manager database ...INFORMATION
PRVG-11250 : The check "RPM Package Manager database" was not performed 
because it needs 'root' user privileges.
...
..
.

Subscribe to get access

Read more of this content when you subscribe today.

Subscribe

gridSetup.sh Fails with “ERROR: The home is not clean”

Before upgrading Oracle 18c GI to 19c GI, trying to apply the latest GI RU patches onto 19c gold image, it fails like following:

[grid@racnode1 grid]$ ./gridSetup.sh -silent -applyRU /media/sf_Software/Patches/19c/30463609
Preparing the home to patch...
Applying the patch /media/sf_Software/Patches/19c/30463609...
OPatch command failed while applying the patch. For details look at the logs from /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/

It is because the patch path is not correct, patch 30463609 is Combo of OJVM  and GI. The correct path should be the sub-directory one.

[grid@racnode1 grid]$ ./gridSetup.sh -silent -applyRU /media/sf_Software/Patches/19c/30463609/30501910

ERROR: The home is not clean. This home cannot be used since there was a failed OPatch execution in this home. Use a different home to proceed.

When the command gridSetup.sh fails,  it makes the NEW_HOME unusable.

The only way to get around this issue currently is to clean the contents out of that HOME , and unzip the gold image again.

[grid@racnode1 ~]$ cd /u01/app/19.0.0/grid/
[grid@racnode1 grid]$ rm -fr * 
[grid@racnode1 grid]$ unzip <SW-LOCATION>/LINUX.X64_193000_grid_home.zip -d ./
[grid@racnode1 grid]$ ./gridSetup.sh -silent -applyRU /media/sf_Software/Patches/19c/30463609/30501910
Preparing the home to patch...
Applying the patch /media/sf_Software/Patches/19c/30463609/30501910...
Successfully applied the patch.
The log can be found at: /u01/app/oraInventory/logs/GridSetupActions2020-04-11_10-53-32PM/installerPatchActions_2020-04-11_10-53-32PM.log
Launching Oracle Grid Infrastructure Setup Wizard...

[FATAL] [INS-40426] Grid installation option has not been specified.
   ACTION: Specify the valid installation option.
[grid@racnode1 grid]$

How to Apply the Latest RU/RUR Patches onto 19c Gold Image Before Upgrading 18c GI to 19c GI

While upgrading GI from 18c to 19c, in order to minimize the downtime and reduce the impact on PROD environment, also minimize the risk of upgrading failure, Release Update(RU) or Release Update Reversion(RUR) patches can be applied onto new 19c GI image before upgrading 19c GI.

Subscribe to get access

Read more of this content when you subscribe today.

Subscribe

How to Upgrade Oracle Grid Infrastructure from 18c to 19c

This post illustrates step by step how to upgrade Oracle 18c GI to 19c GI.

Subscribe to get access

Read more of this content when you subscribe today.

Subscribe

Oracle Grid Infrastructure and Database Upgrade Path

Grid Infrastructure Upgrade Path

19c

  • Oracle Grid Infrastructure upgrade from 11g Release 2 (11.2.0.4) to Oracle Grid Infrastructure 19c.
  • Oracle Grid Infrastructure upgrade from 12c Release 1 (12.1.0.2) to Oracle Grid Infrastructure 19c.
  • Oracle Grid Infrastructure upgrade from 12c Release 2 (12.2) to Oracle Grid Infrastructure 19c.
  • Oracle Grid Infrastructure upgrade from 18c release to Oracle Grid Infrastructure 19c.

18c

  • Oracle Grid Infrastructure upgrade from releases 11.2.0.3 and 11.2.0.4 to Oracle Grid Infrastructure 18c.
  • Oracle Grid Infrastructure upgrade from Oracle Grid Infrastructure 12c Release 1 (12.1) to Oracle Grid Infrastructure 18c.
  • Oracle Grid Infrastructure upgrade from Oracle Grid Infrastructure 12c Release 2 (12.2) to Oracle Grid Infrastructure 18c.

Database Upgrade Path

18 (all releases), 12.2.0.1, 12.1.0.2, 11.2.0.4
 Direct upgrade to 19c  is supported

12.1.0.1,11.2.0.1, 11.2.0.2, 11.2.0.3,11.1.0.6, 11.1.0.7,10.2 or earlier releases

Direct upgrade to Oracle Database 19c is not supported.
Solution: Upgrade to an intermediate Oracle Database release that can be directly upgraded to the current release. Upgrade Oracle Database releases that are not supported for direct upgrade in this release to an intermediate Oracle Database release that is supported for direct upgrade.

  • If you are upgrading from release 11.2.0.2 or 11.1.0.7, then you must first upgrade to the terminal patch set release for Oracle Database 11g release 2 (11.2.0.4), which is supported for direct upgrade to Oracle Database 19c.
  • If you are upgrading from release 10.2.0.2, 10.2.0.3, 10.2.0.4,10.2.0.5 or 10.1.0.5, then you must first upgrade to release 11.2. or 12.1
  • If you are upgrading from release 9.2.0.8, then you must first upgrade to a sequence of intermediate Oracle Database releases:

     

    Upgrade from release 9.2.0.8 to release 11.2.0.4. Then upgrade from release 11.2 to 19c

     

Related Blogs

How to Upgrade Oracle Grid Infrastructure from 18c to 19c

How to Upgrade Oracle Grid Infrastructure from 12.2.0.1 to 18c

How to Upgrade Oracle Grid Infrastructure from 12.1.0.2 to 12.2.0.1

How to Upgrade Linux OS In RAC Environment