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升级数据库数据字典

[[email protected]:/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