Oracle11g RAC PSU补丁安装

2022-08-14 08:05:31

GI版本: 11.2.0.4
DB版本: 11.2.0.4
Opatch: Opatch_11.2.0.3.27.zip
GI PSU: p31718723_112040_Linux-x86-64_GI.zip

OCW：29938455
ACFS：29509309
DB PSU：31537677

grid用户$ORACLE_HOME目录
/u01/app/11.2.0/grid
oracle用户$ORACLE_HOME目录
/u01/app/oracle/product/11.2.0/db_home

GI PSU解压目录，注意权限
/home/grid/31718723
/home/oracle/31718723

步骤：
节点1升级GI补丁
节点2升级GI补丁
节点1升级db补丁
节点2升级db补丁
节点1刷新参数配置
节点2刷新参数配置
节点1升级数据库数据字典
节点2升级数据库数据字典

升级oracle和grid目录下的Opatch，步骤略，注意权限

1、节点1应用GI补丁

#root用户执行
/u01/app/11.2.0/grid/crs/install/rootcrs.pl -unlock

$grid用户执行
/u01/app/11.2.0/grid/OPatch/opatch napply -oh /u01/app/11.2.0/grid -local /home/grid/31718723/29938455
/u01/app/11.2.0/grid/OPatch/opatch napply -oh /u01/app/11.2.0/grid -local /home/grid/31718723/29509309
/u01/app/11.2.0/grid/OPatch/opatch napply -oh /u01/app/11.2.0/grid -local /home/grid/31718723/31537677

2、节点2应用GI补丁

#root用户执行
/u01/app/11.2.0/grid/crs/install/rootcrs.pl -unlock

$grid用户执行
/u01/app/11.2.0/grid/OPatch/opatch napply -oh /u01/app/11.2.0/grid -local /home/grid/31718723/29938455
/u01/app/11.2.0/grid/OPatch/opatch napply -oh /u01/app/11.2.0/grid -local /home/grid/31718723/29509309
/u01/app/11.2.0/grid/OPatch/opatch napply -oh /u01/app/11.2.0/grid -local /home/grid/31718723/31537677

3、节点1应用database补丁

$oracle用户执行
/home/oracle/31718723/29938455/custom/server/29938455/custom/scripts/prepatch.sh -dbhome /u01/app/oracle/product/11.2.0/db_home
/u01/app/oracle/product/11.2.0/db_home/OPatch/opatch napply -oh /u01/app/oracle/product/11.2.0/db_home -local  /home/oracle/31718723/29938455/custom/server/29938455
/u01/app/oracle/product/11.2.0/db_home/OPatch/opatch apply -oh /u01/app/oracle/product/11.2.0/db_home -local  /home/oracle/31718723/31537677
/home/oracle/31718723/29938455/custom/server/29938455/custom/scripts/postpatch.sh -dbhome /u01/app/oracle/product/11.2.0/db_home

4、节点2应用database补丁

$oracle用户执行
/home/oracle/31718723/29938455/custom/server/29938455/custom/scripts/prepatch.sh -dbhome /u01/app/oracle/product/11.2.0/db_home
/u01/app/oracle/product/11.2.0/db_home/OPatch/opatch napply -oh /u01/app/oracle/product/11.2.0/db_home -local  /home/oracle/31718723/29938455/custom/server/29938455
/u01/app/oracle/product/11.2.0/db_home/OPatch/opatch apply -oh /u01/app/oracle/product/11.2.0/db_home -local  /home/oracle/31718723/31537677
/home/oracle/31718723/29938455/custom/server/29938455/custom/scripts/postpatch.sh -dbhome /u01/app/oracle/product/11.2.0/db_home

5、节点1刷新参数配置

#root用户执行
/u01/app/11.2.0/grid/rdbms/install/rootadd_rdbms.sh
/u01/app/11.2.0/grid/crs/install/rootcrs.pl -patch

6、节点2刷新参数配置

#root用户执行
/u01/app/11.2.0/grid/rdbms/install/rootadd_rdbms.sh
/u01/app/11.2.0/grid/crs/install/rootcrs.pl -patch

7、节点1、节点2升级数据库数据字典

[oracle@rac1:/home/oracle]$sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.4.0 Production on Wed Apr 14 14:41:08 2021

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> select open_mode from v$database;

OPEN_MODE
--------------------
READ WRITE

SQL> @?/rdbms/admin/catbundle.sql psu apply

执行完后查询PSU更新信息：

SQL> set line 150 
SQL> col ACTION_TIME for a30 
SQL> col ACTION for a8
SQL> col NAMESPACE for a8 
SQL> col VERSION for a10
SQL> col BUNDLE_SERIES for a5 
SQL> col COMMENTS for a20
SQL> select * from dba_registry_history; 

ACTION_TIME                    ACTION   NAMESPAC VERSION            ID BUNDL COMMENTS
------------------------------ -------- -------- ---------- ---------- ----- --------------------
13-APR-21 02.26.05.666106 PM   APPLY    SERVER   11.2.0.4            0 PSU   Patchset 11.2.0.2.0
14-APR-21 02.39.37.788345 PM   APPLY    SERVER   11.2.0.4       201020 PSU   PSU 11.2.0.4.201020

码农公寓