Scribd
Upload
625 views4 pages

Oracle Patching

This document provides instructions for patching an Oracle database with the latest Proactive Security Update (PSU) patch. It details downloading the appropriate patch file for the database and operating system versions, running precheck on the patch, applying the patch with OPatch, running datapatch to complete post-install tasks, upgrading the RMAN catalog, and provides the command for rolling back the patch if needed.

Uploaded by

Irfan Ahmad
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
625 views4 pages

Oracle Patching

This document provides instructions for patching an Oracle database with the latest Proactive Security Update (PSU) patch. It details downloading the appropriate patch file for the database and operating system versions, running precheck on the patch, applying the patch with OPatch, running datapatch to complete post-install tasks, upgrading the RMAN catalog, and provides the command for rolling back the patch if needed.

Uploaded by

Irfan Ahmad
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
  • Oracle Patching Overview: Introduction to the Oracle patching process including necessary documentation references and patch version details.
  • Patch Download and Precheck: Instructions for downloading the correct patch version and performing precheck operations to ensure compatibility.
  • Running the Patch Command: Details on executing the necessary command lines to apply the patch including unzipping and conflict checking.
  • Apply Datapatch: Instructions for executing Datapatch for database deployment post-patching to ensure all components are updated.
  • Post-Patching Steps: Post-application procedures including RMAN catalog upgrade and revision verification after patching.

Oracle patching with latest Proactive patch

In this document we will see how to patch the database with the latest PSU patches

Check the following note for the patch numbers for all versions
Primary Note for Database Proactive Patch Program (Doc ID 888.1)

Download the relevant patch for the DB version and OS version , in this case
21c – Linux

Patch Patch Number

21.9.0.0.230117 DB RU Patch 34839741

Check database version : 21.3.0.0

Current patch list : Run the following command to see list of all patches applied
(None applied on this Oracle home currently)

Always download the latest OPatch from support

https://updates.oracle.com/download/6880880.html
cd $ORACLE_HOME/OPatch
./opatch version

Unzip the patch zip file and run the precheck

Perform Precheck :
cd 34839741
opatch prereq CheckConflictAgainstOHWithDetail -ph ./

Once the precheck is successful we can apply the patch.


Make sure all the database running from the Oracle home being
patched are shutdown.

Take a backup of the Oracle home (tar/zip) any format should be


ok. This is just to be safe in the event of corruption of home.

./opatch apply
/home/oracle/patches/34839741
[oracle@oracle-21c-vagrant 34839741]$ cd $ORACLE_HOME/OPatch
[oracle@oracle-21c-vagrant OPatch]$ ./opatch lspatches
34839741;Database Release Update : 21.9.0.0.230117 (34839741)

OPatch succeeded.
[oracle@oracle-21c-vagrant OPatch]$

After the patch we need apply to Apply Datapatch (Datapatch is


run to complete the post-install SQL deployment for the patch
being installed) This will be applied to cdb,seed pdb and all
pdbs.

[oracle@oracle-21c-vagrant OPatch]$ cd $ORACLE_HOME/OPatch


[oracle@oracle-21c-vagrant OPatch]$ ./datapatch -verbose
Upgrade RMAN catalog to complete the patch apply

rman catalog username/password@alias


RMAN> UPGRADE CATALOG;
RMAN> UPGRADE CATALOG;
RMAN> EXIT;

The new version after patching : 21.9.0.0

If we need to rollback the patch for any circumstance,

cd $ORACLE_HOME/Opatch
./opatch rollback -id 34839741

You might also like