Last updated on NOVEMBER 20, 2019
![]()
HOW TO APPLY ORACLE PATCH (OPATCH) To apply Opatch conditions are db and listener both must be down as opatch will update your current ORACLEHOME with patches. In single instance its not possible. But for RAC instance its possible. As in RAC there will be two seperate oracle home and two seperate instances running once instance on each.
Applies to:Oracle Database - Standard Edition - Version 12.1.0.1 and laterOracle Database - Enterprise Edition - Version 12.1.0.1 and later Oracle Database - Personal Edition - Version 12.1.0.1 and later Oracle Database Cloud Schema Service - Version N/A and later Oracle Database Exadata Express Cloud Service - Version N/A and later Information in this document applies to any platform. Purpose
Explain Database 12c or later Post Patch SQL Automation
Scope
Database release 12c or later extends patch install automation for patches that contain post-patch SQL instructions.
Prior to Oracle 12c such patches required manual intervention to complete the post-patch SQL instructions after restarting the database. Datapatch is the new tool that enables automation of post-patch SQL actions for RDBMS patches. Datapatch resides in the opatch directory i.e $ORACLE_HOME/OPatch folder (On Windows platforms : %ORACLE_HOME%OPatch). Datapatch can be executed to complete post-patch SQL actions after the database is restarted following patch application. For patches that do not have post-patch SQL actions to be performed, calling datapatch is a no-op. For patches that do have post-patch SQL instructions to be invoked on the database instance, datapatch will automatically detect ALL pending actions (from one installed patch or multiple installed patches) and complete the actions as appropriate. Further details on datapatch are provided towards the end of this document. Enterprise Manager and OPatchAuto provide further automation of database patches by calling datapatch automatically after applying the binary patch. Following section describes how various patching tools implement this automation flow. Details
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.
SymptomIt is required to apply an SBP or Patch Set with minimal downtime.
Nowadays it became more and more important to perform patching operations of the Oracle Software with minimal downtime.
The increased frequency of Oracle home patching, combined with smaller maintenance windows and business impact of system downtime made it necessary to find a new approach for patching that minimizes downtime and impact on business.
Patching the Oracle Software with minimal downtime became even more important since a new structure change in SBP has been made. Basically, the new stuctured SBP (Jun 2014) can not be applied on top of any previously applied SBP. Therefore, SAP introduced the 'Patch Migration Script', called 'bpmig'. This script has to be started before the actual installation of the new SBP (which is called Database Bundle Patch - DBBP), in order to prepare the database for the new DBBP installation.
For more information about this change, please read SAP Hotnews note below and the corresponding README file of DBBP: 2011199 SAP Bundle Patches (SBP) - structure changes starting with June 2014 Read more... Environment
Keywords
runInstaller,oracle_home,oracle_base,opatch,mopatch,SBP,SDA,SGR,SXD,Exadata BP,Bundle Patch,SAP Bundle Patch,PSU,GI PSU,Oracle database,Exadata,SuperCluster,Oracle Database Appliance,ODA,SAPDBBP,SAPEXADBBP,SAP DBBP,BUGSFIXED,README,cloning,minimal downtime,out-of-place,out of place,installation,clone,patch,patchset, patch set , KBA , BC-DB-ORA-CCM , (CCMS) Database Monitors , BC-DB-ORA , Oracle , How To
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).![]() Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
![]() Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |