SAP Note 1696869 - Strategy for Patching of Oracle Homes with Minimal Downtime

Component : Oracle - Oracle Real Application Clusters (RAC)

Solution : https://service.sap.com/sap/support/notes/1696869 (SAP Service marketplace login required)

Summary :
This SAP note outlines a strategy for patching Oracle Homes with minimal downtime using the concept of parallel Oracle Homes. Key tools such as Oracle Universal Installer (OUI) and OPatch are utilized in a process where a new, inactive Oracle Home is prepared alongside the active one. Once patches are applied to the new Oracle Home, a controlled switch is performed during which the database and services are briefly stopped to transition to the newly patched Oracle Home. This technique minimizes system downtime and is applicable for Oracle database releases 11.2.0.3 and higher on UNIX/LINUX systems only. It advantages include less disruption and reduced patch conflict risks.

Key words :
installation oracle home<ihrdbms_new> = /oracle/qa1/112032_201206 <ohrdbms> = oracle home runtime locationthe runtime location <ohrdbms>, oracle home oracle_home /oracle/qa1/112_64 <ohrdbms> /oracle/qa1/112_64 <ihrdbms> /oracle/qa1/11203 installation, oracle home switch <ihrdbms_active> /oracle/qa1/112032_201206 <ihrdbms_inactiv> /oracle/qa1/112032_201205 appendix, parallel oracle homes oracle_home /oracle/qa1/112_64 <ohrdbms> /oracle/qa1/112_64, inactive oracle home switching active oracle homethe term 'switching active oracle home' denotes, oracle home switch <ihrdbms_active> /oracle/qa1/112032_201205 <ihrdbms_inactiv> /oracle/qa1/112032_201206, <ohrdbms> = /oracle/qa1/112_64or<ohrdbms> = /oracle/qa1/112see, performing patch-post-installation stepsfor sbp post-installation instructions, installation oracle home<ihrdbms_old> = /oracle/qa1/112032_201205 <ihrdbms_new>, oracle documentation oracle database installation guide 11g release 2

Related Notes :

1614823Cloning Oracle database software
1431800Oracle 11.2.0: Central Technical Note