Apply Patch on Oracle DB Home

Steps to Apply Patch on DB Home

This document shows how to apply patch on Oracle home / databases.

July 2019 PSU for Oracle databases.
Below patches are only for oracle database home if you want to apply on GRID then GI patch is difference and steps are as well.

Patch ID details

Patch 29834717 – Database Release Update 19.4.0.0.190716 ==> 19c
Patch 29757256 – Database Release Update 18.7.0.0.190716 ==> 18c
Patch 29757449 – Database Release 12.2.0.1.190716 ==> 12.2.0.1
Patch 29494060 – Database Patch Set Update 12.1.0.2.190716 ==> 12.1.0.2

The next four dates for Critical Patch Updates are:
October 15, 2019
January 14, 2020
April 14, 2020
July 14, 2020

Prerequisites

1. Go to Patch location and make sure download / copy correct patch and unzip it which depends on OS platform type & DB version.

2. Download patch as require and make sure you have downloaded correct patch version for specific OS type & DB version. Here I am showing for Linux 64 Bit and database version is 12.2.0.1

3. Capture information of running instances, listener, patch inventory, oratab & backup of associated ORACLE_HOME (In RAC Instances, execute on all available nodes)

Output of opatch version should be most latest version or similar, refer read me of patch ID document and according that it’s require to upgrade

4. Determine whether any currently installed interim patches conflict with the patch being installed.

Make sure no patch conflict output in prerequisite, in case any conflict act according that.

Installation

To install the patch, follow these steps:

1. Set environment

2. Ensure that you shut down all the services running from the Oracle home where you are performing patch activity. Shutdown DB and Listener running associated from same ORACLE HOME where we are applying patch

For HAS & RAC Instances:

In RAC environment if you don’t have down time then perform instance wise i.e stop services on one node at a time (Rolling fashion)

For Standalone DB:

3. Ensure no services / processes are running from target ORACLE HOME

4. Set your current directory to the directory where the patch is located and then run the opatch utility by entering the following commands:

Note: When using opatch you will be asked the following questions for each patch, reply as follows:

Email address/User Name:  

Leave Blank

Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]:
Y
Is the local system ready for patching? [y|n]
y

NOTE: In RAC DB / Instance, it will prompt for next available node to patch after completion on executed node and if you want to instance wise use option –local

6.Verify whether the patch has been successfully installed by running the following command:

Post patch installation

1. Start the services from the Oracle home.

2.

3. Validate patch applied in database.

4 Startup database

For HAS / RAC DB / Instance startup:

For Standalone DB startup:

NOTE: Follow post installation step# 1 to 4 for all databases running from same ORACLE_HOME where we applied patch and in RAC environment only execute on one instance.
Make sure all services are up & running from patched ORACLE HOME
Thank you

**This document is only for learning purpose and always validate in LAB environment first before apply on LIVE environment.