Oracle RAC 补丁升级 19.9 升级 19.11

准备
1.先自行重启grid&db
2./u01/soft 放置升级补丁及最新Opath

1 opatch 升级
复制node1
chown -R grid:oinstall /u01/soft/
mv /u01/app/19.9.0.0/grid/OPatch /u01/app/19.9.0.0/grid/OPatchold
mv /u01/app/oracle/product/19.9.0.0/dbhome_1/OPatch /u01/app/oracle/product/19.9.0.0/dbhome_1/OPatchold

chown grid:oinstall /u01/app/19.9.0.0/grid/.
su - grid -c "unzip -d /u01/app/19.9.0.0/grid/ /u01/soft/p6880880_210000_Linux-x86-64.zip "
su - oracle -c "unzip -d /u01/app/oracle/product/19.9.0.0/dbhome_1/ /u01/soft/p6880880_210000_Linux-x86-64.zip "
su - grid -c "unzip -d /u01/soft/ /u01/soft/p32841500_190000_Linux-x86-64.zip "

复制node2
chown -R grid:oinstall /u01/soft/
mv /u01/app/19.9.0.0/grid/OPatch /u01/app/19.9.0.0/grid/OPatchold
mv /u01/app/oracle/product/19.9.0.0/dbhome_1/OPatch /u01/app/oracle/product/19.9.0.0/dbhome_1/OPatchold

chown grid:oinstall /u01/app/19.9.0.0/grid/.
su - grid -c "unzip -d /u01/app/19.9.0.0/grid/ /u01/soft/p6880880_210000_Linux-x86-64.zip "
su - oracle -c "unzip -d /u01/app/oracle/product/19.9.0.0/dbhome_1/ /u01/soft/p6880880_210000_Linux-x86-64.zip "
su - grid -c "unzip -d /u01/soft/ /u01/soft/p32841500_190000_Linux-x86-64.zip "

2 开始升级，先进行node1成功后，再进行node2
cd /u01/app/19.9.0.0/grid/OPatch
./opatchauto apply /u01/soft/32841500

3.一个节点完成即可
cd $ORACLE_HOME/OPatch
SQL> startup
SQL> alter pluggable database all open;
SQL> ./datapatch -verbose

cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> @utlrp.sql

备注：非必须操作
node2
准备
5分钟后执行
chmod 777 /u01/app/oraInventory/ContentsXML/oui-patch.xml

rac_node2_ip=10.84.116.3
su - grid -c “scp -r /u01/app/19.9.0.0/grid/inventory/oneoffs ${rac_node2_ip}:/u01/app/19.9.0.0/grid/inventory/”
su - oracle -c"scp -r /u01/app/oracle/product/19.9.0.0/dbhome_1/inventory/oneoffs ${rac_node2_ip}:/u01/app/oracle/product/19.9.0.0/dbhome_1/inventory/"
su - grid -c “scp /u01/app/oraInventory/ContentsXML/oui-patch.xml ${rac_node2_ip}:/u01/app/oraInventory/ContentsXML/”