oracle 11g 通过unlock打补丁PSU
适用范围
11g RAC 打补丁时,遇到权限问题
问题概述
问题原因
解决方案
关闭集群
tar -pcvf /oracleback/app.tar app
tar -pxvf /oracleback/app.tar -C /oracle
找出文件数量较多的目录,手动删除无效trace
ls -aR /oracle 2>/dev/null | awk '/:$/{if(fileCount>999){print fileCount,dirName};dirName=substr($0,1,length($0)-1);fileCount=-2}{fileCount++}'
GI补丁
root执行
/oracle/app/11.2.0/grid/crs/install/rootcrs.pl -unlock
grid 执行
--28729234 OCW PATCH SET UPDATE 11.2.0.4.190115
$ORACLE_HOME/OPatch/opatch napply -oh $ORACLE_HOME -local /u01/soft/28813878/28729234 -ocmrf /home/grid/ocm.rsp
--28729245 ACFS PATCH SET UPDATE 11.2.0.4.190115
$ORACLE_HOME/OPatch/opatch napply -oh $ORACLE_HOME -local /u01/soft/28813878/28729245 -ocmrf /home/grid/ocm.rsp
--28729262 DB PSU 11.2.0.4.190115 (INCLUDES CPUJan2019)
$ORACLE_HOME/OPatch/opatch napply -oh $ORACLE_HOME -local /u01/soft/28813878/28729262 -ocmrf /home/grid/ocm.rsp
ORACLE 补丁
oracle 执行
[oracle@rac1 ~]$ /u01/soft/28813878/28729234/custom/server/28729234/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME
/u01/soft/28813878/28729234/custom/server/28729234/custom/scripts/prepatch.sh completed successfully.
--28729234 OCW PATCH SET UPDATE 11.2.0.4.190115 注意路径深度
$ORACLE_HOME/OPatch/opatch napply -oh $ORACLE_HOME -local /u01/soft/28813878/28729234/custom/server/28729234 -ocmrf /home/oracle/ocm.rsp
--28729262 DB PSU 11.2.0.4.190115 (INCLUDES CPUJan2019)
$ORACLE_HOME/OPatch/opatch napply -oh $ORACLE_HOME -local /u01/soft/28813878/28729262 -ocmrf /home/oracle/ocm.rsp
[oracle@rac1 ~]$ /u01/soft/28813878/28729234/custom/server/28729234/custom/scripts/postpatch.sh -dbhome $ORACLE_HOME
root执行
/oracle/app/11.2.0/grid/rdbms/install/rootadd_rdbms.sh
/oracle/app/11.2.0/grid/crs/install/rootcrs.pl -patch