上传并解压补丁包并赋权

上传
p37257886_190000_Linux-x86-64.zip
p6880880_190000_Linux-x86-64
解压，赋权
unzip p37257886_190000_Linux-x86-64.zip
chmod 775 -R 37257886

确认已经安装的补丁包与此补丁包是否冲突

Grid:
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /soft/37257886/37260974
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /soft/37257886/37268031
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /soft/37257886/37266638
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /soft/37257886/37461387
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /soft/37257886/36758186
 
Oracle:
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /soft/37257886/37260974
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /soft//37257886/37268031

检查opatch 版本

2个节点的oracle、grid都要更新opatch
opatch version

更新opatch

1 ,2 节点分别执行：

oracle:
cd $ORACLE_HOME 
mv OPatch OPatch.bak
unzip p6880880_190000_Linux-x86-64 -d $ORACLE_HOME
 
grid:
cd $ORACLE_HOME 
mv OPatch OPatch.bak
unzip p6880880_190000_Linux-x86-64 -d $ORACLE_HOME

查看补丁

opatch lspatches

打补丁

一节点：（root用户）
cd /soft
export PATH=$PATH:/u01/app/19.3.0/grid/OPatch
opatchauto apply /soft/37257886 -oh /u01/app/19.3.0/grid
 
export PATH=$PATH:/u01/app/oracle/product/19.3.0/db/OPatch
opatchauto apply /soft/37257886 -oh /u01/app/oracle/product/19.3.0/db
 
su - grid -c 'opatch lspatches'
su - oracle -c 'opatch lspatches'
 
二节点：（root 用户）
export PATH=$PATH:/u01/app/19.3.0/grid/OPatch
opatchauto apply /soft/37257886 -oh /u01/app/19.3.0/grid
 
export PATH=$PATH:/u01/app/oracle/product/19.3.0/db/OPatch
opatchauto apply /soft/37257886 -oh /u01/app/oracle/product/19.3.0/db