最少宕机时间给GI打补丁
更新时间： 2021-10-25 16:54
Steps for Minimal Downtime Grid Infrastructure Out of Place ( OOP ) Patching using gridSetup.sh (Doc ID 2662762.1)
In this Document
Goal
Solution
1) Installing and Patching the Grid infrastructure (software only)
2) Switching the Grid Infrastructure Home
References
APPLIES TO:
Oracle Database - Enterprise Edition - Version 19.6.0.0.0 and later
Information in this document applies to any platform.
GOAL
This document describes a procedure to perform Grid Infrastructure Home Out of Place patching using gridSetup.sh for a Cluster
SOLUTION
Overview
This document provides the procedure to perform 'out of place patching' of Grid Infrastructure
This is applicable only for cluster environment,not the SIHA(Oracle Restart)
In general, the following steps are involved:
1) Installing and Patching the Grid infrastructure (software only)
2) Switching the Grid Infrastructure Home
Existing environment.
Grid Infrastructure 19.6 running on Linux x86-64
[oracle@node1 crsconfig]$ opatch lspatches
30655595;TOMCAT RELEASE UPDATE 19.0.0.0.0 (30655595)
30557433;Database Release Update : 19.6.0.0.200114 (30557433)
30489632;ACFS RELEASE UPDATE 19.6.0.0.0 (30489632)
30489227;OCW RELEASE UPDATE 19.6.0.0.0 (30489227)
[oracle@node2 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE node1 STABLE
ONLINE ONLINE node2 STABLE
ora.chad
ONLINE ONLINE node1 STABLE
ONLINE ONLINE node2 STABLE
ora.helper
ONLINE ONLINE node1 IDLE,STABLE
ONLINE ONLINE node2 IDLE,STABLE
ora.net1.network
ONLINE ONLINE node1 STABLE
ONLINE ONLINE node2 STABLE
ora.ons
ONLINE ONLINE node1 STABLE
ONLINE ONLINE node2 STABLE
ora.proxy_advm
OFFLINE OFFLINE node1 STABLE
OFFLINE OFFLINE node2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
1 ONLINE ONLINE node1 STABLE
2 ONLINE ONLINE node2 STABLE
3 ONLINE OFFLINE STABLE
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE node2 STABLE
ora.MGMTLSNR
1 ONLINE ONLINE node2 169.254.15.144 10.64
.222.238,STABLE
ora.OCRVFDG.dg(ora.asmgroup)
1 ONLINE ONLINE node1 STABLE
2 ONLINE ONLINE node2 STABLE
3 OFFLINE OFFLINE STABLE
ora.asm(ora.asmgroup)
1 ONLINE ONLINE node1 Started,STABLE
2 ONLINE ONLINE node2 Started,STABLE
3 OFFLINE OFFLINE STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
1 ONLINE ONLINE node1 STABLE
2 ONLINE ONLINE node2 STABLE
3 OFFLINE OFFLINE STABLE
ora.node1.vip
1 ONLINE ONLINE node1 STABLE
ora.node2.vip
1 ONLINE ONLINE node2 STABLE
ora.cvu
1 ONLINE ONLINE node2 STABLE
ora.mgmtdb
1 ONLINE ONLINE node2 Open,STABLE
ora.orcl.db
1 ONLINE ONLINE node1 Open,HOME=/u01/app/o
racle/product/19c/db
home_1,STABLE
2 ONLINE ONLINE node2 Open,HOME=/u01/app/o
racle/product/19c/db
home_1,STABLE
ora.qosmserver
1 ONLINE ONLINE node2 STABLE
ora.rhpserver
1 ONLINE ONLINE node2 STABLE
ora.scan1.vip
1 ONLINE ONLINE node2 STABLE
----------------------------------------------------------------------
[oracle@node1 crsconfig]$ ps -ef | grep d.bin
root 1257 1 0 11:12 ? 00:04:30 /u01/app/19c/grid/bin/ohasd.bin reboot
root 1607 1 0 11:12 ? 00:02:18 /u01/app/19c/grid/bin/orarootagent.bin
oracle 1752 1 0 11:12 ? 00:02:26 /u01/app/19c/grid/bin/oraagent.bin
oracle 1801 1 0 11:12 ? 00:01:17 /u01/app/19c/grid/bin/mdnsd.bin
oracle 1803 1 0 11:12 ? 00:03:07 /u01/app/19c/grid/bin/evmd.bin
oracle 1897 1 0 11:12 ? 00:01:22 /u01/app/19c/grid/bin/gpnpd.bin
1) Installing and Patching the Grid infrastructure (software only)
Download 19.3. from the OTN Link
https://www.oracle.com/database/ ... inux-downloads.html
LINUX.X64_193000_grid_home.zip
Download the 19.7 RU
30899722 GI RELEASE UPDATE 19.7.0.0.0
Unzip the software to destination Gridhome on node1
unzip -d LINUX.X64_193000_grid_home.zip /u01/app/19.7.0.0/grid
Ensure the directory "/u01/app/19.7.0.0/grid" is writable on other nodes for gridInfrastructure owner
Apply the patch and configure the software .
/u01/app/19.7.0.0/grid/gridSetup.sh -ApplyRU 3089972
Chose the option "Install Software only" and select all the nodes.
2) Switching the Grid Infrastructure Home
1.Run the gridSetup.sh from the target home
/u01/app/19.7.0.0/grid/gridSetup.sh -SwitchGridhome
It will launch the GUI (you could run it in silent as well with a response file)
During this phase, you can select the automated root.sh option if you wanted. Otherwise it will prompt the root.sh.
2. When prompted, run "root.sh" on the first node, once this completes run "root.sh" on the remaining nodes
/u01/app/19.7.0.0/grid/root.sh
CRS status after patching.
[oracle@node1 crsconfig]$ opatch lspatches
30898856;TOMCAT RELEASE UPDATE 19.0.0.0.0 (30898856)
30894985;OCW RELEASE UPDATE 19.7.0.0.0 (30894985)
30869304;ACFS RELEASE UPDATE 19.7.0.0.0 (30869304)
30869156;Database Release Update : 19.7.0.0.200414 (30869156)
OPatch succeeded.
[oracle@node1 crsconfig]$ crsctl query crs activeversion -f
Oracle Clusterware active version on the cluster is [19.0.0.0.0]. The cluster upgrade state is [NORMAL]. The cluster active patch level is [3633918477].
[oracle@node1 crsconfig]$ ps -ef | grep d.bin
oracle 1958 4877 0 20:15 pts/4 00:00:00 grep --color=auto d.bin
oracle 11147 1 0 19:44 ? 00:00:00 /u01/app/19.7.0.0/grid/bin/tnslsnr LISTENER_SCAN1 -no_crs_notify -inherit
root 31188 1 2 19:32 ? 00:00:59 /u01/app/19.7.0.0/grid/bin/ohasd.bin reboot CRS_AUX_DATA=CRS_AUXD_TGIP=yes;_ORA_BLOCKING_STACK_LOCALE=AMERICAN_AMERICA.AL32UTF8
oracle 31273 1 0 19:32 ? 00:00:14 /u01/app/19.7.0.0/grid/bin/oraagent.bin
REFERENCES
NOTE:2419319.1 - Grid Infrastructure Out of Place ( OOP ) Patching using opatchauto
NOTE:2284825.1 - SRDC - Service Request Data Collection for Grid Infrastructure and RAC Install Upgrade Patch
