Oracle11g（RAC）20210119补丁安装（32131250）

Oracle11gRAC升级补丁——20210119

21年1月19日和20年10月20的补丁安装命令基本一致
注意事项：
关闭数据库
先打GI psu
再打DB psu
grid打 acfs
打ojvm之前停集群
一定要仔细阅读readme！
打补丁要指定补丁安装目录
opatch auto -oh $ORACLE_HOME

准备：root用户上传补丁到/u01/software并授权和更改属主

1、介质授权：
# chmod 755 /u01/software/p32131250_112040_Linux-x86-64.zip
# chmod 755 /u01/software/p6880880_112000_Linux-x86-64_11.2.0.3.27.zip
2、更改属主：
# chown grid:oinstall /u01/software/p32131250_112040_Linux-x86-64.zip
# chown grid:oinstall /u01/software/p6880880_112000_Linux-x86-64_11.2.0.3.27.zip
需注意，一定要查看好补丁的权限和属主，不更改会在补丁执行命令时报错，一不小心就很容易犯错

解压补丁
su - grid 
unzip /u01/software/p32131250_112040_Linux-x86-64.zip -d /u01/software

exit

su - oracle

unzip /u01/software/p31668908_112040_Linux-x86-64.zip -d /u01/software

exit

1、备份Grid和Oracle软件

1、将Oracle软件打包备份
# cd /u01/app/oracle/product/11.2.0.4/ 
# tar -pzcvf oraclehome1.tar *

2、将Grid软件打包备份
# cd /u01/app/11.2.0.4/grid/
# tar -cvf gihome.tar *

2、升级（解压）OPatch

（1）grid用户：

# su - grid

$ rm -rf /u01/app/11.2.0.4/grid/OPatch*

$ unzip /u01/software/p6880880* -d $ORACLE_HOME/

$ opatch version

$ exit

（2）oracle用户：

# su - oracle

$ rm -rf $ORACLE_HOME/OPatch*

$ unzip /u01/software/p6880880* -d $ORACLE_HOME/

$ opatch version

$ exit

3、安装补丁

（1）打gi psu（31983472）

----gi psu----
root用户执行以下命令可将GI的 31983472（gi psu）、29938455（ocw）、29509309（acfs）、三个补丁打上
# <GRID_HOME> OPatch/opatch auto <UNZIPPED_PATCH_LOCATION> /32131250 -oh <GRID_HOME>

输出如下：
[root@ceshi2 software]# /u01/app/11.2.0.4/grid/OPatch/opatch auto /u01/software/32131250 -oh /u01/app/11.2.0.4/grid
Executing /u01/app/11.2.0.4/grid/perl/bin/perl /u01/app/11.2.0.4/grid/OPatch/c/grid -paramfile /u01/app/11.2.0.4/grid/crs/install/crsconfig_params

This is the main log file: /u01/app/11.2.0.4/grid/cfgtoollogs/opatchauto2021-0

This file will show your detected configuration and all the steps that opatcha
/u01/app/11.2.0.4/grid/cfgtoollogs/opatchauto2021-01-23_11-51-19.report.log

2021-01-23 11:51:19: Starting Clusterware Patch Setup
Using configuration parameter file: /u01/app/11.2.0.4/grid/crs/install/crsconf

Stopping CRS...
Stopped CRS successfully

patch /u01/software/32131250/31983472  apply successful for home  /u01/app/11.2.0.4/grid 

Starting CRS...
Installing Trace File Analyzer
CRS-4123: Oracle High Availability Services has been started.

opatch auto succeeded.
[root@ceshi2 software]#

成功！
因为之前打过上一个季度的补丁，所以只升级了gi psu

验证：

su - grid
[+ASM1][grid@ceshi1 ~]$ opatch lspatches
31983472;Database Patch Set Update : 11.2.0.4.210119 (31983472)
29509309;ACFS Patch Set Update : 11.2.0.4.190716 (29509309)
29938455;OCW Patch Set Update : 11.2.0.4.191015 (29938455)

OPatch succeeded.
[+ASM1][grid@ceshi1 ~]$

（2）打db psu（31983472）

----db psu----
root用户执行以下命令可将DB的 31983472（db psu）、29938455（ocw）两个补丁打上
# <ORACLE_HOME> OPatch/opatch auto <UNZIPPED_PATCH_LOCATION> /32131250 -oh <ORACLE_HOME_HOME>

输出如下：
[root@ceshi1 software]# /u01/app/oracle/product/11.2.0.4/OPatch/opatch auto /u01/software/32131250 -oh /u01/app/oracle/product/11.2.0.4
Executing /u01/app/11.2.0.4/grid/perl/bin/perl /u01/app/oracle/product/11.2.0.4/OPatch/crs/patch11203.pl -patchdir /u01/software -patchn 32131250 -oh /u01/app/oracle/product/11.2.0.4 -paramfile /u01/app/11.2.0.4/grid/crs/install/crsconfig_params

This is the main log file: /u01/app/oracle/product/11.2.0.4/cfgtoollogs/opatchauto2021-01-25_07-24-25.log

This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
/u01/app/oracle/product/11.2.0.4/cfgtoollogs/opatchauto2021-01-25_07-24-25.report.log

2021-01-25 07:24:25: Starting Clusterware Patch Setup
Using configuration parameter file: /u01/app/11.2.0.4/grid/crs/install/crsconfig_params

Stopping RAC /u01/app/oracle/product/11.2.0.4 ...
Stopped RAC /u01/app/oracle/product/11.2.0.4 successfully

patch /u01/software/32131250/31983472  apply successful for home  /u01/app/oracle/product/11.2.0.4 

Starting RAC /u01/app/oracle/product/11.2.0.4 ...
Started RAC /u01/app/oracle/product/11.2.0.4 successfully

opatch auto succeeded.
[root@ceshi1 software]# 

成功！
因为之前打过上一个季度的补丁，所以只升级了db psu

验证：

#1、在查看系统中查看补丁版本
su - oracle
[orcl1][oracle@ceshi1 ~]$ opatch lspatches  
31983472;Database Patch Set Update : 11.2.0.4.210119 (31983472)
31668908;OJVM PATCH SET UPDATE 11.2.0.4.201020
29938455;OCW Patch Set Update : 11.2.0.4.191015 (29938455)

OPatch succeeded.
[orcl1][oracle@ceshi1 ~]$ 

#2、查看具体的补丁号：
$ opatch lsinventory

#3、在数据库中查询补丁版本：
set line 200
col ACTION_TIME for a35
col COMMENTS for a45
select ACTION_TIME,version,COMMENTS from registry$history;

第二个节点执行相同操作

4、升级数据库数据字典与视图

在升级完补丁之后需要数据库中执行脚本升级数据字典与视图

#以下步骤将修改后的SQL文件加载到数据库中。对于Oracle RAC环境，仅在一个节点上执行这些步骤。
catbundle.sql 脚本，如下所示：

cd $ ORACLE_HOME/rdbms/admin 
sqlplus / nolog 
SQL> CONNECT / AS SYSDBA 
SQL> STARTUP 
SQL> @ catbundle.sql psu apply 
SQL> QUIT

数据字典与视图升级完毕！

打OJVM请参考：https://blog.csdn.net/ly7472712/article/details/111186830
有什么问题欢迎大家留言
至此结束，谢谢！