Delete the inactive patches to improve performance of oracle Database patching

Execute the below steps to delete the inactive patches and then proceed with patching if any performance issue in oracle Database patching


+ List the inactive patches

$ORACLE_HOME/OPatch/opatch util listorderedinactivepatches

+ Check the space and size of .patch_storage

du -hs $ORACLE_HOME/.patch_storage

Deleting the inactive patch :-

1. Execute deleteinactivepatches without setting opatch.properties to retain=2 (default is retain=1)

opatch util deleteinactivepatches -silent

 

export PATH=$PATH:$ORACLE_HOME/OPatch

nohup opatch util deleteinactivepatches -silent > opatch_output.log 2>&1 &

2 Display inactive patches

opatch lsinventory -inactive


3 Repeat steps 1 and 2 until only 1 inactive patch (for each product) is left

+ Check the space and size of .patch_storage

du -hs $ORACLE_HOME/.patch_storage


For more information on the deleting inactive patches please go through the below MOS document

OPatch 12.2.0.1.37+ Introduces a New Feature to Delete Inactive Patches in the ORACLE_HOME/.patch_storage Directory ( Doc ID 2942102.1 )

appsdbahelp

17+ years of experience in Oracle Database, Oracle Cloud Infrastructure(OCI), Oracle EBS on Cloud, Oracle E-Business Suite, DevOps tools, Oracle WebLogic, Oracle Application Server, Oracle Access Manager and various Operating System flavors including Redhat Linux, UNIX (Solaris, HP-UX) and Windows. Expert in Oracle9i/10g/11g/12c/19c database administration, upgrade, configuration and tuning. Experience in Oracle E-Business Suite technological stack, including architecture, installation, configuration, maintenance, tuning, cloning and patching procedures. Expert in Oracle Cloud Infrastructure(OCI), Oracle EBS On Cloud and Oracle EBS Cloud Manager Experience with Oracle Cloud Solution and Expert of Oracle ERP/Oracle HCM Cloud deployment Experience in Terraform, JSON and chef cloud infrastructure automation framework Knowledge of ASM, Data Guard, Real Application Cluster, Exadata and Exalogic Knowledge of Oracle Enterprise Manager(OEM) Grid Control, Oracle WebLogic, Oracle Internet Directory, Oracle Access Manager and Apache Ability to analyze problem, develops solutions and bring program/project execution to completion.

Post a Comment

Previous Post Next Post