News
Perth, Australia
+ (61) 417713124
prosolutions@gavinsoorma.com

Oracle 12c Release 2 (12.2.0.1.0) Grid Infrastructure Upgrade

  • Posted by Gavin Soorma
  • On March 10, 2017
  • 2 Comments
  • 12.2.0.1, 12c Release 2, 12cR2, cluster, Grid infrastructure, RAC, upgrade

I recently performed an upgrade of an Oracle 12c Release 1 (12.1.0.2) Grid Infrastructure environment hosted on a RAC Virtual Box environment on my laptop to the latest release 12c Release 2 12.2.0.1.0 version.

Here are some points to be noted related to the upgrade process:

    • The Grid Infrastructure 12c Release 2 (12.2) software is now available as a single image file for direct download and installation. This greatly simplifies and enables a much quicker installation of the Grid Infrastructure software.

 

    • We just have to extract the image file linuxx64_12201_grid_home.zip into an empty directory where we want the Grid home to be located.

 

    • Once the software has been extracted we have to run the gridSetup.sh script which will launch the installer where we can perform both an initial install as well as an upgrade.

 

    • We need to have about 33 GB of free disk space in the ASM disk groups for the upgrade process.

 

    • The mount point which hosts the Grid Infrastructure home needs to have at least 12 GB of free disk space.

 

    • It is now mandatory to store the Oracle Clusterware files like the Cluster Registry (OCR) and Voting Disks on ASM and we cannot locate these files now on any kind of other shared storage system.

 

    • We have to install a mandatory patch 21255373 to the Grid Infrastructure software home.  We will see that in this case a number of prerequisite checks have failed related to memory (now needs 8 GB minimum RAM on each node ) as well as other checks related to swap size, NTP and resolv.conf – since this is test Virtual Box environment we can ignore those and continue with the upgrade – however we cannot ignore the mandatory patch 21255373 which needs to be applied to the existing 12.1.0.2 Grid Infrastructure home.

 

    • In order to install the patch, we have to also download the opatch patch 6880880 for Oracle 12.2.0.1.0 (opatch 12.2.0.1.8).

 

    • When we run opatchauto to apply the patch 21255373, we get an error java.text.ParseException: Unparseable date.  This is because time zone TZ entry AWST (Australian Western Standard Time)  is added into $ORACLE_HOME/inventory/ContentsXML/comps.xml and the opatch is using $ORACLE_HOME/jdk/jre, which is version 1.6. Java 1.6 is not able read the TZ entry AWST. We can ignore the error and continue with  the patch application – but after the patch has been applied, we have to change all the occurrences of string “AWST” in the comps.xml file to “WST” – otherwise even though we have applied the patch, the command opatch lsinventory will not show that the patch has been applied until the date format string in the comps.xml is changed as mentioned earlier.

 

    • Upgrade failed at 46% in the phase Execute Root Scripts. Ran the command crsctl stop crs -f as root on each node and clicked on the Retry button and the upgrade then continued without any error

 

    • At the end of the upgrade, the Cluster Verification Utility fails because it checks for NTP configuration appropriate for an Oracle RAC environment. NTP is not configured on this Virtual Box environment so we can ignore the error

 

 

Here are some screen shots captured while the 12c Release 2 Grid Infrastructure upgrade was in progress…..

 

gi1

 

 

gi2

 

 

gi3

 

 

gi4

 

 

 

gi5

 

 

 

gi6

 

 

 

gi7

 

 

 

gi8

 

 

gi9

 

 

 

gi10

 

 

 

gi11

 

 

 

gi12

 

 

 

gi13

 

 

 

gi14

 

 

 

gi15

 

 

 

 

gi16

 

 

 

 

gi17

 

 

 

gi18

 

 

 

gi19

 

 

Note:

Change all occurrences of “AWST” to “WST” in comps.xml file

 

gi22

 

 

Now opatch lsinventory command will show that the patch 21255373 has been applied.

 

gi23 gi24

 

 

 

gi25

 

 

 

 

gi26

 

 

 

gi27

 

 

 

gi28

 

 

 

gi29

 

 

 

gi30

 

 

 

gi31

 

 

 

gi32

 

 

 

gi33

 

 

 

gi34

 

 

 

gi35

 

 

 

gi36

 

 

gi37

 

2 Comments

Mohammed Ajaz
  • Mar 13 2017
Nicely presented Gavin.
Sadan
  • Mar 15 2017
Extremely extraordinary blog

Leave Reply

Your email address will not be published. Required fields are marked *