Oracle RAC Database Patching from 19 12 to 19 16 Step by Step Guide

YouTube video

Introduction

In this tutorial, we will discuss how to perform database patching, specifically RAC (Real Application Clusters) database patching, when you have a two-node primary database and two-node standby database in a RAC setup. We will be applying the latest July quarter patch, 19.16, on an existing 19.12 setup. This tutorial will provide a step-by-step guide to help you understand the entire process.

Patch Download

To begin, you need to download the patch. The patch ID will be provided in the description of the video. Make sure you select the appropriate patch for your operating system. In this case, the system is based on Linux. After downloading the patch, make sure to read the readme document included with the patch. This document will provide information about the minimum patch utility version required to apply the patches.

Existing Patch Details

Before starting the patching process, it’s important to verify the existing patch details. Use the opatch lsinventory command to check the patch version. This command should be run on both the primary and standby setups. It is necessary to apply the same patch on both setups.

Patching Method

There are two methods to apply the patches on RAC setups: manual method and opatch auto method. In this tutorial, we will focus on the manual method. The manual method involves copying the patch files to the appropriate directories and then running various commands to apply the patches. Make sure to carefully follow each step in this tutorial.

Upgrading Patch Utility

Before applying the patches, it is necessary to upgrade the patch utility to the required version. In this case, the required version is 1.3. To upgrade the patch utility, download the latest version and copy it to the grid home and database home directories. After copying the files, unzip them and update the opatch version by running the appropriate command.

Applying Patches

Once the patch utility is upgraded, you can start applying the patches. Begin by verifying any conflicts by running the pre-check command from the grid home directory. This will check if there are any conflicts or issues that need to be resolved before proceeding.

Next, perform a space check to ensure that there is enough disk space to apply the patches. Both the grid home and database home directories should be checked for available space.

After completing the pre-checks and space checks, stop the database in a rolling fashion. This means stopping the production node first, followed by the standby node.

Apply the patches by running the appropriate commands from both the root user and the grid user. Make sure to verify the patches after applying them.

If you have any additional OVM patches, apply them as well. Finally, run the post-patch script to finalize the patching process.

Verifying Patches and Starting the Database

After applying the patches, it is important to verify that everything has been applied correctly. Use the appropriate commands to check the patch versions in both the grid home and database home directories.

Lastly, start the database using the appropriate command. This will bring the database back online after the patching process.

Conclusion

In this tutorial, we have discussed the step-by-step process for performing Oracle RAC database patching. We covered the patch download, verifying existing patch details, patching methods, upgrading patch utility, applying patches, verifying patches, and starting the database. By following this tutorial, you can successfully patch your Oracle RAC database from version 19.12 to 19.16.

Remember to always read the readme document included with the patch and make sure to backup your database before performing any patching. Following best practices and guidelines will ensure a smooth patching process and minimize any potential issues.

For further support and guidance, please feel free to reach out to the Oracle DBA Online Training team through the provided contact details. Don’t forget to check out their LinkedIn page and other social media platforms for additional resources and updates.

Upgrade your Oracle RAC database to the latest version and enjoy the benefits of enhanced features, improved performance, and increased security!