系統(tǒng)：CentOS7.9
環(huán)境：oracle 19.14 + rac
說(shuō)明：1-9步驟兩個(gè)節(jié)點(diǎn)均需執(zhí)行
1、備份目錄
[root@hisdb1 ~]# tar -zcvPf oraclebase.tar.gz /u01/app/oracle >/dev/null
[root@hisdb1 ~]# tar -zcvPf oraInventory.tar.gz /u01/app/oraInventory >/dev/null
[root@hisdb1 ~]# tar -zcvPf gridbase.tar.gz /u01/app/grid >/dev/null
[root@hisdb1 ~]# tar -zcvPf gridhome.tar.gz /u01/app/11.2.0/grid >/dev/null
2、安裝OPatch
說(shuō)明：19.15 DB的RU編號(hào)是：33806152，GI的RU編號(hào)是：33803476，OPatch版本至少為12.2.0.1.29
sftp> cd /tmp
sftp> lcd F:\installmedium\19c\19.15
sftp> put
p6880880_190000_Linux-x86-64.zip
[grid@hisdb1:/tmp]$ unzip -q -o
p6880880_190000_Linux-x86-64.zip -d $ORACLE_HOME
[oracle@hisdb1:/tmp]$ unzip -q -o
p6880880_190000_Linux-x86-64.zip -d $ORACLE_HOME
[grid@hisdb1 tmp]$ opatch version
OPatch Version: 12.2.0.1.30
OPatch succeeded.
[oracle@hisdb1 tmp]$ opatch version
OPatch Version: 12.2.0.1.30
OPatch succeeded.
3、驗(yàn)證Oracle Inventory
檢查DB Home和Grid Home的補(bǔ)丁列表里補(bǔ)丁的一致性.
[grid@hisdb1:/home/grid]$ $ORACLE_HOME/OPatch/opatch lsinventory -detail -oh $ORACLE_HOME
[oracle@hisdb1:/home/oracle]$ $ORACLE_HOME/OPatch/opatch lsinventory -detail -oh $ORACLE_HOME
4、下載及解壓Patch
[root@hisdb1 /]# mkdir /upgrade
[root@hisdb1 /]# chown -R grid:oinstall /upgrade
sftp> lcd F:\installmedium\19c\19.15
sftp> cd /home/grid
sftp> put
p33803476_190000_Linux-x86-64.zip
[grid@hisdb1 ~]$ unzip -q
p33803476_190000_Linux-x86-64.zip -d /upgrade
5、運(yùn)行opatch沖突檢查
確定當(dāng)前安裝的一次性修補(bǔ)程序是否與此修補(bǔ)程序33803476沖突
grid用戶：
% $ORACLE_HOME/OPatch/opatch prereq
CheckConflictAgainstOHWithDetail -phBaseDir?/upgrade/33803476/33806152
% $ORACLE_HOME/OPatch/opatch prereq
CheckConflictAgainstOHWithDetail -phBaseDir?/upgrade/33803476/33815596
% $ORACLE_HOME/OPatch/opatch prereq
CheckConflictAgainstOHWithDetail -phBaseDir?/upgrade/33803476/33815607
% $ORACLE_HOME/OPatch/opatch prereq
CheckConflictAgainstOHWithDetail -phBaseDir?/upgrade/33803476/33911149
% $ORACLE_HOME/OPatch/opatch prereq
CheckConflictAgainstOHWithDetail -phBaseDir?/upgrade/33803476/33575402
oracle用戶：
% $ORACLE_HOME/OPatch/opatch prereq
CheckConflictAgainstOHWithDetail -phBaseDir?/upgrade/33803476/33806152
% $ORACLE_HOME/OPatch/opatch prereq
CheckConflictAgainstOHWithDetail -phBaseDir?/upgrade/33803476/33815596
6、運(yùn)行OPatch檢查系統(tǒng)空間
檢查ORACLE_HOME文件系統(tǒng)是否有足夠的可用空間，以便應(yīng)用補(bǔ)丁程序：
6.1、grid用戶
[grid@hisdb1:/home/grid]$ vi
/tmp/patch_lists_gihome.txt

/upgrade/33803476/33806152

/upgrade/33803476/33815596

/upgrade/33803476/33815607

/upgrade/33803476/33911149

/upgrade/33803476/33575402
運(yùn)行以下命令檢查Grid Infrastructure home是否有足夠空間.
[grid@hisdb1:/home/grid]$ $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile
/tmp/patch_lists_gihome.txt
6.2、oracle用戶
[oracle@hisdb1:/home/oracle]$ vi
/tmp/patch_lists_dbhome.txt

/upgrade/33803476/33806152

/upgrade/33803476/33815596
運(yùn)行以下命令檢查oracle home是否有足夠空間.
[oracle@hisdb1:/home/oracle]$ $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile
/tmp/patch_list_dbhome.txt
7、一次性補(bǔ)丁沖突檢測(cè)和解決
[root@hisdb1 ~]#
/u01/app/19.3.0/grid/OPatch/opatchauto apply /upgrade/33803476 -analyze
[root@hisdb1 ~]#
/u01/app/19.3.0/grid/OPatch/opatchauto rollback /upgrade/33803476 -analyze
8、自動(dòng)補(bǔ)丁安裝
[root@hisdb1 ~]# export PATH=$
PATH:/u01/app/19.3.0/grid/OPatch (說(shuō)明：/u01/app/19.3.0/grid為GRID_HOME)
[root@hisdb1 ~]# opatchauto apply /upgrade/33803476
9、檢查 grid 補(bǔ)丁
[grid@hisdb1 ~]$ opatch lspatches
33911149;TOMCAT RELEASE UPDATE 19.0.0.0.0 (33911149)
33815607;ACFS RELEASE UPDATE 19.15.0.0.0 (33815607)
33815596;OCW RELEASE UPDATE 19.15.0.0.0 (33815596)
33806152;Database Release Update : 19.15.0.0.220419 (33806152)
33575402;DBWLM RELEASE UPDATE 19.0.0.0.0 (33575402)
OPatch succeeded.
[grid@hisdb1 ~]$ sqlplus -version
SQL*Plus: Release 19.0.0.0.0 - Production
Version 19.15.0.0.0
10、加載SQL
說(shuō)明：此步驟為加載變化的SQL到數(shù)據(jù)庫(kù)，RAC環(huán)境只需在節(jié)點(diǎn)1執(zhí)行。
[oracle@
hisdb1:/u01/app/oracle/product/19.3.0/db/OPatch]$ ./datapatch -verbose
11、處理無(wú)效對(duì)象
因之前datapatch命令會(huì)加載SQL，此過(guò)程可能會(huì)產(chǎn)生無(wú)效對(duì)象，節(jié)點(diǎn)1執(zhí)行@utlrp.sql腳本處理無(wú)效對(duì)象
SQL> @?/rdbms/admin/utlrp.sql