Installing PSU on Oracle RAC 12c A Step by Step Guide

YouTube video

Oracle RAC 12c R1 rolling apply PSU patch demo

Introduction

In this article, we will be discussing how to install a Patch Set Update (PSU) on Oracle Real Application Clusters (RAC) 12c. A PSU is an update patch that helps keep your Oracle database system up to date and secure. We will provide a detailed step-by-step guide on how to install the PSU patch on your Oracle RAC 12c system. By following this guide, you will be able to successfully install the PSU patch and ensure that your system is running smoothly.

Prerequisites

Before we begin the installation process, make sure you have the following:

  1. Two nodes of Oracle RAC 12c: In our demonstration, we have two nodes, namely “reg one” and “reg two.” The current version of Grid Infrastructure (GI) is 12.1.

  2. Oracle and GI versions: Both the Oracle and GI versions should be the same. In our case, the installed version is 12.1.

  3. Operating systems: The operating systems we are using are Oracle Linux 6.

  4. User accounts: We will use the same user account for both the grid user and the oracle user. However, some users prefer to use different accounts for grid and oracle.

Step 1: Checking the Current System Status

Firstly, let’s check the current state of the system by running the crsctl status command. This will help us ensure that everything is online and stable.

In the Oracle home, we have a database called “oracle” running on “rack1002” node. Let’s switch to the Grid ASM environment by running the command export ORACLE_HOME=+ASM1 and then check the status using crsctl status command again. All resources should be online and stable.

Step 2: Updating the OPatch Utility

Before applying the PSU patch, we need to update the OPatch utility to ensure that it is compatible with the required version of the patch. The OPatch utility is used for patching Oracle software.

To update the OPatch utility, follow these steps:

  1. Download the firmware support and extract it to a directory.
  2. Confirm that the DCRS (Database Configuration Registry Service) is running.
  3. Run the OPatch utility to check the current version. If it is outdated, update it to the required version.

Step 3: Patching Steps

Now, let’s move on to the actual patching process. The patching steps are as follows:

  1. Download the rolling patch from Oracle and upload it to your server.
  2. Unzip the patch files into a directory.
  3. Analyze the patch by running the opatch auto command. This command analyzes the patch and ensures that it is applicable to your system. You can run it with the -oh <oracle_home> option to check both the GI and Oracle homes.
  4. Check the results of the patch analysis. It should show that the patch is applicable and verified successful for both the GI and Oracle homes.
  5. Apply the patch by running the opatch apply command. This command will apply the patch to your system. This step may take some time, so be patient.
  6. Verify the patch installation by checking the inventory using the opatch lsinventory command. This command shows the patches that have been applied to the GI and Oracle homes.

Step 4: Verifying the Patch Installation

To verify the patch installation, you can check the inventory in both the GI and Oracle homes. Use the opatch lsinventory command to view the applied patches.

On the Grid side, run the command opatch lsinventory -invPtrLoc $ORACLE_HOME/oraInst.loc. This will show the patches applied to the Grid infrastructure.

On the Oracle side, run the command opatch lsinventory -invPtrLoc $ORACLE_HOME/oraInst.loc. This will show the patches applied to the Oracle home.

By comparing the inventories before and after the patch installation, you can ensure that the patch has been successfully applied.

Conclusion

In this article, we have discussed the step-by-step process of installing a PSU patch on Oracle RAC 12c. By following these steps, you can ensure that your system is up to date and secure. Remember to always check the current system status, update the OPatch utility, and follow the patching steps carefully. Verifying the patch installation is also essential to ensure that the patch has been successfully applied to your system. With this guide, you can confidently install PSU patches on your Oracle RAC 12c system and keep your database environment running smoothly.